Re: Online vs offline backups

All backupers

If doing a "off-line backup" some call it a "cold backup" you should backup All datafiles, All control files, All Redolog files and All Parameter files
this vil produce a self-contained package that will be able ti start assuming no media recovery is needed.
I know that Rman vill not backup redolog file the reason for rman not doing this is that Rman knows if it is safe to omit the redolog files (The database has to bee in mount mode for Rman to backup's )

Ferenc Mantfeld wrote:

>-----Original Message-----
>Sent: Wednesday, 19 June 2002 5:38 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Ferenc Mantfeld£¬
>
>
>
>>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.
>>
>>
> For cold backup, oracle does not recommend backup the online redo
>log. And if you restore the whole cold backup, why need the online redo log?
>I am sure people doing cold backup will do shutdown normal/immediate, not
>shutdown abort.So there is no need to backup the online redo log at all!
>Backup the online redo log also take the risk of damage the current online
>redo log when you want to do full recovery.
> So, never backup the online redo log when doing cold backup.
>
>FM : and hopefully in time you will come to the realization that not all
>that Oracle recommends is good, or has passed a decent degree of sanity
>checking. But I can see that the PR and hype machine still works well.
>
>Apologies for starting this pissing contest, I have my convictions based on
>true life experiences, rather than from attending a course. I suggest
>reading Rama Velpuri's book on backup and recovery first. Then if you want
>to simply open the database as it was at the time of cold backup, if your
>online redo logs have not been restored, you will need to perform recovery.
>An you cannot restore what has not been backed up. Amen ! Chapter closed !
>
>redo log corruptions are another deal altogether.
>
> ÖÂ
>Àñ£¡
>
> chal_ping
> chaospku_at_163.net
>
>
>

-- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856

Miracle A/S
Kratvej 2
2760 Ma*l?v
http://miracleas.dk

/*
The process of preparing programs for a digital computer is especially
attractive, not only because it can be economically and scientifically
rewarding, but also because it can be an aesthetic experience much like 
composing poetry or music

Donald Knuth
*/ 





Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.

--------------ms050301010101070004080709--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

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).



application/x-pkcs7-signature attachment: smime.p7s