Hi
I have taken the control file backup after that I lost than I restored my control file and trying to open my database. But I am getting below error.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1670221824 bytes
Fixed Size 2176328 bytes
Variable Size 1291848376 bytes
Database Buffers 369098752 bytes
Redo Buffers 7098368 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORADATA\HIMANSHU\SYSTEM01.DBF'
its asking to do media recovery. Can anyone help me how to do this please ..
Thank You
please find below this also what I have tried after above error :
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 6549558 generated at 02/01/2013 22:02:28 needed for thread 1
ORA-00289: suggestion :
C:\FLASH_RECOVERY_AREA\HIMANSHU\ARCHIVELOG\2013_02_03\O1_MF_1_298_8JV71ZTH_.ARC
ORA-00280: change 6549558 for thread 1 is in sequence #298
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\ORADATA\HIMANSHU\SYSTEM01.DBF'
SQL>