0

Oracle 12cR1, disaster database.

ORA-00283: recovery session canceled due to errors

ORA-00354: corrupt redo log block header

ORA-00353: log corruption near block 8 change 80357235718 time 11/01/2020 01:57:01

ORA-00334: archived log: '/FRA/.../o1_mf_2_61264_hsvvjoyb_.arc'

Database in mount mode and can't recover.

How can I resolve this?

Best regards,

3

That is not an online redo log. That is an archived redo log of thread 2 sequence 61264. It can be clearly seen from the error and the name of the file. The archivelog on disk was damaged. Restore it from backup and continue recovery using that.

If you do not have a backup of that archivelog, just roll forward the standby database with an incremental backup.

As a last resort, you can rebuild the standby database from the primary.

4
  • Could the same archived redo log be damaged on the production server? In this case, the full database backup may not be available. – jrdba Nov 1 '20 at 12:26
  • @jrdba You will know that once you check it. Even if the same archivelog was damaged on the primary system, you can always use a new full backup or active duplicate to rebuild the standby from scratch. With incremental backup that archivelog is also not needed in this scenario. – Balazs Papp Nov 1 '20 at 12:35
  • Okay. I'm researching how can I find it on production database. Thank you. – jrdba Nov 1 '20 at 12:40
  • Hi sir, it solved. I backuped database from production according time of archivelog and recover it from disaster side. Thank you again. – jrdba Nov 1 '20 at 16:43
0

You should open a Service Request with Oracle Support for specific instruction. For an overview of the situation, see here: http://www.dba-oracle.com/t_ora_00354_corrupt_redo_log_block_header.htm

1
  • It's not a problem for us, because it's a disaster server. But 'alter database clear unarchived logfile 'logilename';' can it resolve the problem? – jrdba Nov 1 '20 at 11:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.