8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Multitenant : Flashback Pluggable Database (PDB) in Oracle Database 12c Release 2 (12.2)


Mohamed Amin said...

Hi
I need to reset Incarnations for one PDB to older Incarnation , like we do with normal database, how can we do that ?
thanks

Tim... said...

Hi.

Sounds like you need a point in time recovery of the PDB, as shown here.

https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#pdb-pitr-recovery

Cheers

Tim...

Mohamed Amin said...

Hi
Suppose I made restore point X for Pluggable database PDB1 and after some time I made a new restore point Y.
Now I restored PDB1 to restore point X and opened it with resetlogs. there will be new incarnation for PDB1.
If I need to restore PDB1 to restore point Y, it fails with RMAN-05109
I need first to reset to older incarnation to return to restore point Y . How ?
thanks

Mohamed Amin said...

Hi
RMAN> recover pluggable database PDB1 until restore point Y;
Starting recover at 11-FEB-19
---
RMAN-03002: failure of recover command at 02/11/2019 13:28:24
RMAN-05109: UNTIL SCN (1391083) is orphan incarnation of Pluggable Database PDB1
thanks

Tim... said...

Hi.

According to Doc ID 2298099.1 there is currently no way to set the incarnation of a PDB.

I guess you could create a point-in-time clone of the CDB and PDBs to a point before the incarnation change. Unplug the PDB and plug it back into the original root container.

Cheers

Tim...

Mohamed Amin said...

Hi
Many thanks for reply.
but at the end of Doc ID 2298099.1
"NOTE: When connected to the CDB, you can request a restore from the PDB's previous incarnation without needing to reset the incarnation of the PDB."
and it fails with me , My version is 12.2
Thanks

Tim... said...

Hi.

I believe it means previous, as in previous point in time. If you have any doubts, open an SR.

Cheers

Tim...

Mohamed Amin said...

Hi Tim

Many Thanks

Mohamed

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.