Home » Server Options » Data Guard » Oracle 9i Missing Conrtol and Redolog files
Oracle 9i Missing Conrtol and Redolog files [message #218583] Thu, 08 February 2007 16:26 Go to next message
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 #240922 is a reply to message #218583] Sun, 27 May 2007 15:19 Go to previous messageGo to next message
yogendra@80
Messages: 3
Registered: May 2007
Junior Member
it cant be the case that oracle starts deleting these fils for want of space.....i sniff some human mistake in it...
Re: Oracle 9i Missing Conrtol and Redolog files [message #240923 is a reply to message #240922] Sun, 27 May 2007 15:38 Go to previous messageGo to next message
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.
Re: Oracle 9i Missing Conrtol and Redolog files [message #241399 is a reply to message #218583] Tue, 29 May 2007 08:10 Go to previous messageGo to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

You have to create a Standby Control file after you backup your data, and then copy that standby control file over to the Standby Database. It will detect a Standby Control file, and when you issue "alter database mount standby database;", it will use the control file (be sure the control_files parameter points to the right location).

M
Re: Oracle 9i Missing Conrtol and Redolog files [message #241402 is a reply to message #241399] Tue, 29 May 2007 08:14 Go to previous message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Ista,

Did you check, whether your file system is mounted properly, seems it's not mounted and that's why database is unable to find controlfile.....
Previous Topic: Schema Import on a logical standby db
Next Topic: After the switchover...
Goto Forum:
  


Current Time: Thu Dec 18 13:47:14 CST 2014

Total time taken to generate the page: 0.13453 seconds