Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\ibm>set oracld.sid=gaacC:\Documents and Settings\ibm>sqlplus /nologSQL*Plus: Release 8.1.7.0.0 - Production on Sun Mar 22 00:44:33 2009(c) Copyright 2000 Oracle Corporation. All rights reserved.
相关操作如下:
SQL> conn system/sa@gaac as sysdba;
Connected.
SQL> select open_mode from v$database;OPEN_MODE
----------
MOUNTEDSQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\GAAC\GAACSYS1.DBF'
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 4 of thread 1 is not current copy
ORA-00312: online log 4 thread 1: 'D:\GAAC\GAACLOG4A.LOG'---------------------------------------以下是gaacALRT.log全文中尾部部分:
Tue Mar 17 10:06:38 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Mar 17 10:06:39 2009
alter database mount
Tue Mar 17 10:06:46 2009
Successful mount of redo thread 1, with mount id 1768127222.
Tue Mar 17 10:06:46 2009
Database mounted in Exclusive Mode.
Completed: alter database mount
Tue Mar 17 10:06:46 2009
alter database open
ORA-1113 signalled during: alter database open ...
Dump file D:\GAAC\bDump\gaacALRT.LOG
Sun Mar 22 00:44:01 2009
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 500
timed_statistics = FALSE
resource_limit = FALSE
license_max_sessions = 600
license_sessions_warning = 580
shared_pool_size = 64000000
java_pool_size = 20971520
control_files = D:\GAAC\GAACctl1.ora, D:\GAAC\GAACctl2.ora
db_block_buffers = 175706
db_block_size = 8192
compatible = 8.0.5
log_archive_start = FALSE
log_archive_dest = D:\GAAC\Archive
log_buffer = 2048000
log_checkpoint_interval = 10000
log_checkpoint_timeout = 900
db_files = 102400
db_file_multiblock_read_count= 32
_allow_resetlogs_corruption= TRUE
dml_locks = 500
transactions = 100
transactions_per_rollback_segment= 10
_corrupted_rollback_segments= true
remote_login_passwordfile= SHARED
license_max_users = 500
db_domain = WORLD
global_names = TRUE
instance_name = GAAC
service_names = GAAC.WORLD
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
mts_servers = 1
audit_trail = FALSE
sort_area_size = 655360
db_name = GAAC
open_cursors = 500
background_dump_dest = D:\GAAC\bDump
user_dump_dest = D:\GAAC\uDump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sun Mar 22 00:44:03 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Mar 22 00:44:03 2009
alter database mount exclusive
Sun Mar 22 00:44:10 2009
Successful mount of redo thread 1, with mount id 1768517786.
Sun Mar 22 00:44:10 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sun Mar 22 00:44:10 2009
alter database open
ORA-1113 signalled during: alter database open...
Sun Mar 22 00:45:04 2009
alter database openSun Mar 22 00:45:05 2009
ORA-1113 signalled during: alter database open
...
Sun Mar 22 00:46:52 2009
ALTER DATABASE RECOVER datafile 1
Sun Mar 22 00:46:52 2009
Media Recovery Datafile: 1
Media Recovery Start
Media Recovery Log
Sun Mar 22 00:46:52 2009
Errors in file D:\GAAC\uDump\ORA00736.TRC:
ORA-00322: log 4 of thread 1 is not current copy
ORA-00312: online log 4 thread 1: 'D:\GAAC\GAACLOG4A.LOG'Media Recovery failed with error 322
ORA-283 signalled during: ALTER DATABASE RECOVER datafile 1 ...
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\ibm>set oracld.sid=gaacC:\Documents and Settings\ibm>sqlplus /nologSQL*Plus: Release 8.1.7.0.0 - Production on Sun Mar 22 00:44:33 2009(c) Copyright 2000 Oracle Corporation. All rights reserved.
相关操作如下:
SQL> conn system/sa@gaac as sysdba;
Connected.
SQL> select open_mode from v$database;OPEN_MODE
----------
MOUNTEDSQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\GAAC\GAACSYS1.DBF'
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 4 of thread 1 is not current copy
ORA-00312: online log 4 thread 1: 'D:\GAAC\GAACLOG4A.LOG'---------------------------------------以下是gaacALRT.log全文中尾部部分:
Tue Mar 17 10:06:38 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Mar 17 10:06:39 2009
alter database mount
Tue Mar 17 10:06:46 2009
Successful mount of redo thread 1, with mount id 1768127222.
Tue Mar 17 10:06:46 2009
Database mounted in Exclusive Mode.
Completed: alter database mount
Tue Mar 17 10:06:46 2009
alter database open
ORA-1113 signalled during: alter database open ...
Dump file D:\GAAC\bDump\gaacALRT.LOG
Sun Mar 22 00:44:01 2009
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 500
timed_statistics = FALSE
resource_limit = FALSE
license_max_sessions = 600
license_sessions_warning = 580
shared_pool_size = 64000000
java_pool_size = 20971520
control_files = D:\GAAC\GAACctl1.ora, D:\GAAC\GAACctl2.ora
db_block_buffers = 175706
db_block_size = 8192
compatible = 8.0.5
log_archive_start = FALSE
log_archive_dest = D:\GAAC\Archive
log_buffer = 2048000
log_checkpoint_interval = 10000
log_checkpoint_timeout = 900
db_files = 102400
db_file_multiblock_read_count= 32
_allow_resetlogs_corruption= TRUE
dml_locks = 500
transactions = 100
transactions_per_rollback_segment= 10
_corrupted_rollback_segments= true
remote_login_passwordfile= SHARED
license_max_users = 500
db_domain = WORLD
global_names = TRUE
instance_name = GAAC
service_names = GAAC.WORLD
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
mts_servers = 1
audit_trail = FALSE
sort_area_size = 655360
db_name = GAAC
open_cursors = 500
background_dump_dest = D:\GAAC\bDump
user_dump_dest = D:\GAAC\uDump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Sun Mar 22 00:44:03 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sun Mar 22 00:44:03 2009
alter database mount exclusive
Sun Mar 22 00:44:10 2009
Successful mount of redo thread 1, with mount id 1768517786.
Sun Mar 22 00:44:10 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sun Mar 22 00:44:10 2009
alter database open
ORA-1113 signalled during: alter database open...
Sun Mar 22 00:45:04 2009
alter database openSun Mar 22 00:45:05 2009
ORA-1113 signalled during: alter database open
...
Sun Mar 22 00:46:52 2009
ALTER DATABASE RECOVER datafile 1
Sun Mar 22 00:46:52 2009
Media Recovery Datafile: 1
Media Recovery Start
Media Recovery Log
Sun Mar 22 00:46:52 2009
Errors in file D:\GAAC\uDump\ORA00736.TRC:
ORA-00322: log 4 of thread 1 is not current copy
ORA-00312: online log 4 thread 1: 'D:\GAAC\GAACLOG4A.LOG'Media Recovery failed with error 322
ORA-283 signalled during: ALTER DATABASE RECOVER datafile 1 ...
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\ibm>set oracle.sid=gaac;C:\Documents and Settings\ibm>sqlplus /nolog;SQL*Plus: Release 8.1.7.0.0 - Production on Sun Mar 22 15:36:15 2009(c) Copyright 2000 Oracle Corporation. All rights reserved.SQL> conn system/manager@gaac as sysdba;
Connected.
SQL> select open_mode from v$database;OPEN_MODE
----------
MOUNTEDSQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\GAAC\GAACSYS1.DBF'SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: 'D:\GAAC\GAA6020070518_T'
ORA-01207: file is more recent than controlfile - old controlfile
SQL> alter database datafile 5 offline drop;Database altered.SQL> recover database until cancel;
ORA-00279: change 2371319 generated at 03/13/2009 16:11:05 needed for thread 1
ORA-00289: suggestion : D:\GAAC\ARCHIVE\ARC00584.001
ORA-00280: change 2371319 for thread 1 is in sequence #584
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
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: 'D:\GAAC\GAACSYS1.DBF'
ORA-01112: media recovery not started
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\GAAC\GAACSYS1.DBF'SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
----------------------------------------
到这里,本人就再也想不出其他办法来了,试过重启oracle服务,再试,结果如下:
----------------------------------------
SQL> exit
Disconnected from Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - ProductionC:\Documents and Settings\ibm>set oracle.sid=gaac;C:\Documents and Settings\ibm>sqlplus /nolog;SQL*Plus: Release 8.1.7.0.0 - Production on Sun Mar 22 15:45:06 2009(c) Copyright 2000 Oracle Corporation. All rights reserved.SQL> conn system/manager@gaac as sysdba;
ERROR:
ORA-01092: ORACLE instance terminated. Disconnection forced
在配置文件: initGAAC.ora 的最后一行,加入如下配置:
_allow_resetlogs_corruption=true我这个数据库,到这里,是不是可以说是永远也修复不好了?里面的数据很重要啊...有知道其他解决办法的,请各位高人指点迷津,不胜感激!!!
如果不知道哪个是当前的,就一个个试
现在就试...
初始的全部文件都已作了备份.4 号日志文件是当前的...呵呵...
现在就试...
初始的全部文件都已作了备份.