Archiver error on logical standby database

From: Stalin <stalinsk_at_gmail.com>
Date: Tue, 27 Sep 2005 14:30:49 -0700
Message-ID: <c5363d3a05092714307b989f3a@mail.gmail.com>

Hi All,

Has anyone seen this behaivour with logical standby database in max. performace mode with standby redologfiles.

STDBY> select group#, dbid, status from v$standby_log;

GROUP# DBID STATUS

---------- ---------- ------------------------------
         9 UNASSIGNED UNASSIGNED
        10 UNASSIGNED UNASSIGNED
        11 UNASSIGNED UNASSIGNED
        12 UNASSIGNED UNASSIGNED

STDBY> select applied_scn, applied_sequence#, newest_scn, newest_sequence# from dba_logstdby_progress;

APPLIED_SCN APPLIED_SEQUENCE# NEWEST_SCN NEWEST_SEQUENCE#

----------- ----------------- ---------- ----------------
    1234219               175    1234219              175

PRI> alter system switch logfile;

STDBY> select group#, dbid, status from v$standby_log;

GROUP# DBID STATUS

---------- ---------- ------------------------------
         9 2599914051 ACTIVE
        10 UNASSIGNED UNASSIGNED
        11 UNASSIGNED UNASSIGNED
        12 UNASSIGNED UNASSIGNED

STDBY> select applied_scn, applied_sequence#, newest_scn, newest_sequence# from dba_logstdby_progress;

APPLIED_SCN APPLIED_SEQUENCE# NEWEST_SCN NEWEST_SEQUENCE#

----------- ----------------- ---------- ----------------
    1234219               175    1234396              176

Error in Standby Alert log;

Tue Sep 27 13:53:31 2005
ORA-16014: log 9 sequence# 176 not archived, no available destinations ORA-00312: online log 9 thread 1:
'/usr/local/u01/oradata/dogbert/stdbyredo01.log' ARCH: Connecting to console port...
ARCH:
Tue Sep 27 13:53:31 2005
ORA-16014: log 9 sequence# 176 not archived, no available destinations ORA-00312: online log 9 thread 1:
'/usr/local/u01/oradata/dogbert/stdbyredo01.log' Tue Sep 27 13:53:31 2005
Errors in file /usr/local/u01/app/oracle/admin/dogbert/bdump/dogstdby_arc1_3815.trc: ORA-16014: log 9 sequence# 176 not archived, no available destinations ORA-00312: online log 9 thread 1:
'/usr/local/u01/oradata/dogbert/stdbyredo01.log' Archiver process freed from errors. No longer stopped

However, when i do another logfile switch, sequence# 176 and 177 gets archived to it's location and brings the database upto speed.

STDBY> select applied_scn, applied_sequence#, newest_scn, newest_sequence# from dba_logstdby_progress;

APPLIED_SCN APPLIED_SEQUENCE# NEWEST_SCN NEWEST_SEQUENCE#

----------- ----------------- ---------- ----------------
    1234846               177    1234846              177

Anyone seen this ?

necessary DG parameters in standby database :

*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ONLINE_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=dogstdby'
*.log_archive_dest_2='SERVICE=dogbert VALID_FOR=(ONLINE_LOGFILES,
PRIMARY_ROLE) DB_UNIQUE_NAME=dogbert'
*.log_archive_dest_3='LOCATION=USE_DB_RECOVERY_FILE_DEST

VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) DB_UNIQUE_NAME=dogstdby'


*.log_archive_dest_state_1='ENABLE'

*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.standby_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST'

Regards,
Stalin
Version : 10g(10.1.0.4)/Sol 5.9

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 27 2005 - 16:32:53 CDT