rain Storming Help PDB PIT recovery

Subject: Brain Storming Help PDB PIT recovery
Os info: Linux
Oracle info: 12c
Message: So thinking of possible scenarios for point-in-time recovery
of a PDB database(s).
Here is what I have so far...(base on 3 databases PDB1, PDB2,
PDB3...can scale up from there if needed)
Data corruption in PDB found
1) PDB1, PDB2 and PDB3 all must be in sync (FULL CDB PIT)
2) PDB1, PDB2 must be in sync PDB3 unaffected.
3) PDB1 only needs recovered PDB2 and PDB3 unaffected.
Application upgrade on PDB1 performed at beginning of month runs into
problems during end of month closing. Developers need PDB1 from 3 weeks
ago restored to test system for troubleshooting.
Anyone help out on other scenarios?
Regards
Tim


Subject: Re: Brain Storming Help PDB PIT recovery
Message: Hi Tim
As far as I see this it boils down to these scenarios:
a) One or more PDBs (same CDB)
-> Since you can restore more than one PDB in a
single RUN block, there is not really any
difference between "one" or "more than one"
b) All PDBs (whereever)
-> Special only because it's easier to just
restore the whole CDB in one go. This also
avoids the space-requirements for the auxiliary
instance
c) One or more PDBs (different CDB, possibly different Host)
-> I'm not sure about your options here
The last point is a really interesting one. I haven't thought about
this up to now and I'm just writing down what come's to my head as a
discussion-starter.
Since moving a PDB from one CDB to another involves unplugging it
first, you probably cannot just PDB-PITR this PDB into another CDB. If
this is so (I'm really not sure here) then you would have to do a PITR
of the CDB and unplug the needed PDBs from there. What I have no idea
about is: Can you omit one or more PDBs from such a restore? It might
be possible by doing a restore of the CDB$ROOT "PDB" first and then
explicitly restoring the needed PDBs. But I have no idea if this is
possible.
Regards,
Jan