Q&As: Cold database backups

(Q) Which statements about Closed (cold/offline) database backups are correct?

  • ( ) You CAN perform closed database backups using RMAN.
  • ( ) To perform closed db backups with RMAN, the instance MUST be MOUNTED
  • ( ) You CAN perform user-managed closed database backups (OFFLINE backups), following the steps below:
    • Run shell script to collect location of all datafiles, control files, redo log files, and parameter files
    • If using server parameter file, run command to backup spfile
    • Shutdown the database normal or immediate
    • Run OS script to copy all datafiles, control files, redo logs and parameter files to backup area
    • Startup the database
  • ( ) You CANNOT run a Data Pump Export on a closed database.

No comments:

Post a Comment