Oracle 12c Upgrade: 06 – Backup Recovery and Flashback for a CDB/PDB

Card Set Information

Author:
Tralala
ID:
296200
Filename:
Oracle 12c Upgrade: 06 – Backup Recovery and Flashback for a CDB/PDB
Updated:
2015-03-16 03:54:57
Tags:
Backup Recovery Flashback CDB PDB
Folders:
Oracle 12c Upgrade
Description:
Oracle 12c Upgrade: 06 – Backup, Recovery and Flashback for a CDB/PDB
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. How are backups managed?
    With RMAN and EM Cloud Control
  2. What can be backed up?
    • Backup entire CDB
    • Only the root of the CDB
    • Any or all of the PDBs
  3. If the whole CDB is backed up, what is backed up?
    Root, all the PDBs, Seed and the archived redo logs.
  4. From a whole CDB backup, what can be recovered?
    • The whole CDB
    • The root only
    • One or more PDBs
  5. To backup a CDB, what is specific about the user performing the backup?
    • Must be a common user
    • Must have SYSBACKUP ot SYSDBA
  6. What RMAN command is issued to backup an entire CDB?
    RMAN> BACKUP DATABASE;
  7. What RMAN command is issued to backup an entire CDB including archivelogs?
    RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
  8. What RMAN command is issued to backup root?
    • RMAN> BACKUP DATABASE ROOT;
    • RMAN> BACKUP PLUGGABLE DATABASE 'CDB$ROOT'; - quotes due to $
  9. How is a pluggable database backed up?
    • Connected to root: RMAN> BACKUP PLUGGABLE DATABASE PDB01, PDB02;
    • Connected to root: RMAN> BACKUP PLUGGABLE DATABASE PDB03, 'CDB$ROOT';
    • Connected to PDB: RMAN> BACKUP DATABASE;
  10. What new column is to be found in the backup relates V$ and RC_ views?
    PLUGGABLE_DBID
  11. Which view shows backup information for all PDBs?
    RC_PDBS
  12. On ALTER DATABASE BACKUP CONTROLFILE TO TRACE what happens?
    A script of all the data files that belong to the root container as well as all the PDBs.is generated
  13. Without RMAN, how can the entire CDB be backed up?
    • SQL> alter database begin backup;
    • SQL> alter database end backup;
  14. When connected to a PDB as a local user via RMAN, how are archived log backed up?
    They can't
  15. How is a non RMAN backup performed in a pluggable database?
    • Connect to the PDB - This cannot be done as Root
    • ALTER PLUGGABLE DATABASE pdb01 BEGIN|END BACKUP;
    • ALTER DATABASE BEGIN|END BACKUP;
  16. How are archived logs backup up?
    Same a a non-PDB, but must be connected to Root
  17. How is an individual tablespace backed up for a PDB?
    • Connected to root: BACKUP TABLESPACE pdb02:sysaux
    • Connected to PDB: BACKUP TABLESPACE sysaux;
  18. What can be recovered?
    • entire CDB
    • only root
    • a single PDB
    • a portion of a PDB (tablespace datafile)
  19. Why do Oracle not recommend restoring the ROOT of CDB?
    Can introduce metadata inconsistencies.
  20. How is whole CDB recovered?
    • Connect to root as common user with SYSBACKUP ot SYSDBA
    • CDB must be in mount mode
    • RESTORE DATABASE ROOT;
    • RECOVER DATABASE ROOT;
    • Restore SEED and ALL PDBs
    • RESTORE PLUGGABLE DATABASE ‘PDB$SEED’, pdb01, pdb02;
    • RECOVER PLUGGABLE DATABASE ‘PDB$SEED’, pdb01, pdb02;
    • ALTER DATABASE OPEN;
    • ALTER PLUGGABLE DATABASE OPEN;
  21. How is a complete recovery of a PDB performed?
    • Connected to root:
    • RMAN> RECOVER PLUGGABLE DATABASE PDB01;
    • RMAN> RESTORE PLUGGABLE DATABASE PDB01;
    • RMAN> ALTER PLUGGABLE DATABASE PDB01 OPEN;
    • Connected to PDB:
    • RMAN> RESTORE DATABASE;
    • RMAN> RECOVER DATABASE;
    • RMAN> ALTER DATABASE OPEN;
  22. What happens if a CDB instance opens and the a tempfile is missing or corrupted?
    A new one is created automatically and a message written to the alert log
  23. What happens if a PDB instance opens and the a local tempfile is missing or corrupted?
    A new one must be created manually
  24. How does one connect to a PDB in RMAN?
    rman target sys/password@PDB01
  25. How does one recover a PDB from a missing datafile?
    • rman target sys/password@PDB01
    • ALTER DATABASE DATAFILE 11 OFFLINE;
    • RESTORE DATAFILE 11;
    • RECOVER DATAFILE 11;
    • ALTER DATABASE DATAFILE 11 ONLINE;
  26. How is flashback database enabled?
    • Database must be in archivelog mode
    • ALTER DATABASE FLASHBACK ON;
  27. What are the steps the flashback a CBD?
    • Ensure flashback is on
    • Connect to ROOT as SYSDBA or SYSBACKUP
    • SHUTDOWN IMMEDIATE;
    • STARTUP MOUNT;
    • FLASHBACK DATABASE TO TIMESTAMP SYSDATE-(5/24/60);
    • ALTER DATABASE OPEN RESETLOGS;
  28. What are the steps to flashback a PDB?
    Can't perform flashback on a PDB
  29. What happens if a PDB has been recovered with a PITR and a flashback database is attempted to before the PITR?
    • An error is generated
    • ORA-38866: Data file for pluggable database must be offline to flashback across a PDB point in time recovery.
  30. If a PDB has been recovered with a PITR, what are the steps to flashback a database to before the PITR?
    • 1 Backup Entire CDB
    • 2 Close PTIR PDB
    • 3 Offline all datafiles for PDB
    • 4 Flashback Database
    • 5 Open all database except PTIR PDB
    • 6 Restore PTIR PDB from backup
    • 7 Online all datafiles for PDB
    • 8 Open PTIR PDB
  31. How does one do a Point-In-TIme recovery of a PBD with RMAN?
    • RUN {
    • ALTER PLUGGABLE DATABASE pdb01 CLOSE;
    • SET UNTIL TIME "TO_DATE('06-FEB-2015 14:25:00','DD-MON-YYYY HH24:MI:SS')";
    • RESTORE PLUGGABLE DATABASE pdb01;
    • RECOVER PLUGGABLE DATABASE pdb01;
    • ALTER PLUGGABLE DATABASE pdb01 OPEN RESETLOGS;
    • }
  32. At what level is a Instance Recovery performed?
    • A CDB level, not possible at PDB level.
    • The instance is the CDB
  33. If the root system or undo files were lost, what would happen and what recover would be required?
    • The instance would crash
    • startup mount
    • restore tablespace SYSTEM | UNDOTBS1
    • recover tablespace SYSTEM | UNDOTBS1
    • alter database open
    • alter pluggable database all open
  34. If the root sysaux was lost, what would happen and what recover would be required?
    • The instance would remain open, root and PDBs would remain open
    • alter tablespace sysaux offline
    • restore tablespace SYSAUX
    • recover tablespace SYSAUX
    • alter database open
  35. If a PDB SYSTEM tablespace is lost, what happens. How is recovery done?
    • If PDB was closed:
    • restore tablespace pdb01:system
    • recover tablespace pdb01:system
    • If PDB was open:
    • shutdown CDB
    • startup mount;
    • restore tablespace pdb01:system
    • recover tablespace pdb01:system
    • alter database open;
    • alter pluggable database all open;
  36. If a PDB NON-SYSTEM tablespace is lost, what happens. How is recovery done?
    • SQL: connect sys@pdb01
    • SQL: alter tablespace user offline immediate
    • RMAN: restore tablespace pdb01:users
    • RMAN: recover tablespace pdb01:users
    • SQL: alter tablespace user online

What would you like to do?

Home > Flashcards > Print Preview