| Query on Standby Switchover [message #177799] |
Fri, 16 June 2006 11:22  |
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 #177978 is a reply to message #177821] |
Sun, 18 June 2006 21:25  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
