OraFAQ Forum: Data Guard » One for the guru: Standby Database using Online Redo?

Home » Server Options » Data Guard » One for the guru: Standby Database using Online Redo?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

One for the guru: Standby Database using Online Redo? [message #241753]

Wed, 30 May 2007 09:52

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

When I do a switchover, I'm finding that I have to shut off the log_archive_dest_state_2 on the "new" Standby Database (the one which the database uses when it is the Primary Database). Evidently, the Standby Database is attempting to use this when applying the archived Standby Redo Log. I don't think it should be doing this! Here are some views:

SEQUENCE# APP
---------- ---
597 NO
597 NO => When it was Primary Database
598 YES => When it became Standby Database
598 YES
599 YES
600 YES
601 YES
602 YES

If I don't disable log_archive_dest_state_2 on the Standby Database, I get this error in the Standby Database's ALERT LOG:

Wed May 30 08:28:06 2007
Errors in file /software/app/oracle/admin/MYDB/bdump/ifmis_arc1_3846.trc:
ORA-16009: remote archive log destination must be a STANDBY database

Report message to a moderator

Re: One for the guru: Standby Database using Online Redo? [message #241762 is a reply to message #241753]

Wed, 30 May 2007 10:19

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Its mean when you witch role transition you must DEFER log_archive_dest_2 on standby is it??

Report message to a moderator

Re: One for the guru: Standby Database using Online Redo? [message #241804 is a reply to message #241753]

Wed, 30 May 2007 11:45

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Yes, I do the following:

SQL> alter system set log_archive_dest_state_2=DEFER scope=BOTH;

If I don't, I find that the STANDBY database attempts to forward data to the location in log_archive_dest_2 (which generates an error, because the location there is now the Primary Database).

This is the only parameter which is different between a Physical Standby database and Primary Database (except FAL_CLIENT and FAL_SERVER, which are reversed).

Mike

Report message to a moderator

Re: One for the guru: Standby Database using Online Redo? [message #243298 is a reply to message #241804]

Wed, 06 June 2007 15:52

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

mike

Log_archive_dest_1=’Location=c:\oracle\backup
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
db_unique_name=primary’
Log_archive_dest_2=’Service=to_standby
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=standby’

as we set Log_archive_dest_1 & 2 on both side .then standby shouldnt throw the error for archiving .if we switch over our standby to primary.

Report message to a moderator

Re: One for the guru: Standby Database using Online Redo? [message #243553 is a reply to message #241753]

Thu, 07 June 2007 13:27

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

I'll try this and see if it applies to 9.2. Most of it I haven't used. Thanks,

Mike

Report message to a moderator

Previous Topic:	archiving is not transfering on standby location
Next Topic:	NO. OF REDO LOGS ON PRIMARY AND STANDBY

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 28 19:43:32 CST 2021