top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How does one do off-line database backups in Oracle?

+1 vote
How does one do off-line database backups in Oracle?
posted May 10, 2014 by Kali Mishra

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

Please follow the below process to back up Oracle DB:

  1. Shut down the database from sqlplus or server manager. Backup all files to secondary storage (eg. tapes). Ensure that you backup all data files, all control files and all log files. When completed, restart your database.
  2. Do the following queries to get a list of all files that needs to be backed up:
    select name from sys.v_$datafile;
    select member from sys.v_$logfile;
    select name from sys.v_$controlfile;

    Sometimes Oracle takes forever to shutdown with the "immediate" option. As workaround to this problem, shutdown using these commands:
    alter system checkpoint;
    shutdown abort
    startup restrict
    shutdown immediate

Note that if you database is in ARCHIVELOG mode, one can still use archived log files to roll forward from an off-line backup. If you cannot take your database down for a cold (off-line) backup at a convenient time, switch your database into ARCHIVELOG mode and perform hot (on-line) backups.

answer May 10, 2014 by Amit Kumar Pandey
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.