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_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 07 2005 - 08:51:45 CST