Re: Rman and database shutdowns UPDATE

Ron,

  Back when we had Oracle on VMS (Oracle 7.1 - pre RMAN), we used this backup command for each datafile:

backup/log/ignore=(interlock,nobackup)/new

  This will backup open files. But if your tablespace isn't in hot backup mode, it doesn't help you for database recovery. You might get lucky if there is little-to-no activity at the time of your backup, but this is a risk few DBAs would take.

Jay

>>> RROGERS_at_galottery.org 02/12/03 11:23AM >>>
Just got out of a meeting with the systems group. The Incremental backup was not working because the command was written wrong. There has been a decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an open file (datafile) and have it recovered properly. They can backup it up with an Ignore flag that backups up open files?  I will go with a cold backup methodology. Ron
>>> RROGERS_at_galottery.org 02/12/03 10:18AM >>>
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




**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.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).