OraFAQ Forum: Data Guard » Physical Standby giving ora-1609

Home » Server Options » Data Guard » Physical Standby giving ora-1609

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

Physical Standby giving ora-1609 [message #253733]

Tue, 24 July 2007 14:25

schilukuri
Messages: 7
Registered: July 2007
Location: knoxville

Junior Member

HI
I am receiving the following error on a new implementation on oracle 10g (10.2.0.3). Both are sun unix boxes.

ORA-16009: remote archive log destination must be a STANDBY database

when i issueed the following statement on the physical standby, then I stopped seeing the errors.

ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;

What are some of the consequences with that on my standby

Sarma

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253745 is a reply to message #253733]

Tue, 24 July 2007 14:37

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ora-16009: remote archive log destination must be a STANDBY database
 *Cause:  The database associated with the archive log destination service
            name is other than the required STANDBY type database.
          Remote archival of redo log files is not allowed to non-STANDBY
          database instances.
 *Action: Take the necessary steps to create the required compatible STANDBY
          database before retrying the ARCHIVE LOG processing

Quote:

when i issueed the following statement on the physical standby, then I stopped seeing the errors.
What are some of the consequences with that on my standby?

Weird question. I fix the errors what is the problem?

Regards
Michel

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253751 is a reply to message #253733]

Tue, 24 July 2007 14:47

schilukuri
Messages: 7
Registered: July 2007
Location: knoxville

Junior Member

Data guard setup doesnot adderss the issues that we need to set that up that way. IS this a bug ? Does it create issues in switching to standby etc..

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253752 is a reply to message #253751]

Tue, 24 July 2007 14:53

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;

Becuase it doesnt allow to generate archive on standby.NOTE:Its mean your changes are not apllying to standby database.

Post the result of these two querries.

SQL> select status,error
  2   from v$archive_dest where dest_id=2;

STATUS    ERROR
--------- -----------------------------------------------------------------
VALID

SQL>  show parameter log_archive_dest_2

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
log_archive_dest_2                   string                           SERVICE=FLPS2 LGWR ASYNC
                                                                                            VALID_FO
                                                                      R=(ONLINE_LOGFILES,PRIMARY_ROL
                                                                      E)
                                                                                           DB_UNIQUE
                                                                      _NAME=FLPS2

[Updated on: Tue, 24 July 2007 14:53]

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253756 is a reply to message #253733]

Tue, 24 July 2007 15:00

schilukuri
Messages: 7
Registered: July 2007
Location: knoxville

Junior Member

SQL> select status,error from v$archive_dest where dest_id=2;

STATUS ERROR
--------- -----------------------------------------------------------------
VALID

SQL> show parameter log_archive_dest_2

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service=STBYORCL LGWR ASYNC VA
LID_FOR=(ALL_LOGFILES,ALL_ROLE
S) DB_UNIQUE_NAME=stbyorcl

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253760 is a reply to message #253733]

Tue, 24 July 2007 15:19

schilukuri
Messages: 7
Registered: July 2007
Location: knoxville

Junior Member

I found out on metalink, that this was fixed on 10.2.0.3, but not so. I logged in a tar with them
4676659 ORA-16009 in alert log with standby and LGWR ASYNC

thanks all

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253762 is a reply to message #253760]

Tue, 24 July 2007 15:25

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I have on the same version but havent notice such kinda error.

SQL>  select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253768 is a reply to message #253733]

Tue, 24 July 2007 15:40

schilukuri
Messages: 7
Registered: July 2007
Location: knoxville

Junior Member

Here is my configuration

Production -- orcl

db_unique_name='ORCL'
fal_client='orcl'
fal_server='stbyorcl'
log_archive_dest_1='LOCATION=/u05/oradata/orcl/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
log_archive_dest_2='service=STBYORCL LGWR ASYNC VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stbyorcl'
log_archive_dest_state_1='ENABLE'
log_archive_dest_state_2='ENABLE'
log_archive_format='arch_orcl_%t_%s_%r.dbf'
remote_login_passwordfile='EXCLUSIVE'
service_names='orcl'
standby_file_management='AUTO'

tnsnames.ora

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PSDB.server.knx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.server.knx)
)
)

STBYORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PSDBRecover.server.knx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stbyorcl.server.knx)
)
)

Physical Standby Database -- stbyorcl

Init.ora on Physcial Standby
STBYORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PSDBRecover.server.knx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = stbyorcl.server.knx)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = PSDB.server.knx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.server.knx)
)
)

db_name='orcl'
db_unique_name='STBYORCL'
dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
fal_client='stbyorcl'
fal_server='orcl'
log_archive_dest_1='LOCATION=/u05/oradata/orcl/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stbyorcl'
log_archive_dest_2='service=orcl LGWR ASYNC VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL'
log_archive_dest_state_1='ENABLE'
log_archive_dest_state_2='defer'
service_names='stbyorcl.server.knx'

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253777 is a reply to message #253768]

Tue, 24 July 2007 16:15

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

add this parameter to both side pfile PRIMARY AND STANDBY and then check

Log_archive_config=’DG_CONFIG=(db_unique_name_primary,db_unique_name_standby)

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #253779 is a reply to message #253777]

Tue, 24 July 2007 16:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

NOTES.

Attachment: DATAGUARD CONFIGURATION.doc
(Size: 100.50KB, Downloaded 2579 times)

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #254080 is a reply to message #253733]

Wed, 25 July 2007 13:07

schilukuri
Messages: 7
Registered: July 2007
Location: knoxville

Junior Member

Thanks a lot, I think the error is coming because the archive_dest_2 was defined afor all_logfiles, all_roles which
when changed to online_logfiles, primary_role fixed the issue

log_archive_dest_2='service=orcl LGWR ASYNC VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL'

Report message to a moderator

Re: Physical Standby giving ora-1609 [message #254084 is a reply to message #254080]

Wed, 25 July 2007 13:17

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

You welcome.

Report message to a moderator

Previous Topic:	ORA 16009 and ORA 16766 errors on Physical Standby (RAC)
Next Topic:	Not able to apply archive log to standby database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 21:51:36 CST 2024