Hello Qun,
I think you've lost the context. This was a question about cloning
and renaming a database, which would require a resetlogs open, and
which would not involve applying any archived redo. Therefore, the
presence or otherwise to the online redo log files from the cold
backup is a matter of indifference. If we had been talking about
recovery and restoration, I would agree with you emphatically.
Regards, Steve
On Tue, 24 Jun 1997 10:18:34 -0700, Qun Li <qun.li_at_DELETE.attws.com>
wrote:
>Well, I do not agree with what Steve said about the redo log files in
>the hot backup. Having them there will HURT your recovery if you want to
>apply the archive logs which had generated after the hot backup being
>done. Because the recovery process will check the online redo log first
>so keep the old redo logs in your hot backup will NOT help the recovery
>to the point-of-time with archive logs.
>
>-- Qun
>
>Steve Adams wrote:
>>
>> 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
Received on Mon Jun 30 1997 - 00:00:00 CDT
