Oracle Database Discussions

Hi ALL,

EBS R12.2.4

OEL6

I am performing database recovery using >   recover database using backup controlfile until cancel;

but I encountered error:

ORA-00279: change 5965308871319 generated at 11/29/2015 10:49:20 needed for

thread 1

ORA-00289: suggestion : /home/ARCH/1_212_894234402.dbf

ORA-00280: change 5965308871319 for thread 1 is in sequence #212

ORA-00278: log file '/home/ARCH/1_211_894234402.dbf' no longer needed for this

recovery

ORA-00283: recovery session canceled due to errors

ORA-01244: unnamed datafile(s) added to control file by media recovery

ORA-01110: data file 42: '/home/oraprod/PROD/data/a_txn_ind10.dbf'

ORA-01112: media recovery not started

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size                  2230072 bytes

Variable Size             452987080 bytes

Database Buffers         1660944384 bytes

Redo Buffers               21725184 bytes

Database mounted.

SQL>  recover database using backup controlfile until cancel;

ORA-00283: recovery session canceled due to errors

ORA-01111: name for data file 42 is unknown - rename to correct file

ORA-01110: data file 42: '/home/oraprod/PROD/11.2.0/dbs/UNNAMED00042'

ORA-01157: cannot identify/lock data file 42 - see DBWR trace file

ORA-01111: name for data file 42 is unknown - rename to correct file

ORA-01110: data file 42: '/home/oraprod/PROD/11.2.0/dbs/UNNAMED00042'

SQL>

Please help....

Thanks,

jc