Pete's wrote:
> On May 3, 10:26 am, DA Morgan <damor..._at_psoug.org> wrote:
>> Pete's wrote:
>>> Hi all.
>>> Oracle 10.2.0.3, AIX 5.3 TL05. I have a dataguard setup, primary
>>> db(DB1) on server A, standby db on Server B. TNS info is DB1 for the
>>> primary and DB1_LOC2 for the standby site. Log_archive_dest_2 is
>>> 'SERVICE=DB1_LOC2 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
>>> DB_UNIQUE_NAME=DB1_LOC2 LGWR ASYNC REOPEN=60000 MAX_FAILURE=2000)'
>>> Example of the standby bounce:
>>> shutdown immediate;
>>> startup nomount;
>>> alter database mount standby database;
>>> alter database recover managed standby database disconnect;
>>> After bouncing the standby, querying the primary v$archive_dest, the
>>> standby dest stays in error, in fact ora-3113. Note that I'm able
>>> to connect to the standby db as sysdba, and am able to connect to the
>>> primary. Now, back in 9.2 with Dataguard, in order to get the rfs
>>> processes to send the missing archive logs and resync, you connected
>>> to the primary and performed the following:
>>> alter database archive log stop;
>>> alter database archive log start;
>>> alter system switch logfile;
>>> After the log switch, Oracle would attempt to re-open the standby
>>> archive destination, dest_2. But now, in 10.2, log_archive_start is
>>> an obsolete parameter so this no longer works. I've read thru 10.2
>>> dataguard docs and seem to be missing it. Anyone have any
>>> ideas(short of bouncing the primary), to get the archive logs
>>> transporting again?
>>> TIA,
>>> Pete's
>> This is my normal switchover:
>>
>> On the Primary:
>> -----------------
>> shutdown abort;
>> startup mount;
>> alter database open;
>> alter database commit to switchover to standby with session shutdown wait;
>>
>> On the secondary:
>> -----------------
>> SELECT switchover_status FROM gv$database
>> -- Value returned must be TO_PRIMARY to proceed.
>> alter database commit to switchover to primary with session shutdown wait;
>> startup;
>> alter database recover managed standby database disconnect;
>>
>> Hopefully looking at it will help.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> Thanks for the prompt reply, however, a switch over is not what I'm
> looking at.
>
> I probably should have prefaced my question with an example. Ex. Say
> the server at your standby site is booted on a bi-weekly schedule.
You've got to be kidding. Why?
> All databases at this site are shutdown and the server rebooted. When
> the server is up again, db's are scripted to start automatically, one
> of them being a standby. During the time of reboot, there could have
> been several log switches at the primary site. Now that your standby
> has several files that need to be applied, you have two options to
> sync up the two sites. Given that 'reopen' is set, Oracle RFS
> processes should attempt to retransmit the logs and apply them when
> the standby is in managed recovery mode, or, you can apply them
> manually. I prefer to have Oracle apply them automatically. To get
> Oracle's RFS processes talking again in 9.2, you had to do the stop/
> start of the archiver on the primary and a log switch. With 10.2, I'm
> looking to do the same thing and I'm not finding it.
>
> TIA,
> Pete's
With 10.2 it catches up automagically.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu May 03 2007 - 16:45:22 CDT
