datafile_problem

[Arsalan]

i run the below command it give error

SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11:
'C:\APP\SIGTAS\PRODUCT\11.2.0\DBHOME_1\DATABASE\UNNAMED00011'
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11:
'C:\APP\SIGTAS\PRODUCT\11.2.0\DBHOME_1\DATABASE\UNNAMED00011'

[Arsalan]

I want just database open,without recovery ,

in this database i have a few tables which i have already backup in dump,

i will import my dumps file after database open,,

thanks for your  hard work and helped me
it is final just open my db i will import my dumpfile later

[ErmanArslansOracleBlog]

What is this datafile 11?
Did you recreate the controlfile ?
There is a datafile recorded in the controlfile, but it is not there in the filesystem.
Correct this first.

[Arsalan]

I RECREATED CONTROLFILE AND ALSO INCLUD FILE 11
what is next step

SQL> CREATE CONTROLFILE REUSE DATABASE  "DWHSIG" RESETLOGS archivelog
  2  MAXLOGFILES 3
  3  MAXLOGMEMBERS 3
  4  MAXDATAFILES 11
  5  MAXINSTANCES 1
  6  MAXLOGHISTORY 113
  7  LOGFILE
  8  GROUP 1 'C:\app\sigtas\oradata\dwhsig\REDO01.LOG' SIZE 100M,
  9  GROUP 2 'C:\app\sigtas\oradata\dwhsig\REDO02.LOG' SIZE 100M,
 10  GROUP 3 'C:\app\sigtas\oradata\dwhsig\REDO03.LOG' SIZE 100M
 11  DATAFILE
 12  'C:\app\sigtas\oradata\dwhsig\SYSTEM01.DBF' ,
 13  'C:\app\sigtas\oradata\dwhsig\USERS01.DBF' ,
 14  'C:\app\sigtas\oradata\dwhsig\EXAMPLE01.DBF' ,
 15  'C:\app\sigtas\oradata\dwhsig\SYSAUX01.DBF' ,
 16  'C:\app\sigtas\oradata\dwhsig\IRD_INDEXES.DBF',
 17  'C:\app\sigtas\oradata\dwhsig\IRD_DATA_LARGE.DBF' ,
 18  'C:\app\sigtas\oradata\dwhsig\IRD_BASE.DBF',
 19  'C:\app\sigtas\oradata\dwhsig\DB_AUDIT_TBS_01.DBF',
 20  'C:\APP\SIGTAS\ORADATA\DWHSIG\IRD_DATA_LARGE02.DBF',
 21  'C:\app\sigtas\oradata\dwhsig\\UNDOTBS01.DBF' ;

Control file created.

[ErmanArslansOracleBlog]

while you are in mount mode, issue the following command:

recover database using backup controlfile;

After that, Oracle will request the archivelogs.. Supply them and recover the database.. till you reach log sequence number 1620.

[Arsalan]

SQL> recover database using backup controlfile;
ORA-00279: change 22218085 generated at 02/18/2017 15:20:03 needed for thread
ORA-00289: suggestion : D:\BACKUP\ARCHIVELOG1\ARC0000001399_0930392801.0001
ORA-00280: change 22218085 for thread 1 is in sequence #1399


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'D:\BACKUP\ARCHIVELOG1\ARC0000001399_0930392801.0001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

[ErmanArslansOracleBlog]

Where are your archivelog files? You have the required archivelog files right? (for instance the one which is created for sequence 1399..)
For a quick solution, don't use AUTO, supply them manually. (give full path of the requested archivelog file)