Resolve ORA-10562,10564,01110,10561,00600 at Standby database In Oracle



Resolve ORA-10562, 10564, 01110, 10561, 00600 at Standby database In Oracle

In this article, we will resolve errors ORA-10562, 10564, 01110, 10561, 00600 at Standby. A few days back, we got an SYSAUX tablespace error at DBGURU STANDBY database and the error was as below:

Errors in file /u02/app/oracle/diag/rdbms/dbguru/dbguru/trace/dbguru_mrp0_26696.trc:
ORA-10562: Error occurred while applying redo to data block (file# 2, block# 3052738)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2: ‘/u02/app/oracle/oradata/DBGURU_STAND/datafile/sysaux.dbf’
ORA-10561: block type ‘TRANSACTION MANAGED INDEX BLOCK’, data object# 46394
ORA-00600: internal error code, arguments: [kdxlin:bad itl index], [6], [2], [], [], [], [], [], [], [], [], []


At Primary Database Server:-

  1. Stop archive shipping from Primary Database –
alter system set LOG_ARCHIVE_DEST_STATE_2=defer scope=both sid='*';

2. Take a backup of a corrupted datafile using RMAN utility:-

RMAN> backup datafile '+DATA/DBGURU/data/sysaux.dbf';

3. Move this backup into standby database server:-

scp nnndf0_tag20200820t124958_0.3280 oracle@DBGURU:/u02/oracle

At Standby Database Server:-

4. Connect to the RMAN utility and catalog the backup mount point:-

catalog start with '/u02/oracle';

5. Restore corrupted datafile:-

restore datafile 2;

6. After restoring successfully connect the standby database and start the MRP process:-

sqlplus / as sysdba

7. Start log shipping at Primary database:-

alter system set LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=both sid='*';

This document is only for learning purpose and always validate in the LAB environment first before applying in the LIVE environment.

Hope so you like this article
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the latest update. Click here to know more about our pursuit.

Recent articles

 4,294 Total Views,  3 Views Today

How useful was this post?

Click on a star to rate it!

Average rating 4.7 / 5. Vote count: 21

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Spread the Knowledge!

6 thoughts on “<a rel="bookmark" href="">Resolve ORA-10562,10564,01110,10561,00600 at Standby database In Oracle</a>”

    1. Thank you, Saddam!.
      All of your positive feedback motivates us to work even harder! 🙂
      Keep following our posts and sharing your feedback with us.

      Team DBsGuru

Leave a Reply

Your email address will not be published. Required fields are marked *

twelve − 9 =

Open chat
Contact Us:

Greetings of the day! How can we help you?

Team DBsGuru
Direct Call:+91-9310167776

Share Learn Grow!

Click on the below technical group to join us to share expertise in PostgreSQL and MySQL on WhatsApp group. The purpose of this group is only help to the DBA community.

PostgreSQL Technical Group.

MySQL technical Group.

Technical Links Powered by DBsGuru.

Team DBsGuru.