Home » Server Options » Data Guard » One for the guru: Standby Database using Online Redo?
One for the guru: Standby Database using Online Redo? [message #241753] Wed, 30 May 2007 09:52 Go to next message
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

Re: One for the guru: Standby Database using Online Redo? [message #241762 is a reply to message #241753] Wed, 30 May 2007 10:19 Go to previous messageGo to next message
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??
Re: One for the guru: Standby Database using Online Redo? [message #241804 is a reply to message #241753] Wed, 30 May 2007 11:45 Go to previous messageGo to next message
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
Re: One for the guru: Standby Database using Online Redo? [message #243298 is a reply to message #241804] Wed, 06 June 2007 15:52 Go to previous messageGo to next message
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.
Re: One for the guru: Standby Database using Online Redo? [message #243553 is a reply to message #241753] Thu, 07 June 2007 13:27 Go to previous message
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
Previous Topic: archiving is not transfering on standby location
Next Topic: NO. OF REDO LOGS ON PRIMARY AND STANDBY
Goto Forum:
  


Current Time: Thu Mar 28 10:26:44 CDT 2024