OraFAQ Forum: Data Guard » Adding Control file after switching Standby role

Home » Server Options » Data Guard » Adding Control file after switching Standby role (11G R1 Enterprise, RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Adding Control file after switching Standby role [message #513228]

Fri, 24 June 2011 09:43

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

Report message to a moderator

Re: Adding Control file after switching Standby role [message #513231 is a reply to message #513228]

Fri, 24 June 2011 11:06

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no relation between primary and standby control files, they can have their own number of them.

Regards
Michel

Report message to a moderator

Re: Adding Control file after switching Standby role [message #513232 is a reply to message #513231]

Fri, 24 June 2011 14:06

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.

Report message to a moderator