Flashback Database is a very powerful feature offered by Oracle. We can enable flashback in CDB same way we are doing in the non-cdb database.

Enable Flashback Database in CDB :

Step 1 : Check flashback_on from v$database

Step 2: Set flashback retention target

Step 3: Enable flashback database

Step 4: Check flashback_on from v$database

Flashback Operation on CDB and PDB : 

CDB Flashback: To flashback cdb root we need to flashback entire CDB. We can not flashback cdb root without flashing back entire CDB.

PDB Flashback: All datafiles belonging to a PDB can be flashed back and recovered in-place. All undo application that is needed to make a PDB consistent after flashback is applied in-place. After a PDB flashback operation, the old backup of the PDB is still valid.

Flashback Pluggable Database 

Step 1 : Close pluggable database

Step 2 : Flashback pluggable database

Step 3 : Open pluggable database pdb1 in resetlogs

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.