-
Recovery
Hi
Im using Oracle 9i on Windos.When i was performing Clone database using cold backup i'm getting the following error
SQL> alter database recover using backup controlfile;
alter database recover using backup controlfile
*
ERROR at line 1:
ORA-00279: change 193666 generated at 11/26/2008 01:27:08 needed for thread 1
ORA-00289: suggestion : C:\ORACLE\ORADATA\NEWCLONE\ARCHIVE1_1.DBF
ORA-00280: change 193666 for thread 1 is in sequence #1
how can i recover my database?
-
If you have a true cold backup, you don't have to recover.
Alternatively, you can:
recover database using backup controlfile until cancel;
cancel;
alter database open resetlogs
-