Oracle-L: RE: Hot backups

From: Schauss, Peter <pschauss_at_northropgrumman.com>
Date: Tue, 11 Mar 2003 07:34:17 -0800
Message-ID: <F001.005660C9.20030311073417@fatcity.com>

I tried it both ways and got the same result.

According to my notes from the Oracle Backup and Recovery course when you apply your redo logs, the control file gets rolled forward along with the data files. I believe that the only time you would get into trouble here is if you had made structural changes after the control file was backed up. This should not be an issue in my application.

Peter Schauss
Northrop Grumman Corporation

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

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:

From sqlplus: backup controlfile to '<filename>';
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;
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:

Copied the init.ora file from the backed up database.
Restore the copied tablespaces and control files.
Copy the archived redo logs to the directory specified in the init.ora file.
Note the number on the most recent redo log.
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).
--

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
---------------------------------------------------------------------