Oracle数据库在无备份情况下的使用DUL数据恢复

1、假设本场景中 D 公司的DBA由于误操作删除了TS$数据字典基表导致数据库无法启动Oracle Database 11g Enterprise Edition R髫潋啜缅elease 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP, Data Miningand Real Application Testing optionsINSTANCE_NAME----------------ASMMESQL>SQL>SQL> select count(*) from sys.ts$; COUNT(*)---------- 5SQL> delete ts$;5 rows deleted.SQL> commit;Commit complete.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.Database mounted.ORA-01092: ORACLE instance terminated. Disconnection forcedORA-01405: fetched column value is NULLProcess ID: 5270Session ID: 10 Serial number: 3Undo initialization errored: err:1405 serial:0 start:3126020954 end:3126020954 diff:0 (0 seconds)Errors in file /s01/diag/rdbms/asmme/ASMME/trace/ASMME_ora_5270.trc:ORA-01405: fetched column value is NULLErrors in file /s01/diag/rdbms/asmme/ASMME/trace/ASMME_ora_5270.trc:ORA-01405: fetched column value is NULLError 1405 happened during db open, shutting down databaseUSER (ospid: 5270): terminating the instance due to error 1405Instance terminated by USER, pid = 5270ORA-1092 signalled during: ALTER DATABASE OPEN...opiodr aborting process unknown ospid (5270) as a result of ORA-1092

2、此场景中由于数据字典已经损坏，所以想要正常打开数据库是十分困难的。此时则可以使用PRM来抽取数据库中的数据。具体步骤与场景1中的相似，用户仅仅需要输入该数据库的所有数据文件即可启动PRM在Windows下仅仅需要点击prm.bat ， 在unix/linux下为SHELL运行prm.sh出现PRM DUL FOR ORACLE DATABASE后, 点击 工具 =》恢复向导

5、PRM会加载数据字典，之后主界面左侧会出现对象树形图，点击你需要的对象表并选择unload 或者dataBridge即可