Re: Hot backup question

From: PM <anti-spam_at_invalid.domain>
Date: 1997/06/18
Message-ID: <5o9fie$q3e$1@newstoo.worldbank.org>#1/1

Thanks Steve,

But I have another question :

should I backup/restore online redo logfiles ? No, correct ? In this case I need to create them after restoring the database and before opening it , right ?

Thanks, Paulo

In article <33a81f40.5485579_at_nntp.peg.apc.org>, steveadams_at_acslink.net.au says...
>
>Hi Paulo,
>
>You just need to use the "until cancel" syntax on the recover database
>command, and then cancel immediately. You can then do a resetlogs open
>of the database, which will restore it to the last transaction
>consistent state before the end of the backup. Of course, you will
>need then to take a new baseline backup to enable you to roll forward
>through any subsequently generated redo.
>
>HTH, Steve Adams
Received on Wed Jun 18 1997 - 00:00:00 CDT