聚合国内IT技术精华文章,分享IT技术精华,帮助IT从业人士成长

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

2014-02-09 06:15 浏览: 3394418 次 我要评论(0 条) 字号:

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条评论, 我也要评论

发表评论

*

* (保密)

Ctrl+Enter 快捷回复