Re: Redo Logs and Backup

On Tue, 24 Feb 1998 18:40:31 -0500, "venkata terala" <venkata_at_inetnow.net> wrote: Hi,

SWITCH LOGFILEs (number of logfiles + 1) - times

>Vincent,
>You should NOT backup the redo logs as part of your backup. Restoring logs
>from a backup could cause corruption of the database. You should do an
>ALTER SYSTEM SWITCH LOGFILE and backup the archive logs to the most current
>one. This way you'll have the most recent changes. This way even if you
>were to lose your online logs the data loss would be very minmal, if any.
>If logs are mirrored (they should always be), you'll not have to do an open
>resetlogs in case you lose one set of logs.
>Hope that answers your question
>regards
>Venkat
>>I would like to avoid backing up the redolog files of my database (and then
>>only copy the datafiles and the archive logs). An idea could be to do
>>severals 'switch logfile' before the shutdown in order to trigger some
>>checkpoints and then update the datafiles.
>>
>>What do you think of that ?
>>
>>
>>
>
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de