Re: EBU backup and online redo log backup

John,

EBU will issue an archivelog current and archivelog all command before it backs up the database and archivelog files. Once these commands have processed the information will always be in the archivelog files. The current online redolog will be locked by the instances service so it cannot be deleted until a complete shutdown is done. If you have a crash a burn system to test with, to see why the online redo is not needed, shutdown the test database. Delete the online logs, and mount the database. Then, recover until cancel;. It will either say media recovery complete or make a suggestion as to what archive to apply. Just type CANCEL. Then, alter database open resetlogs;. Keep in mind after a resetlogs the previously backed up archivelogs are useless since the resetlogs resets the database scn to 0.

The end result will be that your online logs will be recreated from the values and path listed for them in the controlfile and no information is lost.

Hope this helps.

John Wang <rwang_at_erols.com> wrote in article <6oebac$lh8$1_at_winter.news.erols.com>...
> Hi, All:
>
> I am using Oracle 7.3.4 on HP/UX. In the EBU documentation, it says EBU
> does not backup online redo log files because redo log files does not
serve
> any recovery purpose. Here is the situation. I am doing backup/recovery
> under certain failure scenerios on a test database.
>
> the test database has 3 log groups, each has a log member,log1, log2,
log3.
> Log2 is the current one. I did 10 inserts and did not commit. Then I
did a
> log switch. So, log3 is the current log. At this point, I deleted the 3
> log files, log1.dbf, log2.dbf, and log3.dbf. I aborted the instance.
Then
> I mounted the instance. Since, log1 and log2 are not current log files.
I
> can drop and recreated the files. But for log3.dbf, I do not have a
backup
> because EBU does not backup on line redo logs. I cannot drop the log
file,
> because it is the current one. Do you see my problems here? Without
> log3.dbf, my instance is dead. Is this a bug in EBU or what? Anybody
has
> any ideas? I am lost.
>
> Thanks
>
> John W.
>
>
>
Received on Wed Jul 15 1998 - 06:46:10 CDT