Re: datafile_problem

Posted by Arsalan on Mar 08, 2017; 5:45am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/datafile-problem-tp2282p2294.html

i create control file manual
--------------------

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE  "DWHSIG" RESETLOGS archivelog
MAXLOGFILES 3
MAXLOGMEMBERS 3
MAXDATAFILES 9
MAXINSTANCES 1
MAXLOGHISTORY 113
LOGFILE
GROUP 1 'C:\app\sigtas\oradata\dwhsig\REDO01.LOG' SIZE 100M,
GROUP 2 'C:\app\sigtas\oradata\dwhsig\REDO02.LOG' SIZE 100M,
GROUP 3 'C:\app\sigtas\oradata\dwhsig\REDO03.LOG' SIZE 100M
DATAFILE
'C:\app\sigtas\oradata\dwhsig\SYSTEM01.DBF' ,
'C:\app\sigtas\oradata\dwhsig\USERS01.DBF' ,
'C:\app\sigtas\oradata\dwhsig\EXAMPLE01.DBF' ,
'C:\app\sigtas\oradata\dwhsig\SYSAUX01.DBF' ,
'C:\app\sigtas\oradata\dwhsig\IRD_INDEXES.DBF',
'C:\app\sigtas\oradata\dwhsig\IRD_DATA_LARGE.DBF' ,
'C:\app\sigtas\oradata\dwhsig\IRD_BASE.DBF',
'C:\app\sigtas\oradata\dwhsig\DB_AUDIT_TBS_01.DBF',
'C:\app\sigtas\oradata\dwhsig\\UNDOTBS01.DBF' ;
---------------------------------------------------

SQL> startup mount;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL>  recover database using backup controlfile until cancel;
ORA-00279: change 23957082 generated at 03/01/2017 06:33:01 needed for thread 1
ORA-00289: suggestion : D:\BACKUP\ARCHIVELOG1\ARC0000001559_0930392801.0001
ORA-00280: change 23957082 for thread 1 is in sequence #1559


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\APP\SIGTAS\ORADATA\DWHSIG\SYSTEM01.DBF'