Home » Server Options » Data Guard » Query on Standby Switchover
Query on Standby Switchover [message #177799] Fri, 16 June 2006 11:22 Go to next message
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
Member
hi gurus,

one doubt here...

we are planning a switchover making the standby as the primary.

We will not be making the old primary db to standby.

Application testers want old primary back as primary and test the application
with both old primary and new primary.

In this case, How can I make the old primary back to a normal PROD database??

After running, "Alter database commit to switchover to physical standby",
it will create the standby control file, right??

So is the control file overwritten in this case??

Do I need to recreate the control file ??


Waiting for your valuable comments,

Anurag







Re: Query on Standby Switchover [message #177821 is a reply to message #177799] Fri, 16 June 2006 13:21 Go to previous messageGo to next message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Try to do a fail-over instead of a switch-over. After a fail-over you should have 2 primary databases with no data guard.
Re: Query on Standby Switchover [message #177978 is a reply to message #177821] Sun, 18 June 2006 21:25 Go to previous message
anurag078
Messages: 34
Registered: May 2006
Location: West Des Moines
Member
Hi Frank,


What you said is true... I tried the switchover in a database in my Windows PC, and got the following error while recreation of the control file....


ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01229: data file 8 is inconsistent with logs
ORA-01110: data file 8: 'C:\MYDB\PROD2\DATABASE\USERS01.DBF'

================
The solution to this was recreating the control file with
RESETLOGS option, which we dont want in our PROD box.

So I tested FAILOVER option, which successfully made the standby as Primary with keeping the old primary intact.

Implemented in our UNIX boxes and the testers are happy....

Thank you very much for your help,

Best Regards,
Anurag


Previous Topic: Data Script
Next Topic: query on cluster database
Goto Forum:
  


Current Time: Tue Sep 22 12:10:22 CDT 2020