Hello gurus,
To learn recovery part i have deleted my controlfile. I have a controlfile backup.
But when i am trying to recover the control file through rman it gets successed but when i am trying to open the database i get some errors following..
Can you please help me...
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\APP\INDRA\ORADATA\FTECH\SYSTEM01.DBF'
SQL>
then i got some tips from this forums to resolve and i tried this but
SQL> recover database using backup controlfile;
ORA-00279: change 1012515 generated at 04/04/2013 11:36:23 needed for thread 1
ORA-00289: suggestion :
C:\APP\INDRA\PRODUCT\11.1.0\DB_1\DATABASE\USE_DB_RECOVER_FILE_DESTARC00006_08117
76696.001
ORA-00280: change 1012515 for thread 1 is in sequence #6
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
regards,
Indra