Home » Server Options » Data Guard » Physical Standby log shipping issue (9i 9.2.0.8 Linux, Redhat 4)
Physical Standby log shipping issue [message #502427] Wed, 06 April 2011 04:52
tdelnatte
Messages: 1
Registered: April 2011
Junior Member
Hi,

I get an issue with DATAGUARD when I try to restart STANDBY DATABASE, LOG SHIPPING is not working witout restarting PRIMARY DATABASE. How to fix this?


INSTANCE 1 ET INSTANCE 2 ARE UP (t=0)

MESSAGE DATAGUARD
--------------------------------------------------------------------------------
ARC0: Complete FAL archive (thread 1 sequence 64 destination PRODSIW_STBY)
ARC1: Evaluating archive log 3 thread 1 sequence 66
ARC1: Beginning to archive log 3 thread 1 sequence 66
Creating archive destination LOG_ARCHIVE_DEST_2: 'PRODSIW_STBY'
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/flash_recovery_area/PRODSIW/archivelog/arc1_66.arc'


INSTANCE 1 ET INSTANCE 2 ARE UP AFTER RESTARTING INSTANCE2 BUT LOG SHIPPING IS NOT WORKING

INSTANCE2SQL>shutdown immediate;
INSTANCE2SQL>startup nomount;
INSTANCE2SQL>alter database mount standby database;
INSTANCE2SQL>alter database recover managed standby database disconnect from session;
INSTANCE1SQL>alter system switch logfile;

MESSAGE DATAGUARD
--------------------------------------------------------------------------------
ARC1: Completed archiving log 3 thread 1 sequence 66
ARC1: Evaluating archive log 1 thread 1 sequence 67
ARC1: Beginning to archive log 1 thread 1 sequence 67
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/flash_recovery_area/PRODSIW/archivelog/arc1_67.arc'

PROCESS CLIENT_P SEQUENCE# STATUS THREAD# BLOCK# BLOCKS
--------- -------- ---------- ------------ ---------- ---------- ----------
MRP0 N/A 67 WAIT_FOR_LOG 1 0 0

I don't get why Creating archive destination LOG_ARCHIVE_DEST_2 is missing?


INSTANCE 1 ET INSTANCE 2 ARE UP AFTER RESTARTING INSTANCE1

Creating archive destination LOG_ARCHIVE_DEST_2: 'PRODSIW_STBY'
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/flash_recovery_area/PR
ODSIW/archivelog/arc1_70.arc'

PROCESS CLIENT_P SEQUENCE# STATUS THREAD# BLOCK# BLOCKS
--------- -------- ---------- ------------ ---------- ---------- ----------
MRP0 N/A 71 WAIT_FOR_LOG 1 0 0
RFS ARCH 70 ATTACHED 1 908 908

MESSAGE DATAGUARD
--------------------------------------------------------------------------------
Creating archive destination LOG_ARCHIVE_DEST_2: 'PRODSIW_STBY'
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/flash_recovery_area/PR
ODSIW/archivelog/arc1_70.arc'

LOG_ARCHIVE_DEST_2 reapears

PFILE INSTANCE1
*.log_archive_dest_1='LOCATION=/oracle/flash_recovery_area/PRODSIW/archivelog/ MANDATORY REOPEN=30'
*.log_archive_dest_2='SERVICE=PRODSIW_STBY ARCH SYNC AFFIRM'


Previous Topic: DataGuard steps Required
Next Topic: FAL request rejected error & log shipping problem
Goto Forum:
  


Current Time: Thu Mar 28 03:26:42 CDT 2024