Oracle-L: RE: Online vs offline backups

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Wed, 19 Jun 2002 10:40:18 -0800
Message-ID: <F001.00481933.20020619104018@fatcity.com>

I agree. I am debating the same silliness of taking a cold backup of a 160GB database prior to the Application code upgrade is rolled out. Every other week there is an enhanced code roll out! The funny thing is there are no structural changes to the database. The database runs in archive log mode, on-line backup is taken every day (I will let them have that for now). Some ex-DBA type used to work with Appl folks prior to us acquiring this DB, but they do not want to change old practices. However, the new DBA team (us) is responsible for making sure the backup completes in less than 2 hours (or before it starts!!). The DB was less than 30GB when that downtime was set up!!
Next week, the backup will be done within no time at all ;)

Kirti

-----Original Message-----
Sent: Wednesday, June 19, 2002 7:03 AM
To: Multiple recipients of list ORACLE-L

I once heard someone actually say 'For peace of mind, perform a monthly cold backup'. My opinion is that this is the biggest load of crap I have ever heard. If your backup, or more importantly, your recovery strategy has been tested, there is zero NEED for a cold backup, as you can fully recover just as easily from a hot backup. The same person that advocated a cold backup did not back up the online redo logs, so what use was it anyway, since the only way they would force open their DB is with a resetlogs option anyway.

Think people, think ! Sometimes it really is not rocket science but just pure common sense based on some elementary knowledge.

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Only Robinson Crusoe had all his work done by Friday

-----Original Message-----
Sent: Tuesday, 18 June 2002 3:59 PM
To: Multiple recipients of list ORACLE-L

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? 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 everybody

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.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). Received on Wed Jun 19 2002 - 13:40:18 CDT