I don't have the time right now to elaborate, probably in a couple of hours. Paul is right about the 'commit to switchover' commands. However, his suggestion will 'activate' the standby, thereby invalidating the primary for further usage as a standby. That might not be what you really want. It's also possible to do a switchover, and switchback later. I'll come back on this later today. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === > On 12/7/05, Luc Demanche <lucdemanche@xxxxxxxxx> wrote: >> Hi, >> >> 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 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 ? >> >> Thanks >> Luc >> -- >> Luc Demanche >> Oracle DBA >> (514) 867-9977 -- //www.freelists.org/webpage/oracle-l