The problem is “Normal” in standby but also occurs in Restore database
ORA-00600: internal error code, arguments: [3020], [2885689059], [1], [419819],[26750], [808], [], []
ORA-10567: Redo is inconsistent with data block (file# 5, block# 419844)
ORA-10564: tablespace ZMSOLUTION
ORA-01110: data file ‘/oracle/datafiles/zmsolution.dbf’
FOR standby
1) at the primary site, take a backup of the datafile:
RMAN> backup datafile 5 format ‘/tmp/df5_pr.bk’ tag ‘PRIMARY_5′;
2) transfer the file to the standby site using an operating system utility such as scp, NFS, ftp etc
3) at the standby site, catalog the backuppiece and confirm it’s available for use:
RMAN> catalog backuppiece’/tmp/df5_pr.bk’;
RMAN> list backuppiece’/tmp/df5_pr.bk’;
RMAN> list backup of datafile 5;
4) stop redo apply on the physical standby database. For an active dataguard you will need to restart the standby database in MOUNT mode first before stopping managed recovery.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
5) on the standby site restore the datafile:
RMAN> restore datafile 5;
6) restart redo apply on the physical standby database. For an active dataguard you can go ahead and restart the active dataguard process.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;
NOTE: prior to 12.1, for real time apply, you must use:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
FOR RESTORE:
use recover database with “ALLOW 1 CORRUPTION”
RECOVER DATABASE ALLOW 1 CORRUPTION;