Oracle 9i Missing Conrtol files
545933Feb 8 2007 — edited Feb 10 2007Greetings,
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 known case(s) where Oracle deletes those files (e.g. due to disk space
or losing connection with the Primary db).
Thanks.