QUESTION POSED ON: 18 October 2005
I want to clone my production database into my development server. Both are the same Oracle version but different OS versions (production on Windows NT and development on a Windows 2003 server). I have given the following commands (on the production command prompt -- is it right, or do I have to run the following commands in the development environment after copying all the data and redo log files? Please answer this first.):
- connect internal/Oracle as sysdba
- alter database backup controlfile to trace; (So the trace file has been generated in production in the path defined by init.ora. I copied this trace file in my new development server's "c:oracleadminskbdbsvrudump")
I do not have any database on my development server, only the Oracle server installed.
Now I have created a new instance of SKBDBSVR and edited all the environment settings. Then, I issued the following command:
@c:oracleadminskbdbsvrudumpora00355.sql after connecting internal
login
This is giving the following errors:
ORA-01503 create control file failed
ORA-01158 database already mounted
If you want to see the create ctrl files command, it is given below. My ctrl.sql file:
CREATE CONTROLFILE REUSE DATABASE "PRODUCT1" NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 4
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 (
'D:ORACLEORADATAPRODUCT1REDO01.LOG',
'D:ORACLEORADATAPRODUCT1REDO03.LOG'
) SIZE 2M,
GROUP 2 (
'C:ORACLEORADATAPRODUCT1REDO02.LOG',
'C:ORACLEORADATAPRODUCT1REDO04.LOG'
) SIZE 2M
DATAFILE
'D:ORACLEORADATAPRODUCT1SYSTEM01.DBF',
'D:ORACLEORADATAPRODUCT1RBS01.DBF',
'D:ORACLEORADATAPRODUCT1USERS01.DBF',
'D:ORACLEORADATAPRODUCT1TEMP01.DBF',
'C:ORACLEORADATAPRODUCT1INDX01.DBF',
'D:ORACLEORADATAPRODUCT1DR01.DBF',
'D:ORACLEORADATAPRODUCT1PRODUCT1_STATIC.DBF',
'D:ORACLEORADATAPRODUCT1PRODUCT1_DYNAMIC.DBF',
'D:ORACLEORADATAPRODUCT1PRODUCT1_HIGH_DYNAMIC.DBF'
CHARACTER SET WE8ISO8859P1
;
Then I changed the database name as "SKBDBSVR" in place of "Product1."
|
