1. 内容介绍

     由于服务器掉电、人为误操作等原因造成asm磁盘组无法挂载，数据库无法启动，业务系统面试数据丢失的风险，本文主要测试以下问题，
1、asm磁盘metadata损坏，全库datafile重构恢复。
2、优化多个tempfile与datafile重突
3、优化重构数据块日志显示

2. 环境检查

SQL> set linesize 200 pagesize 200
col name for a60
select name from v$datafile
union
select name from v$tempfile
union
select member from v$logfile;SQL> SQL>   2    3    4    5  

NAME
------------------------------------------------------------
+DATA01/enmo/datafile/hsql.264.1063746219
+DATA01/enmo/datafile/sysaux.260.1063610629
+DATA01/enmo/datafile/system.259.1063610625
+DATA01/enmo/datafile/undotbs1.261.1063610629
+DATA01/enmo/datafile/users.263.1063610631
+DATA01/enmo/onlinelog/group_1.256.1063610625
+DATA01/enmo/onlinelog/group_2.257.1063610625
+DATA01/enmo/onlinelog/group_3.258.1063610625
+DATA01/enmo/tempfile/tempts1.262.1063610631
+DATA01/enmo/tempfile/tempts1.265.1063746423
+DATA01/enmo/tempfile/tempts1.266.1063746423
+DATA01/enmo/tempfile/tempts1.267.1063746423
+DATA01/enmo/tempfile/tempts1.268.1063746423

13 rows selected.

SQL> select count(1) from hsql.drop_1;

  COUNT(1)
----------
    100000

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

环境共包含数据文件5个，在线日志文件3个，临时数据文件5个。

3. 恢复数据文件

[root@snyxdb1 xdul]# ./xdul 

xdul: Data Unload for Oracle version 1.1.1

Copyright(c) 2020 orastar.All rights reserved.

Wechat: xidoublestr
Email: 634025070@qq.com
loading default config.......

load config file 'config.txt' successful
loading default control file ......


ts#	fn	rfn	bsize	blocks	filename                  	kscnbas_484	kcvcptim_496	kcvfhrlc_112	kscnbas_116