TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
什么是 ODU
ODU 全称为 Oracle Database Unloader,是用于 Oracle 数据库紧急恢复的软件,在各种原因
造成的数据库不能打开或数据删除后没有备份时,使用 ODU 抢救数据,最大限度地减少数
据丢失。
现实中总会有很多的意外,数据被意外删除、硬件问题导致数据库损坏、错误地格式化了
ASM 磁盘等等,在没有备份的情况下,ODU 能够通过直接访问 Oracle 数据库数据文件或直
接访问 ASM 磁盘,恢复出所有完好的数据,以避免所有数据丢失造成的损失。
我们假设数据库已经无法打开,我拿到了system得数据文件和业务账户得数据文件,我得业务数据文件为2g。
1.编辑control.txt文件,把数据文件添加上
- #ts #fno #rfno filename block_size
- 0 0 0 D:\scripts\ODU\odu_309_win32\odu\data\SYSTEM01.DBF 8192
- 0 0 0 D:\scripts\ODU\odu_309_win32\odu\data\zhyu.dbf 8192
复制代码 2.进入odu
- D:\scripts\ODU\odu_309_win32\odu>odu.exe
- Oracle Data Unloader:Release 3.0.9
- Copyright (c) 2008,2009 XiongJun. All rights reserved.
- Web: http://www.laoxiong.net
- Email: magic007cn@gmail.com
- 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 |
- load control file 'config.txt' successful
- loading default control file ......
- ts# fn rfn bsize blocks bf offset filename
- ---- ---- ---- ----- -------- -- ------ --------------------------------------------
- 0 1 1 8192 90880 N 0 D:\scripts\ODU\odu_309_win32\odu\data\SYSTEM01.DBF
- 6 5 5 8192 393216 N 0 D:\scripts\ODU\odu_309_win32\odu\data\zhyu.dbf
- load control file 'control.txt' successful
- loading dictionary data......
复制代码 3.卸载数据字典
- ODU> unload dict
- CLUSTER C_USER# file_no: 1 block_no: 208
- TABLE OBJ$ file_no: 1 block_no: 240
- CLUSTER C_OBJ# file_no: 1 block_no: 144
- CLUSTER C_OBJ# file_no: 1 block_no: 144
- found IND
复制代码 4.查看业务账户
- [code]ODU> list user
- USER# USERNAME
- ---------- ------------------------------
- 0 SYS
- 1 PUBLIC
- 2 CONNECT
- 3 RESOURCE
- 4 DBA
- 5 SYSTEM
- 6 SELECT_CATALOG_ROLE
- 7 EXECUTE_CATALOG_ROLE
- 8 DELETE_CATALOG_ROLE
- 9 OUTLN
- 10 EXP_FULL_DATABASE
- 11 IMP_FULL_DATABASE
- 12 LOGSTDBY_ADMINISTRATOR
- 13 DBFS_ROLE
- 14 DIP
- 15 AQ_ADMINISTRATOR_ROLE
- 16 AQ_USER_ROLE
- 17 DATAPUMP_EXP_FULL_DATABASE
- 18 DATAPUMP_IMP_FULL_DATABASE
- 19 ADM_PARALLEL_EXECUTE_TASK
- 20 GATHER_SYSTEM_STATISTICS
- 41 JAVA_DEPLOY
- 21 ORACLE_OCM
- 22 RECOVERY_CATALOG_OWNER
- 23 SCHEDULER_ADMIN
- 24 HS_ADMIN_SELECT_ROLE
- 25 HS_ADMIN_EXECUTE_ROLE
- 26 HS_ADMIN_ROLE
- 27 GLOBAL_AQ_USER_ROLE
- 28 OEM_ADVISOR
- 29 OEM_MONITOR
- 30 DBSNMP
- 31 APPQOSSYS
- 32 WMSYS
- 33 WM_ADMIN_ROLE
- 34 JAVAUSERPRIV
- 35 JAVAIDPRIV
- 36 JAVASYSPRIV
- 37 JAVADEBUGPRIV
- 38 EJBCLIENT
- 39 JMXSERVER
- 40 JAVA_ADMIN
- 2147483638 XS$NULL
- 42 EXFSYS
- 43 CTXSYS
- 44 CTXAPP
- 45 XDB
- 46 ANONYMOUS
- 47 XDBADMIN
- 48 XDB_SET_INVOKER
- 49 AUTHENTICATEDUSER
- 50 XDB_WEBSERVICES
- 51 XDB_WEBSERVICES_WITH_PUBLIC
- 52 XDB_WEBSERVICES_OVER_HTTP
- 61 OLAP_DBA
- 53 ORDSYS
- 54 ORDDATA
- 55 ORDPLUGINS
- 56 SI_INFORMTN_SCHEMA
- 57 MDSYS
- 58 ORDADMIN
- 59 OLAP_XS_ADMIN
- 60 OLAPSYS
- 82 OWBSYS_AUDIT
- 62 CWM_USER
- 63 OLAP_USER
- 64 MDDATA
- 65 SPATIAL_WFS_ADMIN
- 66 SPATIAL_WFS_ADMIN_USR
- 67 WFS_USR_ROLE
- 68 SPATIAL_CSW_ADMIN
- 69 SPATIAL_CSW_ADMIN_USR
- 70 CSW_USR_ROLE
- 71 SYSMAN
- 72 MGMT_USER
- 73 MGMT_VIEW
- 74 FLOWS_FILES
- 75 APEX_PUBLIC_USER
- 76 APEX_ADMINISTRATOR_ROLE
- 77 APEX_030200
- 78 OWBSYS
- 79 OWB$CLIENT
- 80 OWB_DESIGNCENTER_VIEW
- 81 OWB_USER
- 85 _NEXT_USER
- 83 SCOTT
- 84 ZHYU
复制代码
5.卸载用户数据
- ODU> unload user zhyu
- Unloading user ZHYU's tables.
- Unloading table: OBS,object ID: 75582
- Unloading segment,storage(Obj#=75582 DataObj#=75582 TS#=6 File#=5 Block#=130 Cluster=0)
- 19075040 rows unloaded
- Unloading table: SEG,object ID: 75583
- Unloading segment,storage(Obj#=75583 DataObj#=75583 TS#=6 File#=5 Block#=1282 Cluster=0)
- 6133 rows unloaded
复制代码 6.确认生成了数据
- D:\scripts\ODU\odu_309_win32\odu\data>dir
- 驱动器 D 中的卷是 apps
- 卷的序列号是 F663-CD5E
- D:\scripts\ODU\odu_309_win32\odu\data 的目录
- 2020/07/17 06:21 <DIR> .
- 2020/07/17 06:21 <DIR> ..
- 2020/07/17 06:09 744,497,152 SYSTEM01.DBF
- 2020/07/17 06:09 3,221,233,664 ZHYU.DBF
- 2020/07/17 06:19 677 ZHYU_OBS.ctl
- 2020/07/17 06:19 488 ZHYU_OBS.sql
- 2020/07/17 06:21 2,333,999,904 ZHYU_OBS.txt
- 2020/07/17 06:21 849 ZHYU_SEG.ctl
- 2020/07/17 06:21 790 ZHYU_SEG.sql
- 2020/07/17 06:21 838,139 ZHYU_SEG.txt
复制代码
|
|