Oracle Database Recovery Check 介绍
根据多年来的数据库恢复经验,提炼出来数据库恢复关键点信息收集脚本(Oracle Database Recovery Check),该脚本主要是在数据库mount状态情况下查询数据库的一些基础表信息等信息,不对数据库进行任何写操作(只做读和dump操作),不会在坏的数据库基础之上带来任何破坏,不影响任何数据库后续的恢复工作。通过该脚本收集信息能够快速定位数据库异常原因,并初步判断数据库恢复疑难程度,减少数据库异常恢复诊断时间,提供恢复效率和准确性。
Oracle Database Recovery Check For Linux/Uinx
Oracle Database Recovery Check For Windows
Oracle Database Recovery Check For ALL
Oracle Database Recovery Check使用说明
1. 根据系统平台下载对应的版本,使用unzip/winrar软件解压成sql文件
2. 上传到服务器之上(演示在linux平台,上传到/tmp中,win平台,上传到E:中)
3. 启动数据库到mount状态
4. 在sqlplus中使用@path/check_recover_db.sql文件
5. 发送db_recover_xifenfei.html到dba@xifenfei.com
6. 联系我:手机(13429648788)或者qq(107644445)
liunx平台使用方法
[oracle@xifenfei ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 7 14:49:41 2013 Copyright (c) 1982, 2011, 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> @/tmp/check_recover_db_linux.sql +--------------------------------------------------------------------------------+ | Oracle Database Recovery Check Result | |--------------------------------------------------------------------------------+ | Copyright (c) 2012-2013 xifenfei. All rights reserved. (www.xifenfei.com) | +--------------------------------------------------------------------------------+ Please start the database to mount state. This script must be run as mount state. To send db_recover_xifenfei.html to dba@xifenfei.com Remember: Do not modify any inspection results -----Oracle Database Recovery Check STRAT----- ----Starting Collect Data Dictionary Information---- ----Starting Collect PATCH Information---- ----Starting Collect ALERT LOG Information---- ----Starting DUMP file_hdrs Information---- ----Starting DUMP controlf Information---- ----Starting DUMP redohdr Information---- -----Oracle Database Recovery Check END----- /home/oracle -rw-r--r-- 1 oracle oinstall 15133020 Jul 7 14:37 db_recover_xifenfei.html Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options 生成的html文件为:/home/oracle/db_recover_xifenfei.html
win平台使用方法
E:>sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 7 14:49:41 2013 Copyright (c) 1982, 2011, 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> @E:SkyDriveORACLEtoolssqlcheck_recover_db_win.sql +----------------------------------------------------------------------------+ | Oracle Database Recovery Check Result | |----------------------------------------------------------------------------+ | Copyright (c) 2012-2013 xifenfei. All rights reserved. (www.xifenfei.com) | +----------------------------------------------------------------------------+ Please start the database to mount state. This script must be run as mount state. To send db_recover_xifenfei.html to dba@xifenfei.com Remember: Do not modify any inspection results *********************Oracle Database Recovery Check STRAT********************* *******Starting Collect Data Dictionary Information******* **********Starting Collect PATCH Information********** *********************Oracle Database Recovery Check END********************* 驱动器 E 中的卷没有标签。 卷的序列号是 000C-3B41 E: 的目录 2013/07/07 14:44 30,676 db_recover_xifenfei.html 1 个文件 30,676 字节 0 个目录 14,159,667,200 可用字节 Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options 生成的html文件为e:db_recover_xifenfei.html
网友评论已有0条评论, 我也要评论