AMDU数据恢复的方法是什么
这篇文章主要介绍“AMDU数据恢复的方法是什么”，在日常操作中，相信很多人在AMDU数据恢复的方法是什么问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”AMDU数据恢复的方法是什么”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！
A.M.D.U数据恢复
客户环境：
操作系统：RedHat Enterprise AS Linux 4.6 x64
数据库DB：Oracle Enterprise Database 10g(10.2.0.4) no psu
集群系统：OracleReal Application Cluster10g(10.2.0.4) no psu
问题背景：
在一个寂静的夜晚被一阵急促的电话铃声吵醒，打来电话的是我的老朋友J，他告知我说数据库起不来了，业务全部中断，存储狂扇，频繁的告警亮灯，寻求我的紧急帮助。我首先安慰老朋友J，说这个可能是存储有问题，比较棘手，还是有修复的可能。J听到我这么一说长舒了一口气，缓缓的吐了几个字说：“吴哥，你得帮帮我！”我说没问题，随即梦醒打了个飞的直奔故障现场。了解到了客户环境：比想象中的更为复杂，上线后就没有任何备份，是一个部署在RHEL4.6环境下的10g(10.2.0.4)的RAC，用的是8盘位DFT低端SAS存储。
问题分析：
在了解到问题环境之后需要对问题进行进一步的分析和解决，思考了半个小时，CRS服务无法启动，没有数据库备份无法恢复；10gRAC ASM无法mount，内部视图无法查询，磁盘组无法正常加载，给数据恢复带来诸多不便......，看来常规方法是不行了，只能考虑一些非常规的数据恢复方法：DUL? AUL? ODU?这几个工具一直在大脑中回荡，后来冷静思考，咨询了行业里面的牛人，告诉我说通过11g下的AMDU可以在磁盘组加载之前将ASM元数据抽出来，用于诊断及起库open，之后再重做RAC恢复数据即可。且该工具可以向后兼容，引入到10g中。
说完就干～！
处理过程：
1.1.基础环境准备
在Oracle官网下载最新的AMDU工具，在任意节点挂载外置移动硬盘，上传到挂载外置移动硬盘的节点上，进去后赋予oracle:oinstall权限并用oracle用户解压，配置参数文件amdu_par，包含如下内容：
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:`pwd`
export PATH=$PATH:`pwd`
1.2.初始化amdu工具
用oracle用户执行如下命令，将自动生成一个以时间命名的目录，其下的报告
文件记录了磁盘组的相关信息。
./amduamdu_2019_03_30_12_26_32
该报告的主要信息如下：
-*-amdu-*-*******************************AMDUSettings********************************ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1Systemname:LinuxNodename:rac1Release:2.6.9-78.ELlargesmpVersion:#1SMPWedJul916:03:59EDT2008Machine:x86_64amdurun:30-MAR-1912:26:32Endianess:1---------------------------------Operations----------------------------------------------------------------DiskSelection--------------------------------diskstring''------------------------------ReadingControl--------------------------------------------------------------OutputControl-------------------------------*********************************DISCOVERY**********************************-----------------------------DISKREPORTN0001------------------------------DiskPath:/dev/raw/raw1UniqueDiskID:DiskLabel:PhysicalSectorSize:512bytesDiskSize:199megabytes**NOTAVALIDASMDISKHEADER.BADVALUEINFIELDblksize_kfdhdb**-----------------------------DISKREPORTN0002------------------------------DiskPath:/dev/raw/raw2UniqueDiskID:DiskLabel:PhysicalSectorSize:512bytesDiskSize:299megabytes**NOTAVALIDASMDISKHEADER.BADVALUEINFIELDblksize_kfdhdb**-----------------------------DISKREPORTN0003------------------------------DiskPath:ORCL:VOL1UniqueDiskID:DiskLabel:VOL1PhysicalSectorSize:512bytesDiskSize:2047997megabytesGroupName:ORADATA_DG1DiskName:VOL1FailureGroupName:VOL1DiskNumber:0HeaderStatus:3DiskCreationTime:2011/01/0415:51:21.126000LastMountTime:2019/03/3013:15:19.625000CompatibilityVersion:0x0a100000DiskSectorSize:512bytesDisksizeinAUs:2047997AUsGroupRedundancy:1MetadataBlockSize:4096bytes---------元数据块大小，4KBAUSize:1048576bytes-------------AU大小：1MBStride:113792AUsGroupCreationTime:2011/01/0415:51:21.013000File1Block1location:AU2---------文件使用，从AU2开始-----------------------------DISKREPORTN0004------------------------------DiskPath:ORCL:VOL2UniqueDiskID:DiskLabel:VOL2PhysicalSectorSize:512bytesDiskSize:2047997megabytesGroupName:ORADATA_DG2DiskName:VOL2FailureGroupName:VOL2DiskNumber:0HeaderStatus:3DiskCreationTime:2011/01/0415:51:43.512000LastMountTime:2019/03/3013:15:19.851000CompatibilityVersion:0x0a100000DiskSectorSize:512bytesDisksizeinAUs:2047997AUsGroupRedundancy:1MetadataBlockSize:4096bytes----------元数据块大小，4KBAUSize:1048576bytes--------------AU大小：1MBStride:113792AUsGroupCreationTime:2011/01/0415:51:43.370000File1Block1location:AU2---------文件使用，从AU2开始-----------------------------DISKREPORTN0005------------------------------DiskPath:ORCL:VOL3UniqueDiskID:DiskLabel:VOL3PhysicalSectorSize:512bytesDiskSize:2047997megabytesGroupName:ORADATA_DG3DiskName:VOL3FailureGroupName:VOL3DiskNumber:0HeaderStatus:3DiskCreationTime:2011/01/0415:52:05.086000LastMountTime:2019/03/3013:15:20.093000CompatibilityVersion:0x0a100000DiskSectorSize:512bytesDisksizeinAUs:2047997AUsGroupRedundancy:1MetadataBlockSize:4096bytes---------元数据块大小，4KBAUSize:1048576bytes--------------AU大小：1MBStride:113792AUsGroupCreationTime:2011/01/0415:52:04.949000File1Block1location:AU2---------文件使用，从AU2开始-----------------------------DISKREPORTN0006------------------------------DiskPath:ORCL:VOL4UniqueDiskID:DiskLabel:VOL4PhysicalSectorSize:512bytesDiskSize:1484867megabytesGroupName:RECOVER_DGDiskName:VOL4FailureGroupName:VOL4DiskNumber:0HeaderStatus:3DiskCreationTime:2011/01/0415:52:31.026000LastMountTime:2019/03/3013:15:20.336000CompatibilityVersion:0x0a100000DiskSectorSize:512bytesDisksizeinAUs:1484867AUsGroupRedundancy:1MetadataBlockSize:4096bytesAUSize:1048576bytes----元数据块大小，4KBStride:113792AUs--------AU大小：1MBGroupCreationTime:2011/01/0415:52:30.929000File1Block1location:AU2---------文件使用，从AU2开始*******************************ENDOFREPORT********************************
1.3.抽取控制文件
由于磁盘组不能Mount，控制文件也无法访问，因此需要首先分析数据库的文件分布情况，进而通过文件的ASM存储序号来进行文件抽取，通过告警日志，可以找到数据库的控制文件信息。如下所示，控制文件的ASM文件号是270。
grepcontrol_file$ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.logcontrol_files="+ORADATA_DG1/ORADB/CONTROLFILE/Current.260.739555035"..........[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.260amdu_2019_03_30_12_29_43/
1.4.通过控制文件获取RedoLog和DataFile
取得控制文件之后，可以通过控制文件内容获得数据库的数据文件及日志文件分布情况。以下是从控制文件中获得的信息输出。
[root@rac1~]#stringsORADATA_DG1_260.f|grep-varchivelog|grep-voracle/|grepORAD|sort+ORADATA_DG1/oradb/idx_jsnet.dbf+ORADATA_DG1/oradb/idx_jsnet.dbf+ORADATA_DG1/oradb/idx_jsnet.ora+ORADATA_DG1/oradb/idx_jsnet.ora+ORADATA_DG1/oradb/redo01.log+ORADATA_DG1/oradb/redo01.log+ORADATA_DG1/oradb/redo02.log+ORADATA_DG1/oradb/redo02.log+ORADATA_DG1/oradb/redo03.log+ORADATA_DG1/oradb/redo03.log+ORADATA_DG1/oradb/redo04.log+ORADATA_DG1/oradb/redo04.log+ORADATA_DG1/oradb/sysaux01.dbf+ORADATA_DG1/oradb/sysaux01.dbf+ORADATA_DG1/oradb/system01.dbf+ORADATA_DG1/oradb/system01.dbf+ORADATA_DG1/oradb/tbs_jsnet.dbf+ORADATA_DG1/oradb/tbs_jsnet.dbf+ORADATA_DG1/oradb/tbs_jsnet.dbf+ORADATA_DG1/oradb/tbs_jsnet.dbf+ORADATA_DG1/oradb/temp01.dbf+ORADATA_DG1/oradb/temp01.dbf+ORADATA_DG1/oradb/undotbs01.dbf+ORADATA_DG1/oradb/undotbs01.dbf+ORADATA_DG1/oradb/undotbs02.dbf+ORADATA_DG1/oradb/undotbs02.dbf+ORADATA_DG1/oradb/users01.dbf+ORADATA_DG1/oradb/users01.dbf
1.5.恢复文件
根据控制文件中的文件分布信息，可以通过amdu工具将所有文件提取出来，根据以数据文件和日志文件信息，创建如下脚本以抽取对应的日志文件和数据文件。
先恢复RedoLog File:
[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.263amdu_2019_03_30_12_32_38/[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.264amdu_2019_03_30_12_33_12/[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.267amdu_2019_03_30_12_34_11/[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.268amdu_2019_03_30_12_34_22/
再恢复数据文件：
IDX_JSNET.ora:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.276amdu_2019_03_30_12_38_42/IDX_JSNET:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.298TBS_JSNET:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.277SYSAUX:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.257SYSTEM:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.256TEMP:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.265UNDOTBS1:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.258UNDOTBS2:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.266USER:[oracle@rac1amdu_2019_03_30_12_26_32]$amdu-diskstring'/dev/oracleasm/disks/VOL*'-extractORADATA_DG1.259
1.6.校验文件
到这里文件已经全部恢复出来了，途中未见报错，接下来需要用dbv对文件进行个校验，检查下是否有逻辑坏块：
[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_12_amdu_2019_03_30_12_29_43/amdu_2019_03_30_12_33_12/amdu_2019_03_30_12_38_42/amdu_2019_03_30_12_43_30/amdu_2019_03_30_12_29_56/amdu_2019_03_30_12_34_11/amdu_2019_03_30_12_40_08/amdu_2019_03_30_12_44_47/amdu_2019_03_30_12_30_07/amdu_2019_03_30_12_34_22/amdu_2019_03_30_12_40_45/amdu_2019_03_30_12_32_38/amdu_2019_03_30_12_37_22/amdu_2019_03_30_12_42_13/[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_12_38_42/ORADATA_DG1_276.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:00:332019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY-Verificationstarting:FILE=amdu_2019_03_30_12_38_42/ORADATA_DG1_276.fDBVERIFY-VerificationcompleteTotalPagesExamined:25600TotalPagesProcessed(Data):0TotalPagesFailing(Data):0TotalPagesProcessed(Index):0TotalPagesFailing(Index):0TotalPagesProcessed(Other):8TotalPagesProcessed(Seg):0TotalPagesFailing(Seg):0TotalPagesEmpty:25592TotalPagesMarkedCorrupt:0TotalPagesInflux:0HighestblockSCN:753000(0.753000)[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_12_40_08/ORADATA_DG1_298.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:00:532019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY-Verificationstarting:FILE=amdu_2019_03_30_12_40_08/ORADATA_DG1_298.fDBVERIFY-VerificationcompleteTotalPagesExamined:32000TotalPagesProcessed(Data):0TotalPagesFailing(Data):0TotalPagesProcessed(Index):28786TotalPagesFailing(Index):0TotalPagesProcessed(Other):1062TotalPagesProcessed(Seg):0TotalPagesFailing(Seg):0TotalPagesEmpty:2152TotalPagesMarkedCorrupt:0TotalPagesInflux:0HighestblockSCN:697113994(0.697113994)[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_12_40_45/ORADATA_DG1_277.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:01:092019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY-Verificationstarting:FILE=amdu_2019_03_30_12_40_45/ORADATA_DG1_277.fDBVERIFY-VerificationcompleteTotalPagesExamined:101120TotalPagesProcessed(Data):95455TotalPagesFailing(Data):0TotalPagesProcessed(Index):353TotalPagesFailing(Index):0TotalPagesProcessed(Other):3290TotalPagesProcessed(Seg):0TotalPagesFailing(Seg):0TotalPagesEmpty:2022TotalPagesMarkedCorrupt:0TotalPagesInflux:0HighestblockSCN:697223552(0.697223552)[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_12_42_13/ORADATA_DG1_257.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:01:172019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY-Verificationstarting:FILE=amdu_2019_03_30_12_42_13/ORADATA_DG1_257.fDBVERIFY-VerificationcompleteTotalPagesExamined:107520TotalPagesProcessed(Data):41691TotalPagesFailing(Data):0TotalPagesProcessed(Index):33473TotalPagesFailing(Index):0TotalPagesProcessed(Other):18814TotalPagesProcessed(Seg):0TotalPagesFailing(Seg):0TotalPagesEmpty:13542TotalPagesMarkedCorrupt:0TotalPagesInflux:0HighestblockSCN:697247738(0.697247738)[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_12_43_30/ORADATA_DG1_256.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:01:592019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY-Verificationstarting:FILE=amdu_2019_03_30_12_43_30/ORADATA_DG1_256.fDBVERIFY-VerificationcompleteTotalPagesExamined:64000TotalPagesProcessed(Data):38706TotalPagesFailing(Data):0TotalPagesProcessed(Index):7385TotalPagesFailing(Index):0TotalPagesProcessed(Other):2067TotalPagesProcessed(Seg):0TotalPagesFailing(Seg):0TotalPagesEmpty:15842TotalPagesMarkedCorrupt:0TotalPagesInflux:0HighestblockSCN:697247727(0.697247727)[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_12_44_47/ORADATA_DG1_265.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:02:252019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY:Skippingtemporaryfileamdu_2019_03_30_12_44_47/ORADATA_DG1_265.f[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_13_10_37/ORADATA_DG1_258.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:03:182019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY-Verificationstarting:FILE=amdu_2019_03_30_13_10_37/ORADATA_DG1_258.fDBVERIFY-VerificationcompleteTotalPagesExamined:23680TotalPagesProcessed(Data):0TotalPagesFailing(Data):0TotalPagesProcessed(Index):0TotalPagesFailing(Index):0TotalPagesProcessed(Other):23432TotalPagesProcessed(Seg):0TotalPagesFailing(Seg):0TotalPagesEmpty:248TotalPagesMarkedCorrupt:0TotalPagesInflux:0HighestblockSCN:667630094(0.667630094)[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_13_14_27/ORADATA_DG1_266.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:03:432019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY-Verificationstarting:FILE=amdu_2019_03_30_13_14_27/ORADATA_DG1_266.fDBVERIFY-VerificationcompleteTotalPagesExamined:27080TotalPagesProcessed(Data):0TotalPagesFailing(Data):0TotalPagesProcessed(Index):0TotalPagesFailing(Index):0TotalPagesProcessed(Other):27080TotalPagesProcessed(Seg):0TotalPagesFailing(Seg):0TotalPagesEmpty:0TotalPagesMarkedCorrupt:0TotalPagesInflux:0HighestblockSCN:697247738(0.697247738)[oracle@rac1amdu_2019_03_30_12_26_32]$dbvfile=amdu_2019_03_30_13_15_29/ORADATA_DG1_259.fDBVERIFY:Release10.2.0.4.0-ProductiononSatMar3014:04:032019Copyright(c)1982,2007,Oracle.Allrightsreserved.DBVERIFY-Verificationstarting:FILE=amdu_2019_03_30_13_15_29/ORADATA_DG1_259.fDBVERIFY-VerificationcompleteTotalPagesExamined:640TotalPagesProcessed(Data):15TotalPagesFailing(Data):0TotalPagesProcessed(Index):2TotalPagesFailing(Index):0TotalPagesProcessed(Other):593TotalPagesProcessed(Seg):0TotalPagesFailing(Seg):0TotalPagesEmpty:30TotalPagesMarkedCorrupt:0TotalPagesInflux:0HighestblockSCN:598900(0.598900)
1.7.验证数据库版本及补丁信息
[oracle@rac1amdu_2019_03_30_12_26_32]$$ORACLE_HOME/OPatch/opatchlsinvInvokingOPatch10.2.0.4.2OracleInterimPatchInstallerversion10.2.0.4.2Copyright(c)2007,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/oracle/product/10.2.0/db_1CentralInventory:/u01/app/oraInventoryfrom:/etc/oraInst.locOPatchversion:10.2.0.4.2OUIversion:10.2.0.4.0OUIlocation:/u01/app/oracle/product/10.2.0/db_1/ouiLogfilelocation:/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch3019-03-30_13-56-47PM.logLsinventoryOutputfilelocation:/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-30_13-56-47PM.txt--------------------------------------------------------------------------------InstalledTop-levelProducts(3):OracleDatabase10g10.2.0.1.0OracleDatabase10gProducts10.2.0.1.0OracleDatabase10gRelease2PatchSet310.2.0.4.0Thereare3productsinstalledinthisOracleHome.TherearenoInterimpatchesinstalledinthisOracleHome.RacsystemcomprisingofmultiplenodesLocalnode=rac1Remotenode=rac2--------------------------------------------------------------------------------OPatchsucceeded.
2、构建新的环境
2.1.安装相同版本数据库
不要建库，只需安装数据库软件即可。
过程(略)
2.2.创建数据库启动参数文件
编辑好参数文件，将数据库启动到nomount状态:
[oracle@rac1dbs]$catinitoradb.oradb_name=oradbdb_files=80db_file_multiblock_read_count=8db_block_buffers=100shared_pool_size=123232153log_checkpoint_interval=10000processes=50parallel_max_servers=5log_buffer=32768max_dump_file_size=10240global_names=TRUEcontrol_files='/oracle/oradata/oradb/control01.ctl'
2.3.将数据库启到nomount状态
[oracle@rac1dbs]$sqlplus/assysdbaSQL*Plus:Release10.2.0.4.0-ProductiononSatApr612:47:262019Copyright(c)1982,2007,Oracle.AllRightsReserved.Connectedtoanidleinstance.SQL>startupnomount;ORACLEinstancestarted.TotalSystemGlobalArea4294967296bytesFixedSize2089472bytesVariableSize4269805056bytesDatabaseBuffers8388608bytesRedoBuffers14684160bytes
2.4. mount数据库
SQL>alterdatabasemount;Databasealtered.SQL>selectinstance_name,statusfromgv$instance;INSTANCE_NAMESTATUS----------------------------oradbMOUNTED
接下来就可以修改控制文件里面对应的数据文件及RedoLog的路径，并open数据库了。
2.5修改路径
修改控制文件中的数据文件和RedoLog对应路径信息。
RedoLog File RENAME FILE:
alterdatabaserenamefile'+ORADATA_DG1/oradb/redo02.log'to'/oracle/oradata/oradb/amdu_2019_03_30_12_33_12/ORADATA_DG1_264.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/redo01.log'to'/oracle/oradata/oradb/amdu_2019_03_30_12_32_38/ORADATA_DG1_263.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/redo03.log'to'/oracle/oradata/oradb/amdu_2019_03_30_12_34_11/ORADATA_DG1_267.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/redo04.log'to'/oracle/oradata/oradb/amdu_2019_03_30_12_34_22/ORADATA_DG1_268.f';terdatabaserenamefile'+ORADATA_DG1/oradb/users01.dbf'to'/oracle/oradata/oradb/amdu_2019_03_30_13_15_29/ORADATA_DG1_259.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/sysaux01.dbf'to'/oracle/oradata/oradb/amdu_2019_03_30_12_42_13/ORADATA_DG1_257.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/undotbs01.dbf'to'/oracle/oradata/oradb/amdu_2019_03_30_13_10_37/ORADATA_DG1_258.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/system01.dbf'to'/oracle/oradata/oradb/amdu_2019_03_30_12_43_30/ORADATA_DG1_256.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/undotbs02.dbf'to'/oracle/oradata/oradb/amdu_2019_03_30_13_14_27/ORADATA_DG1_266.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/tbs_jsnet.dbf'to'/oracle/oradata/oradb/amdu_2019_03_30_12_40_45/ORADATA_DG1_277.f';alterdatabaserenamefile'+ORADATA_DG1/oradb/idx_jsnet.dbf'to'/oracle/oradata/oradb/amdu_2019_03_30_12_40_08/ORADATA_DG1_298.f';
Temp File RENAME FILE:
alterdatabaserenamefile'+ORADATA_DG1/oradb/temp01.dbf'to'/oracle/oradata/oradb/amdu_2019_03_30_12_44_47/ORADATA_DG1_265.f';
3.启动数据库
[oracle@redhat5~]$sqlplus/assysdbaSQL*Plus:Release10.2.0.4.0-ProductiononSunMar3103:50:552019Copyright(c)1982,2007,Oracle.AllRightsReserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.4.0-64bitProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsSQL>alterdatabaseopen;alterdatabaseopen*ERRORatline1:ORA-00369:Currentlogofthread1notuseableandotherlogbeingclearedORA-00312:onlinelog1thread1:'/oracle/oradata/oradb/amdu_2019_03_30_12_32_38/ORADATA_DG1_263.f'SQL>alterdatabaseclearunarchivedlogfilegroup1;Databasealtered.SQL>alterdatabaseopen;Databasealtered.SQL>selectinstance_name,statusfromv$instance;INSTANCE_NAMESTATUS----------------------------oradbOPEN
4.数据库业务方面确认
SQL>selectusername,default_tablespacefromdba_userswhereaccount_status='OPEN';USERNAMEDEFAULT_TABLESPACE------------------------------------------------------------SYSTEMSYSTEMSYSSYSTEMSYSMANSYSAUXDBSNMPSYSAUXMGMT_VIEWSYSTEMwooTBS_JSNET6rowsselected.colOWNERformata8colOBJECT_NAMEformata25selectowner,object_name,statusfromdba_objectswhereowner='MAM42SYS';OWNEROBJECT_NAMESTATUS----------------------------------------WOOWOO_NAVBONTMOLVALIDWOOWOO_NAVTONTCOLVALIDWOOWOO_NAV2GATIWNVALID
到此，关于“AMDU数据恢复的方法是什么”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
