| 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  |
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'
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
