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/18c下载
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_unix .zip [oracle@xifenfei ~]$ unzip /home/oracle/check_recover_db_unix .zip -rw-r--r-- 1 oracle oinstall 16270 Apr 18  2015 check_recover_db_unix.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> @ /home/oracle/check_recover_db_unix .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 Please start the database to mount 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   Copyright (c) 1982, 2011, Oracle and /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文件为: /home/oracle/xifenfei_db_recover_20150418 .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   Copyright (c) 1982, 2013, Oracle.  All rights reserved.   已连接到空闲例程。   SQL> startup mount ORACLE 例程已经启动。   Total System Global Area  400846848 bytes Fixed Size                  2440024 bytes Variable Size             289408168 bytes Database Buffers          100663296 bytes Redo Buffers                8335360 bytes   SQL> @E:\SkyDrive\ORACLE\tools\db_recover\check_recover_db_win_12c.sql   + ----------------------------------------------------------------------------+ |                   Oracle Database Recovery Check Result                    | | ----------------------------------------------------------------------------+ |  Copyright (c) 2012-2014 xifenfei. All 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 to 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 Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options 断开   生成的html文件为C:\Users\XIFENFEI\xifenfei_db_recover_20140330.html

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