Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rman and database shutdowns

RE: Rman and database shutdowns

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 12 Feb 2003 08:34:04 -0800
Message-ID: <F001.0054AC4C.20030212083404@fatcity.com>


Ron

   RMAN documentation uses the terms open and closed. RMAN can back up an open database. RMAN can back up a closed database (not usual, except for a non-archivelog database). You can shut the database down when RMAN is not performing a backup. RMAN can even bring the database up or down. Just don't shut the database down while RMAN is backing it up :-)

   And buy Robert Freeman's book Oracle 9i RMAN Backup and Recovery.

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). Received on Wed Feb 12 2003 - 10:34:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US