Re: Hot backup question

Hi Paulo,

Yep, you don't need to online log files. They will be re-created by the resetlogs open. However, having them there will not hurt.

Regards, Steve

On 18 Jun 1997 20:14:06 GMT, anti-spam_at_invalid.domain (PM) wrote:

>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 Thu Jun 19 1997 - 00:00:00 CDT