I was trying to recreate the scenario where a 12c container database is flashed back to a SCN before the point that I recovered a pluggable database to using point in time recovery.
I got this ugly ORA-00600:
RMAN> recover pluggable database pdborcl; Starting recover at 16-APR-14 using channel ORA_DISK_1 starting media recovery media recovery failed RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 04/16/2014 06:07:40 ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed datafile 32 , 33 , 34 , 35 ORA-00283: recovery session canceled due to errors ORA-00600: internal error code, arguments: [3631], [32], [4096], [4210689], [], [], [], [], [], [], [], []
I think the above error message stems from this bug:
Bug 14536110 ORA-600 [ktfaput: wrong pdb] / crash using PDB and FDA
There may have been some clever way to recover from this but I ended up just deleting and recreating the CDB through DBCA which was good experience playing with DBCA in Oracle 12c. I’m trying to learn 12c but I have a feeling that I have hit a bug that keeps me from testing this flashback database, point in time recovery of a pluggable database scenario. I wonder if I should patch? I think that Oracle has included a patch for this bug in a patch set. It could be good 12c experience to apply a patch set.
– Bobby
Hi Bobby,
It is not a bug . That’s the way it is supposed to behave.
Please look at the following links:
http://docs.oracle.com/cd/E16655_01/backup.121/e17630/rcmflash.htm#BRADV800
http://docs.oracle.com/cd/E16655_01/backup.121/e17630/rcmflash.htm#BRADV802
Regards
Anju Garg
Anju,
I was doing the same steps listed in those manuals when I got the ORA-00600. That is why I think it is a bug.
– Bobby