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 > [EMAIL PROTECTED] > > > -- /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 */
smime.p7s
Description: application/pkcs7-signature