Home » Server Options » Data Guard » ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1 '.........\SYSTEM01.D' (ORACLE 9i)
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1 '.........\SYSTEM01.D' [message #380936] Wed, 14 January 2009 03:21 Go to next message
BTRIEVE
Messages: 8
Registered: September 2008
Junior Member
Db works archievelogs mode.
I try to test server for oracle tests.
when i use "alter databse open resetlogs" command, i take some erros.
try to recover database or datafile from archievelogs and redo logs, cant do it
Please help me about

------------------------------------------------------------

C:\Documents and Settings\Administrator.MIOROS>rem oradIm -SHUTDOWN -SID TEST -
USRPWD manager -SHUTTYPE SRVC,INST

C:\Documents and Settings\Administrator.MIOROS>oradIm -delete -sId TEST

C:\Documents and Settings\Administrator.MIOROS>pIng localhost -n 5 > nul

C:\Documents and Settings\Administrator.MIOROS>del G:\TEST\control*

C:\Documents and Settings\Administrator.MIOROS>del G:\TEST\TEMP01.DBF
Could Not Find G:\TEST\TEMP01.DBF

C:\Documents and Settings\Administrator.MIOROS>echo control_fIles=(G:\TEST\CONTR
OL01.CTL,G:\TEST\CONTROL02.CTL,G:\TEST\CONTROL03.CTL)>> G:\TEST\InIt.ora

C:\Documents and Settings\Administrator.MIOROS>echo db_name = TEST>> G:\TEST\InI
t.ora

C:\Documents and Settings\Administrator.MIOROS>oradIm -new -Intpwd manager -sId
TEST -startmode auto -pfIle G:\TEST\InIt.ora

C:\Documents and Settings\Administrator.MIOROS>pIng localhost -n 10 > nul

C:\Documents and Settings\Administrator.MIOROS>set oracle_sId=TEST

C:\Documents and Settings\Administrator.MIOROS>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jan 14 10:43:46 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect sys/manager as sysdba
Connected to an idle instance.
SQL> startup nomount pfIle=G:\TEST\InIt.ora
ORACLE instance started.

Total System Global Area 1594959832 bytes
Fixed Size 456664 bytes
Variable Size 754974720 bytes
Database Buffers 838860800 bytes
Redo Buffers 667648 bytes
SQL> create controlfIle set database "TEST" resetlogs
2 logfIle
3 group 1 'G:\TEST\REDO11.LOG' sIze 10M,
4 group 2 'G:\TEST\REDO12.LOG' sIze 10M,
5 group 3 'G:\TEST\REDO13.LOG' sIze 10M,
6 group 4 'G:\TEST\REDO21.LOG' sIze 10M,
7 group 5 'G:\TEST\REDO22.LOG' sIze 10M,
8 group 6 'G:\TEST\REDO23.LOG' sIze 10M,
9 group 7 'G:\TEST\REDO31.LOG' sIze 10M,
10 group 8 'G:\TEST\REDO32.LOG' sIze 10M,
11 group 9 'G:\TEST\REDO33.LOG' sIze 10M
12 datafIle
13 'G:\TEST\IFSAPP_ARCHIVE_DATA.DBF',
14 'G:\TEST\IFSAPP_ARCHIVE_INDEX.DBF',
15 'G:\TEST\IFSAPP_DATA.DBF',
16 'G:\TEST\IFSAPP_DATA2.DBF',
17 'G:\TEST\IFSAPP_DATA3.DBF',
18 'G:\TEST\IFSAPP_INDEX.DBF',
19 'G:\TEST\IFSAPP_INDEX2.DBF',
20 'G:\TEST\IFSAPP_INDEX3.DBF',
21 'G:\TEST\IFSAPP_REPORT_DATA.DBF',
22 'G:\TEST\IFSAPP_REPORT_INDEX.DBF',
23 'G:\TEST\SYSTEM01.DBF',
24 'G:\TEST\UNDOTBS01.DBF',
25 'G:\TEST\USERS01.DBF',
26 'G:\TEST\TOOLS01.DBF';

Control file created.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\TEST\SYSTEM01.DBF'


SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 0 10485760 1 YES UNUSED
0

2 1 0 10485760 1 YES UNUSED
0

3 1 0 10485760 1 YES UNUSED
0


GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
4 1 0 10485760 1 YES UNUSED
0

5 1 0 10485760 1 YES UNUSED
0

6 1 0 10485760 1 YES UNUSED
0


GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
7 1 0 10485760 1 YES UNUSED
0

8 1 0 10485760 1 YES UNUSED
0

9 1 0 10485760 1 YES INVALIDATED
0


9 rows selected.

SQL> alter database recover datafile 'g:\test\system01.dbf'
2
SQL> alter database recover datafile 'g:\test\system01.dbf';
alter database recover datafile 'g:\test\system01.dbf'
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database until cancel using backup controlfile;
ORA-00279: change 302423545 generated at 01/14/2009 09:25:14 needed for thread
1
ORA-00289: suggestion : G:\TEST\ARCHIVELOGS\672825376_1_49174.ARC
ORA-00280: change 302423545 for thread 1 is in sequence #49174


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


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
g:\test\redo33.log
ORA-00310: archived log contains sequence 49167; sequence 49174 required
ORA-00334: archived log: 'G:\TEST\REDO33.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\TEST\SYSTEM01.DBF'


SQL> recover database until cancel using backup controlfile;
ORA-00279: change 302423545 generated at 01/14/2009 09:25:14 needed for thread
1
ORA-00289: suggestion : G:\TEST\ARCHIVELOGS\672825376_1_49174.ARC
ORA-00280: change 302423545 for thread 1 is in sequence #49174


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
g:\test\redo32.log
ORA-00310: archived log contains sequence 49166; sequence 49174 required
ORA-00334: archived log: 'G:\TEST\REDO32.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\TEST\SYSTEM01.DBF'


SQL> recover database until cancel using backup controlfile;
ORA-00279: change 302423545 generated at 01/14/2009 09:25:14 needed for thread
1
ORA-00289: suggestion : G:\TEST\ARCHIVELOGS\672825376_1_49174.ARC
ORA-00280: change 302423545 for thread 1 is in sequence #49174


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
g:\test\redo31.log
ORA-00310: archived log contains sequence 49165; sequence 49174 required
ORA-00334: archived log: 'G:\TEST\REDO31.LOG'


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\TEST\SYSTEM01.DBF'
Re: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1 '.........\SYSTEM0 [message #381044 is a reply to message #380936] Wed, 14 January 2009 23:51 Go to previous messageGo to next message
BTRIEVE
Messages: 8
Registered: September 2008
Junior Member
ORA-01547: warning: RECOVER succeeded but OPEN
ORA-01194: file 1 needs more recovery to be con
ORA-01110: data file 1: 'G:\TEST\SYSTEM01.DBF'

i will take these messages
Re: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1 '.........\SYSTEM0 [message #381743 is a reply to message #381044] Mon, 19 January 2009 10:45 Go to previous message
sonumalhi
Messages: 62
Registered: April 2008
Member
Try this

SQL> recover database until cancel using backup controlfile;

then cancel the recovery by entering keyword CANCEL.

then try open resetlogs.

SQL> ALTER DATABASE OPEN RESTLOGS;

Previous Topic: dbstart
Next Topic: Failover
Goto Forum:
  


Current Time: Wed Dec 07 03:13:59 CST 2016

Total time taken to generate the page: 0.10750 seconds