This blog is intended for DBA’s who have issues in Oracle standby MRP (Managed Recovery Process) and MRP process stops with below ORA error.
” ORA-00600: internal error code, arguments: [3020], [7], [768706], [30128834], [], [], [], [], [], [], [], []”.
I’ve outlined the solution and root cause of the problem below.
Issue:
Below error occurs in Oracle Standby Database:
ORA-00600: internal error code, arguments: [3020], [7], [768706], [30128834], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 7, block# 768706, file offset is 2002272256 bytes)
ORA-10564: tablespace TBS02
ORA-01110: data file 7: ‘F:\APP\ADMINISTRATOR\ORADATA\TBS\TBS02.DBF’
ORA-10561: block type ‘TRANSACTION MANAGED DATA BLOCK’, data
Cause:
Datafile in oracle standby corrupted.
Solution:
- On the primary database
RMAN> rman target /
backup device type disk format ‘F:\rman_backup_21\%U’ datafile 7;
After executing the above rman command a backup of set for the data file will be generated. Once generated, copy the same in oracle standby.
- On the standby database:
SQL>startup nomount
SQL>alter database mount standby database;
RMAN> rman target /
RMAN> catalog start with ‘F:\rman_backup_21\’ noprompt;
RMAN> restore datafile 7;
RMAN> exit;
SQL> recover managed standby database disconnect from session;
Hope the solution would have helped to over come the above issues. Happy Debugging!
