RE: ResetLogs

From: Trassens, Christian <CTrassens_at_uni2.es>
Date: Thu, 11 Jan 2001 10:13:53 +0100
Message-Id: <10738.126383@fatcity.com>

Yong,

First of all, I know it was bad answer. Because I was doing several = things
when I answered. Even that, I would try to justife myself.

Issuing a shutdown normal....even an immediate would be enough....in = theory.
However, in my answer what I was implying is a way to avoid RESETLOGS. = I do
know there are others ways, f.e., you could mount the database and the = issue
an alter database clear logfile for each group. Or what a hell ( sorry = !)
recreate controlfile with resetlogs or issue an recover database until cancel and then an alter database open resetlogs.......and then backup = !!!.

Regards.

> -----Mensaje original-----
> De: yong huang [SMTP:yong321_at_yahoo.com]
> Enviado el: mi=E9rcoles 10 de enero de 2001 23:55
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: ResetLogs

>=20

> Hi, Christian,

>=20
> Why do you have to back up redo logfiles when you do cold backup? Are =
you
> saying there could be some remaining redo records left in redo logs, =
even
> with
> a normal shutdown?

>=20

> Yong Huang
> yong321_at_yahoo.com

>=20

> "Trassens, Christian" wrote:

>=20
> No if it is a cold backup. However and in terms of recovery, if you =
don't
> backup the redo logs, you'll need it.

>=20
> Oracle recommends not to backup redo logs, but in the case of cold =
backups
> you should do it because of the absence of archives.

>=20


> __________________________________________________

> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: yong huang
> INET: yong321_at_yahoo.com

>=20


> 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 Thu Jan 11 2001 - 03:13:53 CST