Tuesday, January 22, 2013

ORACLE - Manually apply archived log to the Standby database

Issue:  Manual standby database fail to apply archive log due to corruption of archive log.

ORA-00353: log corruption near block 118784 change 68177937 time 01/22/2013 08:37:43
ORA-00334: archived log: '/ArchLog/oracle/QNTP01/arch/arch_1_15929_800746832.arc'
ORA-00283: recovery session canceled due to errors
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 118784 change 68177937 time 01/22/2013 08:37:43
ORA-00334: archived log: '/ArchLog/oracle/QNTP01/arch/arch_1_15929_800746832.arc'
ORA-00283: recovery session canceled due to errors
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 118784 change 68177937 time 01/22/2013 08:37:43
ORA-00334: archived log: '/ArchLog/oracle/QNTP01/arch/arch_1_15929_800746832.arc'
ORA-283 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL ...

Soution:
At STANDBY Database:
Copy archive log from primary side
And
sqlplus -s '/ as sysdba' << EOF
recover standby database;
AUTO
EOF

No comments:

Post a Comment