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 (See ORA-01588.ora-code.com): 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 (See ORA-00205.ora-code.com)). > > > Is document id 94114.1 correct or some more steps needed to be performed? >
