Re: datafile_problem

Posted by Arsalan on Mar 08, 2017; 12:50pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/datafile-problem-tp2282p2313.html

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.