情况如下：
由于一个数据文件被删除，在实例启动后报错，通过之前的RMAN备份restore文件后，当在recover时，发现少一个归档，导致该instance无法open.
先把这个有问题的datafile offline后，再open数据库。这个数据文件上的数据不多，顺便也体验一下老熊的ODU ，从datafile unloader一把。下面是一个大概的步骤：
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01113: 文件 12 需要介质恢复
ORA-01110: 数据文件 12: 'D:\APP\ADMINISTRATOR\ORADATA\ZYH\SJDATA.DBF'
SQL> recover datafile 12;
ORA-00279: 更改 3511693562 (在 02/27/2013 10:28:06 生成) 对于线程 1 是必需的
ORA-00289: 建议: C:\APP\USER\FLASH_RECOVERY_AREA\DG1\ARCHIVELOG\2013_02_27\O1_MF_1_494_8LTVTBVT_.ARC
ORA-00280: 更改 3511693562 (用于线程 1) 在序列 #494 中
指定日志: {
auto
ORA-00308: 无法打开归档日志 'C:\APP\USER\FLASH_RECOVERY_AREA\DG1\ARCHIVELOG\2013_02_27\O1_MF_1_494_8LTVTBVT_.ARC'
ORA-27041: 无法打开文件
OSD-04002: ？???？？?
O/S-Error: (OS 2) ？？？????？???？？???
ORA-00308: 无法打开归档日志 'C:\APP\USER\FLASH_RECOVERY_AREA\DG1\ARCHIVELOG\2013_02_27\O1_MF_1_494_8LTVTBVT_.ARC'
ORA-27041: 无法打开文件
OSD-04002: ？???？？?
O/S-Error: (OS 2) ？？？????？???？？???
发现丢失归档494
SQL> select * from v$recover_file;
FILE# ONLINE ONLINE_STATUS ERROR CHANGE# TIME
---------- -------------- -------------- ------------------------------ ---------- --------------
12 ONLINE ONLINE 3511693562 27-2月 -13
先把库拉起来再说：
SQL> alter database datafile 12 offline;
---------- -------------- -------------- ------------------------------ ---------- --------------
12 ONLINE ONLINE 3511693562 27-2月 -13
先把库拉起来再说：
SQL> alter database datafile 12 offline;
数据库已更改。
SQL> alter database open;
数据库已更改。
下面使用ODU
从此处下载ODU http://www.itpub.net/thread-1411682-1-1.html
关于ODU 这里有详细的说明 http://www.oracleodu.com/cn/
从此处下载ODU http://www.itpub.net/thread-1411682-1-1.html
关于ODU 这里有详细的说明 http://www.oracleodu.com/cn/
F:\odu_309_win32\odu>odu
Oracle Data Unloader:Release 3.0.9
Copyright (c) 2008,2009 XiongJun. All rights reserved.
loading default config.......
byte_order little
block_size 8192
data_path data
lob_path lob
charset_name ZHS16GBK
ncharset_name AL16UTF16
output_format text
lob_storage file
clob_byte_order little
trace_level 1
delimiter |
block_size 8192
data_path data
lob_path lob
charset_name ZHS16GBK
ncharset_name AL16UTF16
output_format text
lob_storage file
clob_byte_order little
trace_level 1
delimiter |
load control file 'config.txt' successful
loading default control file ......
ts# fn rfn bsize blocks bf offset filename
---- ---- ---- ----- -------- -- ------ --------------------------------------------
0 1 1 8192 180480 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\SYSTEM01.DBF
0 9 9 8192 131072 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\SYSTEM02.DBF
1 2 2 8192 92296 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\SYSAUX01.DBF
1 10 10 8192 131072 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\SYSAUX02.DBF
2 3 3 8192 298240 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\UNDOTBS01.DBF
4 4 4 8192 23680 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\USERS01.DBF
5 5 5 8192 640000 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\ECCH_DATA01.DBF
5 7 7 8192 640000 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\ECCH_DATA02.DBF
5 11 11 8192 655360 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\ECCH_DATA03.DBF
6 6 6 8192 640000 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\ECCH_IDX01.DBF
6 8 8 8192 640000 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\ECCH_IDX02.DBF
7 12 12 8192 38400 N 0 D:\APP\ADMINISTRATOR\ORADATA\ZYH\SJDATA.DBF
load control file 'control.txt' successful
loading dictionary data......
ODU> help
help ---- get command list
exit ---- exit from odu
spool ---- spool information to file
host ---- enter os terminal
load config ---- load config information from file
open ---- load database filename list from file
osdump ---- dump file format hex
dump ---- dump oracle datafile block
rowid ---- decode rowid components
unload ---- unload data
scan ---- scan extent or segment
list ---- list schema object,partition,datafile
charset ---- get or list supported charset name
rdba ---- decode RDBA to rfile# and block#
exit ---- exit from odu
spool ---- spool information to file
host ---- enter os terminal
load config ---- load config information from file
open ---- load database filename list from file
osdump ---- dump file format hex
dump ---- dump oracle datafile block
rowid ---- decode rowid components
unload ---- unload data
scan ---- scan extent or segment
list ---- list schema object,partition,datafile
charset ---- get or list supported charset name
rdba ---- decode RDBA to rfile# and block#
ODU> list
list user
list
list user
list
