| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rman and database shutdowns UPDATE
Ron, the analogy I always use is "who has to recover the database when it crashes?" When they say, well, YOU, then I say Fine. We are going to back it up the way I see fit. End of story. Have fun testing~!!
Good Luck.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax: 954-935-3639
Cell: 954-683-4459
-----Original Message-----
Sent: Wednesday, February 12, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L
Ron - Yes they can back it up and recover it from their perspective. You've
brightened my day. Let us know if you want some more explanations to discuss
this with them again. ;-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, February 12, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L
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
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: 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).
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: Koivu, Lisa
INET: Lisa.Koivu_at_efairfield.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 - 14:56:20 CST
 |
 |