Re: Confusion why online redo logs should never be backed up.

Agreed.

If you restore from a cold backup to a different server, you don't need to restore online redologs if you did a "shutdown/shutdown immediate". A "resetlogs" will create the new logs for you. If you did a shutdown abort (or any other abnormal shutdown), like kill -thingy), you will need the redologs for startup, on a *different* server or $ORACLE_SID

However as Jared pointed out, resetlogs is something I would like to avoid as well -- reason being to avoid having to do a full backup again before you let users loose on the system.

On the same production system, backup (and restore) of online redologs can cause a lot of damage, and that is the gist of my message.

Bottom line remains that there is an understanding of the basic issues, and you don't need a week to argue over it.

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, May 23, 2003 9:19 AM

> If you restore a database to another server, lets say,
> from a cold backup, it would be perfectly acceptable
> to restore the online redo logs as well.
>
> This way, you don't even need to do a recovery,
> just start the database.
>
> Don't tell me I would hardly ever do this, cause
> I just did it 2 days ago.
>
>
> -----Original Message-----
> Sent: Thursday, May 22, 2003 2:53 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Argument? What argument?
>
> Online redologs backups are meaningless by definition. They will be
> out-of-date as soon as something changes within the DB. You "backup" the
> redologs by mirroring.
>
> Backup them up is not a problem apart from wasting a bit of tape space.
> Accidentally restoring backup redologs on top of current redologs is the
> real danger where you will loose information in the current, or any
> non-current un-archived redologs.
>
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Friday, May 23, 2003 7:07 AM
>
>
> > Rick - Is it a slow afternoon with you? Just thought you'd revive this
old
> > argument? I think the last time this was brought up the thread went for
> > about a week.
> >
> > Dennis Williams
> > DBA, 80%OCP, 100% DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----Original Message-----
> > Sent: Thursday, May 22, 2003 1:27 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Hi All,
> >
> > In Oracle8i Backup & Recovery Handbook pg 13 it states "Finally, online
> > redo log files should never be backed up....So, it is good practice not
to
> > back up online log files for ANY kind of backup.
> >
> > Can someone clearly explain why this is recommended?
> >
> > Thanks
> > Rick
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> > INET: Rick_Cale_at_teamhealth.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.COM
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: Binley Lim
> INET: Binley.Lim_at_xtra.co.nz
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>
> Privileged/Confidential information may be contained in this message. The
> information contained in this message is intended only for the use of the
> recipient(s) named above and their co-workers who are working on the same
> matter.
>
> The recipient of this information is prohibited from disclosing the
> information to any other party unless this disclosure has been authorized
in
> advance.
>
> If you are not intended recipient of this message or any agent responsible
> for delivery of the message to the intended recipient, you are hereby
> notified that any disclosure, copying, distribution or action taken in
> reliance on the contents of this message is strictly prohibited. You
should
> immediately destroy this message and kindly notify the sender by reply
> E-Mail.
>
> Please advise immediately if you or your employer does not consent to
> Internet E-Mail for messages of this kind. Opinions, conclusions and
other
> information in this message that do not relate to the official business of
> the firm shall be understood as neither given nor endorsed by it.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kurth, Michael J.
> INET: MJKurth_at_covhealth.org
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Binley Lim
  INET: Binley.Lim_at_xtra.co.nz

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).