| Oracle 9i Missing Conrtol and Redolog files [message #218583] |
Thu, 08 February 2007 16:26  |
Ista
Messages: 14
Registered: January 2007
|
Junior Member |
|
|
Greetings,
The Oracle 9i Standby database could not be mounted.
Here is what I found in the alert_CEMSDB.log:
alter database mount standby database
Fri Jan 19 05:13:11 2007
ORA-00202: controlfile: '/opt/cems/db/oracle/u02/oradata/CEMSDB/control01.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Fri Jan 19 05:13:11 2007
ORA-205 signalled during: alter database mount standby database...
Fri Jan 19 05:13:11 2007
alter database recover managed standby database disconnect from session
ORA-1507 signalled during: alter database recover managed standby databas...
destination database instance is 'started' not 'mounted'
Fri Jan 19 05:13:12 2007
destination database instance is 'started' not 'mounted'
RFS: Possible network disconnect with primary database
Fri Jan 19 05:14:27 2007
I could not find any conrtol files nor redolog files on the standby database.
Is there any know case(s) where Oracle deletes those files (e.g. due to disk space
or losing connection with the Primary db).
Thanks.
|
|
|
|
|
|
| Re: Oracle 9i Missing Conrtol and Redolog files [message #240923 is a reply to message #240922] |
Sun, 27 May 2007 15:38  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
YOU must have to recreate sandby controlfile from primary and multiplex that here according to pfile;
I didnt see such a case in which oracle deletes files for space...doesnt make a sence.
if u have all archived logs just create stand by and copy redologs.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
