Dataguard switchover [message #559708] |
Thu, 05 July 2012 13:03 |
preet_kumar
Messages: 204 Registered: March 2007
|
Senior Member |
|
|
We don't have license to use Active dataguard and the only option i find to disable Active dataguard is to issue the below given command.
DGMGRL> edit database standby set state=apply-off;
Now after this if i do a switchover it does not work and gives error
ORA-16516 current state is invalid for the attempted operation
After issuing the command
DGMGRL > edit database standby set state=apply-on
I can do a switchover but in this case the following query on the standby shows
select 'Using Active Data Guard' ADG from v$managed_standby m,v$database d where m.process like 'MRP%' ;
ADG
-----------------------
Using Active Data Guard
In the apply-off state the logship works and also the logs are being applied on the standby and for reporting i could open the standby in read only mode.But in apply-on state the standby opens always with readonly-with-apply
Please could anyone help me out with this.
|
|
|
|
Re: Dataguard switchover [message #559719 is a reply to message #559708] |
Thu, 05 July 2012 13:34 |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
If you have not licensed Active Data Guard, then don't open the database. Use STARTUP MOUNT, not STARTUP OPEN (which is the default). Then start redo apply. If it is already open and applying, stop the apply and shutdown first. You can do it all from the DGMGRL prompt.
|
|
|