RE: Hot backups

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 10 Mar 2003 13:08:26 -0800
Message-ID: <F001.005652AA.20030310130826@fatcity.com>

Peter - Shouldn't you backup the controlfile AFTER completing tablespace backups?

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, March 10, 2003 2:37 PM
To: Multiple recipients of list ORACLE-L

I am implementing hot backups on a small development database using the following approach:

1. From sqlplus: backup controlfile to '<filename>';
2. For each tablespace
   • sqlplus: alter tablespace <name> begin backup;
   • shell: copy files for that tablespace
   • sqlplus: alter tablespace <name> end backup;
   • sqlplus: alter system switch logfile;
3. tar and gzip the tablespace copies and backup control file;

As a test, I am restoring the files to another system by doing the following:

1. Copied the init.ora file from the backed up database.
2. Restore the copied tablespaces and control files.
3. Copy the archived redo logs to the directory specified in the init.ora file.
4. Note the number on the most recent redo log.
5. sqlplus internal startup mount recover database until cancel using backup controlfile; (hit return when prompted for the next file until the last redo log noted in step 4 has been processed, then type CANCEL in response to the prompt for the next file.) alter database open reset logs;

The above steps work, but I am wondering is there a better way to handle the control files so that I do not have to use the "until cancel" option.

Thanks,
Peter Schauss
Northrop Grumman Corporation
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Schauss, Peter
  INET: pschauss_at_northropgrumman.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Mar 10 2003 - 15:08:26 CST