RE: Rman and database shutdowns

Ron - I reread your question a little closer, and am still a little confused.

Okay, you are doing both RMAN and cold backups? That is okay as long as you don't shut down the database while RMAN is performing its backup. We have been doing both for several months until we complete our RMAN disaster recovery test.

You don't want the O.S. to back up the Oracle files when they are open and not in a hot backup state. So I don't follow the incremental backup / timestamp comment.

You wrote "Are there any possible problems doing a restore from the cold backup
and then using the RMAN backup/restore?" Absolutely. You could really confuse RMAN and personally I have enough challenges from a non-confused RMAN. You should choose to either recover using RMAN or recover without RMAN
(taking an RMAN backup afterward), but no hybrids. While we've been doing
both backups, thankfully we haven't had to perform a recovery, but if we had, I would tend to do an RMAN recovery because that is much simpler and it would increase my confidence in RMAN. Of course, since we are backing RMAN up to disk, I would have to ensure the RMAN backup files were available where RMAN last left them. ;-)

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

-----Original Message-----
Sent: Wednesday, February 12, 2003 9:19 AM To: Multiple recipients of list ORACLE-L

List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a question.
The system nightly backup procedures backup up the disks used by Oracle
(software and data). A full backup works but an incremental does not
backup any files. Inorder to get the changed files to be backed up as an incremental the sysadmin shutdown the database to flag the files as changed.
Questions:
 How will the shutdown effect the RMAN backup if it does not know that it was shutdown for a cold backup?
Are there any possible problems doing a restore from the cold backup and then using the RMAN backup/restore?

 I am still trying to figure out the OpenVms OS. Perserverience required...!
Ron

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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