oh heck, if the recovery is that drastic, I'd probably backup the files
CURRENTLY on disk before restoring anything, just so that I had a place
I could return to if the restore didn't work properly (yes, I make
typos at 3AM!)
- "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us> wrote:
> chaos,
>
> if you believe everything you read in the oracle docs, then your are
> NOT a
> thinking DBA. just because they failed to mention that you should
> backup
> the log files does NOT mean you should not back them up.
>
> as everyone who knows anything has stated in this thread, this is a
> very bad
> idea. never mind the "what if" scenario you mentioned. anyone who
> is
> performing a database restore had better know exactly what and where
> they
> are restoring to (what point in time), and the condition of all of
> the
> database files on the disk before they begin. if they don't, they
> are in
> for trouble.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Wednesday, June 19, 2002 11:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> hi, Mercadante, Thomas F£¬ÄúºÃ£¡
> But according to Oracle Document(which i believe), oracle backup
> and
> recovery guide (version 8.1.6)page 4-4: it said:
>
> Use operating system commands or a backup utility to make backups
> of all
> datafiles and all control files specified by the CONTROL_FILES
> parameter of
> the initialization parameter file. Also back up the initialization
> parameter
> file
> and other Oracle product initialization files. To find them, do a
> search for
> *.ora starting in your Oracle home directory and recursively search
> all of
> its
> subdirectories.
> You can see, oracle mentions everything it need, but it does not
> mention the online redo log.
> And:
> Is the online redo log useful in recovery since you do a full clean
> cold backup? Just do a clear logfile group 1,2,3 and you cleanly
> opened your
> database when you Just restore the datafile,controlfiles.If you want
> to make
> full recovery, the online redo log is also totally USELESS. And if
> you
> carelessly overlay the old online redo log, the CURRENT ACTIVE ONLINE
> REDO
> LOG WILL BE DESTROYED! so , you cannot do complete recovery.
> This is my opinions.Though i also do not do coldbackup.
>
> Good luck!
>
> chaos
> chaospku_at_163.net
>
> zhu chao
> DBA of Eachnet.com
> 86-021-32174588-667
>
>
> ÔÚ 2002-06-19 06:43:00 You wrote:
> >chal_ping
> >
> >What? Makes no sense. Why NOT backup everything if you are taking
> a Cold
> >Backup. Why make yourself perform an open reset logs upon a
> recovery?
> >
> >This is bad advice.
> >
> >Personally, I use Rman performing hot backups all the time. My
> database is
> >*always* open to the world.
> >
> >Tom Mercadante
> >Oracle Certified Professional
> >
> >
> >-----Original Message-----
> >Sent: Wednesday, June 19, 2002 8: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.
> >
> > ÖÂ
> >Àñ£¡
> >
> > chal_ping
> > chaospku_at_163.net
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: chal_ping
> > INET: chaospku_at_163.net
> >
> >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).
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Mercadante, Thomas F
> > INET: NDATFM_at_labor.state.ny.us
> >
> >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).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: chaos
> INET: chaospku_at_163.net
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> 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).
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 - 12:58:35 CDT