Data file are in Recover status and dispatcher is not running

41 Views

Hi Experts,

Some of my datafile are in 'RECOVER' status and we do not have a backup.

Also,the oraarch files accidentally got deleted as well except 2 oraarch files.

While running the recover command we are getting the following error.

SQL> SELECT NAME FROM V$DATAFILE WHERE STATUS = 'RECOVER';

NAME -------------------------------------------------------------------------------

D:\ORACLE\SOM\SAPDATA1\UNDO_1\UNDO.DATA1

D:\ORACLE\SOM\SAPDATA2\SR3_5\SR3.DATA5

D:\ORACLE\SOM\SAPDATA2\SR3_6\SR3.DATA6

D:\ORACLE\SOM\SAPDATA2\SR3_10\SR3.DATA10

SQL> RECOVER DATAFILE 'D:\ORACLE\SOM\SAPDATA2\SR3_5\SR3.DATA5';

ORA-00279: change 80230516 generated at 03/03/2012 19:24:01 needed for thread 1 ORA-00289: suggestion : D:\ORACLE\SOM\ORAARCH\SOMARCHARC03042_0657733344.001 ORA-00280: change 80230516 for thread 1 is in sequence #3042 Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log 'D:\ORACLE\SOM\ORAARCH\SOMARCHARC03042_0657733344.001' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified.

Please suggest atleast how to bring the system up. Is there any way to recover the system? Can we change the recover status directly to 'ONLINE'?

Our OS is Wiondows.

Thanks & regards,

Shanahas