Database Backup and Recovery (MOSC)

MOSC Banner

PITR of PDB in oracle 12.2 R using local undo mode enabled

edited Jun 24, 2020 4:37PM in Database Backup and Recovery (MOSC) 8 commentsAnswered ✓

Hi Team,

I have a question in oracle 12.2 R with local undo mode enabled, we can do PITR of PDB with out giving auxiliary destination even though FRA is not sufficient space oracle won't create auxiliary instance using local undo. it will restore PDB datafiles alone from the Level 0 backup to the default location of data files and start applying incremental backup and archivelogs and recover the PDB with out using default destination FRA/Auxiliary Destination. PFB command.

So either FRA or Auxiliary destination is not necessary here ?

Am I correct ? correct me if am wrong.

RMAN> run

{

set until time "TO_DATE('21-06-2020 18:25:27','DD-MM-YYYY HH24:MI:SS')";

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center