This content has been marked as final. Show 2 replies
Can you run this query and post the results?
"not allowed" generally means you have a gap. The query should provide the first clues.
If you are using Standard Edition then this isn't really Data Guard, its a poor mans copy of the database and you should not expect it to have Data Guard features.
This is also the default for databases not using Data Guard.
Checking switchover status SWITCHOVER_STATUS -------------------- NOT ALLOWED
Edited by: mseberg on Aug 6, 2012 12:24 PM
Please close the thread Reg:Primary Database and continue posting here as you are in the right forum.
Please post the below:
select max(sequence#) from v$archived_log;Standby:
select max(sequence#) from v$archived_log where applied='YES';
select process,status,sequence# from v$managed_standby;