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
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