RE: Recovery from online backup

Hi all,
I finally succeeded in restoring a whole db without any evident loss of data.

Below, some more comments, questions/doubts:

>
>
>
> 3- Restore datafiles:
>
> DO NOT RESTORE ONLINE LOGS FROM BACKUP!!!!
I restored the current online log because I needed to use it after the last archivelog during recovery

>
> DO NOT ERASE CURRENT ONLINE LOGS (if we have it)

I needed to simulate a complete loss and restore of db, so I backed up, deleted and restore all the redologs (with the rest of datafiles), but , as said above, I had any problem during recovery

>
>
> SQL> CREATE CONTROLFILE REUSE DATABASE "XXXX" RESETLOGS ARCHIVELOG
>

...............
>
> If we have current ONLINE LOGS (NOT BACKED UP CONTROLFILES) we can use NORESETLOGS

I could not use NORESETLOGS (ORA-01588: must use RESETLOGS option for database open): is this a consequence of restoring the online log? If yes, which is the difference between "not erasing" and "copying and restoring" if the all datafiles and controlfiles are lost?

>
>
>
>
> We will press RETURN UNTIL it ask for archivelog that donīt exist then we will pass ONLINE LOG path and file names.

Worked fine!

>
>
> 9- SQL> ALTER DATABASE OPEN RESETLOGS;
>
> If we used NORESETLOGS before then “alter database open Noresetlogs”

I had to use RESETLOGS (see above).

>
>
> -----Mensaje original-----

> To: Oracle-L
>
> Subject: RE: Recovery from online backup
>
>
> The backup script contained the command:
>
>
> alter database backup controlfile to '<destination_path/file>'
>
>
>
> I tried to copy the controlfile from the <destination_path/file> to the
>
> original location, but still the database cannot mount (ORA-00205).
>
>
> Is document id 94114.1 correct or some more steps needed to be performed?
>

Thanks for your help,

Alessandro

--
http://www.freelists.org/webpage/oracle-l