Data file are in Recover status and dispatcher is not running

[Former Member]

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

[pr_srinivas]

Hi

As Stever, already confirmed - Dont you have required  offline archive log files ?

Check out - May(not) be useful
SAP Note#  0491160 - Restore scenarios for lost files of oracle databases
SAP Note#  0004161 - Complete recovery

Rgds
PR

[former_member182307]

Hello,

If you do not have the archived redo log required by the recover process, there is no way you can bring back this db online.

You' ll have to restore from a previous consistent backup if you have one.

BR,

Steve.