Hi Experts,
Platform : IBM-AIX 6.1
DB : 11.2.0.3 EE
Scenario : We have RMAN backups running for our PROD DB but when we try to update our Clone DB from PROD backup then it ends with an internal error. We already have an oracle SR running for the same but still no fixes found.
Note : When we take export backup of PROD and import that dump on a new machine then it goes fine and also if we take RMAN backup of that new database where export dump of PROD DB was imported and drop the new DB and try to restore and recover from its RMAN backup then works fine, no issues. Only RMAN backups moved from RPOD is not able to restore(restore goes fine)/recover(only recover command throws error) on any other machine..
Below is the Internal error we get while recovering the clone DB.
channel a1: starting archived log restore to default destination
channel a1: restoring archived log
archived log thread=1 sequence=809
channel a1: reading from backup piece PROD_20160719_21871_1_archive
channel a1: piece handle=PROD_20160719_21871_1_archive tag=ARCH
channel a1: restored backup piece 1
channel a1: restore complete, elapsed time: 00:00:25
archived log file name=/logs202/orasvc21/PROD/archive/archPROD_1_809_915756984.arc thread=1 sequence=809
released channel: a1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/20/2016 10:59:34
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/logs202/orasvc21/PROD/archive/archPROD_1_809_915756984.arc'
ORA-10562: Error occurred while applying redo to data block (file# 2, block# 106761)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2: '/data201/orasvc21/PROD/sysaux_01.dbf'
ORA-10560: block type 'TRANSACTION MANAGED INDEX BLOCK'
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [2252], [12847], [953557035], [4426], [4027154432], [], [], [], [], [], [], []
We have already validated archivelogs and no logical corruption found.
Please share your knowledge if anyone have faced this kind of situation.