Home » Server Options » Data Guard » Physical Standby giving ora-1609
Physical Standby giving ora-1609 [message #253733] Tue, 24 July 2007 14:25 Go to next message
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
Re: Physical Standby giving ora-1609 [message #253745 is a reply to message #253733] Tue, 24 July 2007 14:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Physical Standby giving ora-1609 [message #253751 is a reply to message #253733] Tue, 24 July 2007 14:47 Go to previous messageGo to next message
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..
Re: Physical Standby giving ora-1609 [message #253752 is a reply to message #253751] Tue, 24 July 2007 14:53 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Physical Standby giving ora-1609 [message #253760 is a reply to message #253733] Tue, 24 July 2007 15:19 Go to previous messageGo to next message
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
Re: Physical Standby giving ora-1609 [message #253762 is a reply to message #253760] Tue, 24 July 2007 15:25 Go to previous messageGo to next message
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

Re: Physical Standby giving ora-1609 [message #253768 is a reply to message #253733] Tue, 24 July 2007 15:40 Go to previous messageGo to next message
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'
Re: Physical Standby giving ora-1609 [message #253777 is a reply to message #253768] Tue, 24 July 2007 16:15 Go to previous messageGo to next message
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)
Re: Physical Standby giving ora-1609 [message #253779 is a reply to message #253777] Tue, 24 July 2007 16:20 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
NOTES.
Re: Physical Standby giving ora-1609 [message #254080 is a reply to message #253733] Wed, 25 July 2007 13:07 Go to previous messageGo to next message
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'

Re: Physical Standby giving ora-1609 [message #254084 is a reply to message #254080] Wed, 25 July 2007 13:17 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You welcome.
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:
  


Current Time: Fri Mar 29 03:08:20 CDT 2024