ON STANDBY:
standby database disconnect from session
Fri Feb 29 13:21:20 2008
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 5330-5331
DBID 63961092 branch 620945476
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-------------------------------------------------------------
1 startup nomount;
2 alter database mount standby database;
3 alter database recover managed standby database disconnect from session;
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
MRP0 WAIT_FOR_GAP
SQL> select * from v$archive_gap;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 5330 5331
ON PRIMARY:
SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;
PROCESS STATUS
--------- ------------
ARCH CLOSING
ARCH CLOSING
LGWR CLOSING
SQL> SHOW PARAMETER ARCHIVE
log_archive_dest_2 string SERVICE=STANDBY affirm lgwr ma
x_failure=1 noreopen net_timeo
ut=60
select message from v$dataguard_status;
MESSAGE
--------------------------------------------------------------------------------
ORA-16198: LGWR received timedout error from KSR
LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16198)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
LGWR: Network asynch I/O wait error 16198 log 2 service 'STANDBY'
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
PING[ARC1]: Error 3135 when pinging standby STANDBY.
LGWR: Failed to archive log 2 thread 1 sequence 5330 (16198)
LGWR: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'STANDBY' (error 16
198)
SQL> SELECT PROCESS,STATUS FROM V$MANAGED_STANDBY;
PROCESS STATUS
--------- ------------
ARCH CLOSING
ARCH OPENING
LGWR WRITING
SQL> create or replace directory ARCHDIR as '+dgarch/wms/archivelog/2008_02_29';
Directory created.
SQL> create or replace directory TEMPDIR as '/exp/tmparch';
Directory created.
SQL> exec DBMS_FILE_TRANSFER.COPY_FILE('ARCHDIR','thread_1_seq_5331.291.647960215','TEMPDIR','1_5331_620945476.arc');
PL/SQL procedure successfully completed.
SQL> exec DBMS_FILE_TRANSFER.COPY_FILE('ARCHDIR','thread_1_seq_5330.304.647958993','TEMPDIR','1_5330_620945476.arc');
PL/SQL procedure successfully completed.
ON STANDBY:
ALTER DATABASE REGISTER LOGFILE '/data/oradata/wms/archive/1_5330_620945476.arc';
ALTER DATABASE REGISTER LOGFILE '/data/oradata/wms/archive/1_5331_620945476.arc';
SQL> SELECT * FROM V$ARCHIVE_GAP;
no rows selected
Fri Feb 29 13:16:20 2008
Completed: alter database recover managed
standby database disconnect from session
Fri Feb 29 13:21:20 2008
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 5330-5331
DBID 63961092 branch 620945476
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
-------------------------------------------------------------
Fri Feb 29 14:32:51 2008
ALTER DATABASE REGISTER LOGFILE '/data/oradata/wms/archive/1_5331_620945476.arc'
Fri Feb 29 14:32:51 2008
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER LOGFILE '/data/oradata/wms/archive/1_5331_620945476.arc'
Fri Feb 29 14:33:21 2008
Fetching gap sequence in thread 1, gap sequence 5330-5330
Fri Feb 29 14:37:12 2008
ALTER DATABASE REGISTER LOGFILE '/data/oradata/wms/archive/1_5330_620945476.arc'
Fri Feb 29 14:37:12 2008
There are 1 logfiles specified.
ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
Completed: ALTER DATABASE REGISTER LOGFILE '/data/oradata/wms/archive/1_5330_620945476.arc'
Fri Feb 29 14:37:21 2008
Media Recovery Log /data/oradata/wms/archive/1_5330_620945476.arc
