Oracle 9.2.0.6 Standard Edition I have issues when I want to switch between my standby and primary database.
I got this error ARCH: Archiving not possible: No standby destinations ARCH: Failed to archive log 1 thread 1 sequence 61 ORA-16014 (See ORA-16014.ora-code.com) signalled during: alter database commit to switchover to standby wi
We are running the Standard Edition so I can't use "log_archive_dest_n ...."
I copy my archive log file with a script and apply them using "recover automatic standby database".
For another system with Enterprise Edition, I'm using these commands without any problems: To switch from Primary to Standby alter database commit to switchover to physical standby with session shutdown; shutdown immediate; startup nomount; alter database mount standby database; alter system set log_archive_dest_state_2=defer scope=both; alter database recover managed standby database disconnect;
To switch from Standby to Primary alter database recover managed standby database finish skip standby logfile; alter database commit to switchover to primary; shutdown immediate startup alter system set log_archive_dest_state_2=enable scope=both;
Question: What do I need to make it work with the Standard Edition ?
<div>Hi,</div> <div> </div> <div>Oracle <a href="http://9.2.0.6">9.2.0.6</a> Standard Edition</div> <div>I have issues when I want to switch between my standby and primary database.</div> <div> </div> <div>I got this error </div> <div>ARCH: Archiving not possible: No standby destinations <br>ARCH: Failed to archive log 1 thread 1 sequence 61 <br>ORA-16014 (See ORA-16014.ora-code.com) signalled during: alter database commit to switchover to standby wi</div> <div> </div> <div>We are running the Standard Edition so I can't use "log_archive_dest _n ...."</div> <div> </div> <div>I copy my archive log file with a script and apply them using " ;recover automatic standby database".</div> <div> </div> <div>For another system with Enterprise Edition, I'm using these commands without any problems:</div> <div>To switch from Primary to Standby</div> <div>alter database commit to switchover to physical standby with session shutdown;<br>shutdown immediate;<br>startup nomount;<br>alter database mount standby database;<br>alter system set log_archive_dest_state_2=defer scope=both ; <br>alter database recover managed standby database disconnect;<br> </div> <div>To switch from Standby to Primary</div> <div>alter database recover managed standby database finish skip standby logfile;<br>alter database commit to switchover to primary;<br>shutdown immediate<br>startup<br>alter system set log_archive_dest_state_2=enable scope =both; <br><br clear="all">Question:</div> <div>What do I need to make it work with the Standard Edition ?</div> <div> </div> <div>Thanks</div> <div>Luc<br>-- <br>Luc Demanche<br>Oracle DBA<br>(514) 867-9977 </div>
