1分快3

快捷搜索:  as  创意文化园  test  陈先生  5.7聚众斗殴  龙袍  2327  云南信托

濮阳市信息港_Oracle数据库反常复原搜查脚本(Oracle Database Recovery Check) 提供7*24专业Oracle数据复原、性能优化、迁移升级、故障诊断等供职@电话/微信:+86 13429648788_南京新闻网-热搜头条

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/19c下载
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. () | +----------------------------------------------------------------------------+ 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: ----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----- (av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)** Please check and upload /home/oracle/xifenfei_db_recover_20150418.html (av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)** 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 2八九408168 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. () | +----------------------------------------------------------------------------+ Please start the database to mount state. Note: Do not modify any inspection results Please refer to the use of the script: 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 可用字节 (av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)** Please check and upload "xifenfei_db_recover_YYYYMMDD.html" in current directory (av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)(av)** 从 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
发表评论
sunbet声明:该文看法仅代表作者自己,与本平台无关。请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评判:
表情:
用户名: 验证码:点击我更换图片

您可能还会对下面的文章感爱好:

pk10投注 pk10手机投注计算 1分快3 1分快3pk10手机投注app pk10帐号注册

免责声明: 本站资料及图片来源互联网文章-|,本网不承担任何由内容信息所引起的争议和法律责任。所有作品版权归原创作者所有,与本站立场无关-|,如用户分享不慎侵犯了您的权益,请联系我们告知,-|我们将做删除处理!