Oracle数据库异常恢复检查脚本(Oracle Database Recovery Check)

Oracle Database Recovery Check 介绍
根据多年来的数据库恢复经验,提炼出来数据库恢复关键点信息收集脚本(Oracle Database Recovery Check)，该脚本主要是在数据库mount状态情况下查询数据库的一些基础表信息等信息，不对数据库进行任何写操作(只做读和dump操作)，不会在坏的数据库基础之上带来任何破坏，不影响任何数据库后续的恢复工作。通过该脚本收集信息能够快速定位数据库异常原因，并初步判断数据库恢复疑难程度，减少数据库异常恢复诊断时间，提供恢复效率和准确性。

Oracle Database Recovery Check下载
Oracle Database Recovery Check FOR ORACE 9i/10g/11g下载
Oracle Database Recovery Check For Linux/Uinx
Oracle Database Recovery Check For Windows
Oracle Database Recovery Check For ALL

Oracle Database Recovery Check FOR ORACE 12c下载
Oracle Database Recovery Check For Linux/Uinx
Oracle Database Recovery Check For Windows
Oracle Database Recovery Check For ALL

为了方便部分客户服务器不方便下载html文件,新增加直接生成txt检查脚本(主要针对9i/10g/11g版本)
Oracle Database Recovery Check To Txt Download
Oracle Database Recovery Check To Txt Browse

Oracle Database Recovery Check使用说明
1. 根据系统平台下载对应的版本,相应平台,使用unzip/winrar软件解压成sql 文件
2. 上传到服务器之上(oracle用户需要有读取权限)
3. 启动数据库到mount状态
4. 在sqlplus中使用@path/check_recover_db.sql 文件
5. 发送xifenfei_db_recover_YYYYMMDD.html到dba@xifenfei.com
6. 联系我:手机(13429648788)或者qq(107644445)

操作演示(所有平台,版本操作相同)
unix/liunx平台使用方法(for 12c以前版本,12c版本操作步骤完全相同)

 
        [oracle@xifenfei ~]$  
        ls 
         -l  
        /home/oracle/check_recover_db_linux 
        .sql 
       
        -rw-r--r-- 1 oracle oinstall 16270 Apr 18 2015 check_recover_db_linux.sql 
       
        [oracle@xifenfei ~]$ sqlplus / as sysdba 
       
        sql*Plus: Release 11.2.0.4.0 Production on Sun Mar 30 10:55:58 2014 
       
        Copyright (c) 1982,2013,Oracle. All rights reserved. 
       
        Connected to an idle instance. 
       
        sql> startup  
        mount 
       
        ORACLE instance started. 
       
        Total System Global Area 418484224 bytes 
       
        Fixed Size 1385052 bytes 
       
        Variable Size 331353508 bytes 
       
        Database Buffers 79691776 bytes 
       
        Redo Buffers 6053888 bytes 
       
        Database mounted. 
       
        sql> @ 
        .sql 
       
        +----------------------------------------------------------------------------+ 
       
        | Oracle Database Recovery Check Result | 
       
        |----------------------------------------------------------------------------+ 
       
        | Copyright (c) 2012-2015 xifenfei. All rights reserved. (www.xifenfei.com) | 
       
        +----------------------------------------------------------------------------+ 
       
        Please start the database to  
        mount 
         state. 
       
        Note: Do not modify any inspection results 
       
         state. 
       
        Note: Do not modify any inspection results 
       
        To send xifenfei_db_recover_YYYYMMDD.html to dba@xifenfei.com or QQ(107644445) 
       
        Please refer to the use of the script:http: 
        //www 
        .xifenfei.com 
        /oracle_recovery_check 
       
        ----Starting Collect PATCH Information---- 
       
        ----Starting Collect ALERT LOG Information---- 
       
        ----Starting dbv system datafile Information---- 
       
        DBVERIFY: Release 11.2.0.4.0 - Production on Sat Apr 18 21:19:02 2015 
       
        /or 
         its affiliates. All rights reserved. 
       
        ----Starting DUMP file_hdrs Information---- 
       
        ----Starting DUMP controlf Information---- 
       
        ----Starting DUMP redohdr Information---- 
       
        -----Oracle Database Recovery Check END----- 
       
        ******************************************************************************** 
       
        Please check and upload  
        /home/oracle/xifenfei_db_recover_20150418 
        .html 
       
        ******************************************************************************** 
       
        Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production 
       
        With the Partitioning,OLAP,Data Mining and Real Application Testing options 
       
        生成的html文件为: 
        .html

win平台使用方法(for 12c版本,12c以前版本操作步骤完全相同)

 
        C:\Users\XIFENFEI>dir E:\SkyDrive\ORACLE\tools\db_recover\check_recover_db_win_12c.sql 
       
        驱动器 E 中的卷是 本地磁盘 
       
        卷的序列号是 000C-3B41 
       
        E:\SkyDrive\ORACLE\tools\db_recover 的目录 
       
        2014-03-29 23:43 11,101 check_recover_db_win_12c.sql 
       
        1 个文件 11,101 字节 
       
        0 个目录 19,557,310,464 可用字节 
       
        C:\Users\XIFENFEI>sqlplus /  
        as 
         sysdba 
       
        sql*Plus: Release 12.1.0.1.0 Production  
        on 
         星期日 3月 30 11:01:37 2014 
       
        sql plain" style="font-size:13px; background:none!important; border:0px!important; margin:0px!important; padding:0px!important; vertical-align:baseline!important; font-family:Consolas,Oracle.  
        All 
         rights reserved. 
       
        已连接到空闲例程。 
       
        sql> startup mount 
       
        ORACLE 例程已经启动。 
       
        Total System  
        Global 
         Area 400846848 bytes 
       
        Fixed  
        Size 
         2440024 bytes 
       
        Variable  
         289408168 bytes 
       
        Database 
         Buffers 100663296 bytes 
       
        Redo Buffers 8335360 bytes 
       
        sql> @E:\SkyDrive\ORACLE\tools\db_recover\check_recover_db_win_12c.sql 
       
        + 
        ----------------------------------------------------------------------------+ 
       
        | Oracle  
         Recovery  
        Check 
         Result | 
       
        | 
        ----------------------------------------------------------------------------+ 
       
        | Copyright (c) 2012-2014 xifenfei.  
         rights reserved. (www.xifenfei.com) | 
       
        ----------------------------------------------------------------------------+ 
       
        Please start the  
        database 
         to 
         mount state. 
       
        Note: Do  
        not 
         modify 
         any 
         inspection results 
       
        Please refer  
        to 
         the use  
        of 
         the script:http://www.xifenfei.com/5056.html 
       
        To 
         send xifenfei_db_recover_YYYYMMDD.html  
         dba@xifenfei.com  
        or 
         QQ(107644445) 
       
        驱动器 C 中的卷没有标签。 
       
        卷的序列号是 D053-8FE1 
       
        C:\Users\XIFENFEI 的目录 
       
        2014-03-30 11:02 32,796 xifenfei_db_recover_20140330.html 
       
        1 个文件 32,796 字节 
       
        0 个目录 8,444,190,720 可用字节 
       
        ******************************************************************************** 
       
        Please  
        check 
         and 
         upload  
        "xifenfei_db_recover_YYYYMMDD.html" 
         in 
         current 
         directory 
       
        ******************************************************************************** 
       
        从 Oracle  
         12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 
       
        With 
         the Partitioning,Advanced Analytics  
        and 
         Real 
         Application Testing options 断开 
       
        生成的html文件为C:\Users\XIFENFEI\xifenfei_db_recover_20140330.html

当你的数据库因为异常断电，强制关机，硬盘故障，drop表，truncate表，delete表，dmp文件异常，asm无法正常mount等故障无法解决导致数据丢失，且无法自行解决，请联系我们，提供专业ORACLE数据库恢复技术支持
Phone:13429648788 Q Q:107644445 E-Mail:dba@xifenfei.com

Oracle数据库异常恢复检查脚本(Oracle Database Recovery Check)

猜你在找的Oracle相关文章