| 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: Repost: Offline vs Online
Tracy,
If you have a very reliable online-backup methodology that has been fully tested (like - do a backup, delete all of your database files from disk, perform a restore and it all comes back), then the answer to your question is - no. Offline backups are a thing of the not-too-distant past. The Oracle recovery process is very mature.
If, on the other hand, you are not comfortable with your current backup methodology - like it has never been tested, or it is not tested on a regular basis, then a cold offline backup is a must.
Backup/restore testing should be a part of every production system, and should be done on a regular basis. I use Rman for all backups, and run a restore/validate on a weekly basis to make sure that the tapes are available and readable.
hope this helps!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, June 19, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L
I appreciate the ongoing discussion regarding the logs, but does anybody
have
any comments
regarding the questions I previously asked? Here they are again:
If you create a new database and do a full online backup (this also includes
future regular full online backups) is it ever necessary to do a full
offline
backup(ie shutdown, backup, startup)? I have heard conflicting answers,
regarding
this and am looking for some clarification. Don't 24x7 applications always
have to
execute offline backups? Are offline backups done for peace of mind, and if
yes why? What
issues are introduced if only offline backups are issued. In addition, we
are
using BMCs Sql BackTrack product and I am not sure if it is a requirement of
the tool that an offline backup be periodically performed. If you know that
as
well, please share. Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
INET: tracy.rahmlow_at_aexp.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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 Jun 19 2002 - 13:58:57 CDT
 |
 |