Home » Server Options » Data Guard » Adding Control file after switching Standby role (11G R1 Enterprise, RHEL5)
Adding Control file after switching Standby role [message #513228] Fri, 24 June 2011 09:43 Go to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

We recently switched over from Production(DB1) to physical standby(DB2). I would like to add a controlfile to the DB2 configuration as i am not certain when we will be switching back to DB1. Trying to remain on the safe side with adding the controlfile.

Any suggestions.

Kieron
Re: Adding Control file after switching Standby role [message #513231 is a reply to message #513228] Fri, 24 June 2011 11:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no relation between primary and standby control files, they can have their own number of them.

Regards
Michel
Re: Adding Control file after switching Standby role [message #513232 is a reply to message #513231] Fri, 24 June 2011 14:06 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

So i can just do the following:
To add a multiplexed copy of the current control file or to rename a control file:

1.Shut down the database.

2.Copy an existing control file to a new location, using operating system commands.

3.Edit the CONTROL_FILES parameter in the database initialization parameter file to add the new control file name, or to change the existing control filename.

4.Restart the database.
Re: Adding Control file after switching Standby role [message #513233 is a reply to message #513232] Fri, 24 June 2011 14:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Adding Control file after switching Standby role [message #513234 is a reply to message #513233] Fri, 24 June 2011 14:27 Go to previous message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member

Thanks a lot
Previous Topic: How to delete the archive log on the standby ?
Next Topic: Error during Real Time apply
Goto Forum:
  


Current Time: Thu Mar 28 14:38:14 CDT 2024