Physical Standby log shipping issue
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'
My system is redhat4, linux, oracle 9.2.0.8
Edited by: user6743940 on 6 avr. 2011 02:56