| Problem in cloning operation from the standby DB [message #74699] |
Sun, 06 February 2005 21:05 |
Prasanna Sreenivasa Kumar
Messages: 5
Registered: January 2005
|
Junior Member |
|
|
Hi All,
I have following error in cloning operation from the standby DB.
I have done following steps.
1)Transferred the datafiles,control files and archive log files to our new test environment.
2)We have modified init.ora,config.ora,tnsname.ora,listener.ora,sqlnet.ora by changing the necessary oracle parameters
3)From server manager, we started the DB in nomount and ran
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
4)This created a .trc file in the udump directory.
5)We modified the .trc file by changing the CREATE CONTROLFILE line ( removed the REUSE clause and changed NORESETLOGS to RESETLOGS).
6)Then we tried to run the .trc file and got the following error
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file ‘/orabackup/oradata/FWSIL00/questagent/questtmp01.dbf’
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01507: database not mounted
questtmp01.dbf was not copied from the standby machine, so we got the above error.
The question now is whether can we comment out this particular dbf and run the .trc file? or can we copy the dbf from online standby DB as we cannot make the standby DB offline.
Thanks in advance.
Regards,
Prasanna
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
