Re: Archive Logs

1. cold backup your current database datafiles and redos.
2. restore your backup database files and all your backup archivelogs for the past three weeks and perform a database recovery. This will roll forward all your transactions and recover your database to the point of disaster.
3. open database with resetlogs.
4. shutdown the database and perform a cold backup of all your database files.
5. startup database if you have a hot backup and all the related archivelogs then you can perform the recovery on the tablespaces in concern. This will take less time.

HTH John Chiu

Paweł Kokot <pkokot_at_zg.szczecin.pl> wrote in message news:822ldm$ng9$1_at_sunsite.icm.edu.pl...
> Hi,
> I have a problem. I have ORACLE database (on tape 3 weeks old) and
> archivelogs (3 weeks). There was disaster yesterday. How can I rebuild my
> database using old database and archivelogs?
>
> --
> Paweł Kokot
> STAR-SOFT Cieszyn
>
>
Received on Wed Dec 01 1999 - 05:53:31 CST