Re: Off Topic: SQL-Backtrack

> I don't see any reasons for COLD backup after resetlogs.
> Hot backups will be just fine.
>
> Am i missing something?

Yes. :)

After doing a RESETLOGS, you no longer have a backup you can recover from.

If you open the database for use without making a cold backup, any work that is done while making your hot backup will be unrecoverable if you lose the database before the hot backup is finished.

Jared

On Thu, 6 Jul 2000, kgopalakrishnan wrote:

> jared !
>
>
> >> For some databases, there isn't a regular window that can be used for
> >> cold backups, so only full on-line daily backups will be done. Any
> >> problem with this strategy?
> >
> >The usual cold vs. hot backup arguments would apply. A hot backup
> >should be fine. There are certain situations where a cold backup
> >is necessary, such as after opening with RESETLOGS.
>
> I don't see any reasons for COLD backup after resetlogs.
> Hot backups will be just fine.
>
> Am i missing something?
>
>
> K Gopalakrishnan
> Bangalore, INDIA
>
>
>
> --
> Author: kgopalakrishnan
> INET: kgopalakrishnan_at_mantraonline.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).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Thu Jul 06 2000 - 12:25:03 CDT