ORA-00283,ORA-01114
控制文件全部损坏，采用create database .....NORESETLOGS ARCHIVELOG的方式重建数据文件，
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01113: 文件 1 需要介质恢复
ORA-01110: 数据文件 1: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'
SQL> recover datafile 1;
ORA-00283: 恢复会话因错误而取消
ORA-01114: 将块写入文件 1 时出现 IO 错误 (块 # 1)
ORA-01110: 数据文件 1: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'
ORA-27091: 无法将 I/O 排队
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 5) 拒绝访问。
SQL> recover database;
ORA-00283: 恢复会话因错误而取消
ORA-01201: 文件 1 头部无法正确写入
采用resetlogs ARCHIVELOG 的方式重建控制文件
使用
recovery database using backup controlfile until cancel
也提示
ORA-00283: 恢复会话因错误而取消
ORA-01201: 文件 1 头部无法正确写入
我在自己本机上恢复了出现这个问题的库，
本机的磁盘没问题，DBV检查了数据文件也没有问题，alter日志内容如下：
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 188743680
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 603979776
control_files = F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 398458880
compatible = 10.2.0.1.0
log_archive_dest_1 = location=F:\oracle\product\10.2.0\oradata\arch2
log_archive_dest_2 = location=F:\oracle\product\10.2.0\oradata\arch3
db_file_multiblock_read_count= 16
db_recovery_file_dest =
db_recovery_file_dest_size= 2147483648
undo_management = MANUAL
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = F:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = F:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = F:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = F:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = pszx_db
open_cursors = 300
pga_aggregate_target = 200278016
PMON started with pid=2, OS id=5476
PSP0 started with pid=3, OS id=3904
MMAN started with pid=4, OS id=5956
DBW0 started with pid=5, OS id=1432
LGWR started with pid=6, OS id=1016
CKPT started with pid=7, OS id=5160
SMON started with pid=8, OS id=788
RECO started with pid=9, OS id=3352
CJQ0 started with pid=10, OS id=2568
MMON started with pid=11, OS id=4752
MMNL started with pid=12, OS id=1488
Tue May 07 17:06:58 2013
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Tue May 07 17:06:59 2013
ALTER DATABASE MOUNT
Tue May 07 17:07:03 2013
Setting recovery target incarnation to 1
Tue May 07 17:07:03 2013
Successful mount of redo thread 1, with mount id 1830661939
Tue May 07 17:07:03 2013
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue May 07 17:07:10 2013
alter database open
Tue May 07 17:07:10 2013
ORA-1113 signalled during: alter database open...
Tue May 07 17:07:16 2013
ALTER DATABASE RECOVER datafile 1
Media Recovery Start
Tue May 07 17:07:16 2013
Media Recovery failed with error 1114
ORA-283 signalled during: ALTER DATABASE RECOVER datafile 1 ...
DBV信息
C:\Documents and Settings\Administrator>dbv file=F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM
DBVERIFY: Release 10.2.0.1.0 - Production on 星期二 5月 7 17:09:22 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DBVERIFY - 开始验证: FILE = F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
DBVERIFY - 验证完成
检查的页总数: 61440
处理的页总数 (数据): 36924
失败的页总数 (数据): 0
处理的页总数 (索引): 7101
失败的页总数 (索引): 0
处理的页总数 (其它): 1656
处理的总页数 (段) : 0
失败的总页数 (段) : 0
空的页总数: 15759
标记为损坏的总页数: 0
流入的页总数: 0
最高块 SCN : 30596647 (0.30596647)
帮忙看一下
SQL> select file#,CHECKPOINT_CHANGE# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 30596638
2 30596638
3 30596638
4 30596638
SQL> select CHECKPOINT_CHANGE# from v$database;
CHECKPOINT_CHANGE#
------------------
30596638
SQL> select FILE#,CHECKPOINT_CHANGE# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 30593082
2 30593082
3 30593082
4 30593082
Wed May 08 09:36:08 2013
Errors in file f:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4204.trc:
ORA-01110: 数据文件 3: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'
ORA-01114: 将块写入文件 3 时出现 IO 错误 (块 # 1)
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 5) 拒绝访问。
Wed May 08 09:36:08 2013
Errors in file f:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4204.trc:
ORA-01110: 数据文件 2: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF'
ORA-01114: 将块写入文件 2 时出现 IO 错误 (块 # 1)
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 5) 拒绝访问。
Wed May 08 09:36:08 2013
Errors in file f:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4204.trc:
ORA-01110: 数据文件 1: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'
ORA-01114: 将块写入文件 1 时出现 IO 错误 (块 # 1)
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 5) 拒绝访问。
Wed May 08 09:36:08 2013
Media Recovery failed with error 1201
ORA-283 signalled during: ALTER DATABASE RECOVER database ...
页:
[1]