I think anything that defaults is "messy"
maybe my name should be Lucy?
- Jeremiah Wilton <jwilton_at_speakeasy.net> wrote:
> There is actually a reason for the idea that it is a bad idea to
> backup online logs in a cold backup.
>
> Assuming the cold backup is for an archivelog mode database, then
> after restoring the database and starting up the instance, the
> database will come all the way open instantly with a simple startup
> command, making it impossible to apply the archived redologs and roll
> forward to a point in time.
>
> Chal Ping got mixed up and confused the "don't backup online logs
> while the instance is running" rule with the problem we are
> discussing
> today.
>
> So it is fine to backup online logs in a cold backup (why are you
> doing a cold backup again?). Just restore them to an alternate
> location by default so that you don't open the database accidentally
> and prevent yourself from rolling forward using archived redologs.
>
> So, why is resetlogs a "messy" way to create your logs? I do it all
> the time. Maybe my new login should be pigpen.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Wed, 19 Jun 2002, Mercadante, Thomas F wrote:
>
> > 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.
> >
> > -----Original Message-----
> >
> > >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.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.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).
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:23:29 CDT