Home Database Mysql Tutorial Oracle数据恢复顾问(DRA)使用测试

Oracle数据恢复顾问(DRA)使用测试

Jun 07, 2016 pm 04:47 PM

来了解Oracle数据恢复顾问(DRA)在这种情况下是如何帮助我们的吧!数据恢复顾问(Data Recovery Advisor)是一款Oracle数据库工

曾经处理过硬盘上数据损坏或者数据丢失的问题么?结果,尽管你还处在诊断和分析问题发生的阶段,最终用户和经理已经联系你,并且希望知道解决问题的大概时间(ETA)了。你是否希望拥有一个简单,并且更为重要的是,快速的方法来诊断和修复这种类型的故障呢?

继续阅读,来了解Oracle数据恢复顾问(DRA)在这种情况下是如何帮助我们的吧!

数据恢复顾问(Data Recovery Advisor)是一款Oracle数据库工具。该工具会自动诊断数据故障,确定并提出相应修复方案,并执行客户要求的修复。以上修复是基于数据故障是一个硬盘上持久性数据的损坏或者丢失。             
 
数据恢复顾问会在遇到问题时,,自动采集数据故障信息,并且,协助执行对于故障的修复。你可以手动修复一个数据故障,或者要求数据恢复顾问来为你执行修复动作。             
 
DRA可以通过企业管理器(EM)Grid Control和/或者恢复管理器(RMAN)来访问。本文将概述在RMAN中使用的命令。

在RMAN中,有四种DRA的命令:
•List Failure - 列出先前执行过的故障评估结果。可能的话,重新验证现有故障并关闭它们。
•Advise Failure - 提出手动和自动修复方案。
•Repair Failure - 通过运行由ADVISE FAILURE建议的最佳修复方案来自动修复故障。完成之后会重新验证现有故障。
•Change Failure - 使你可以改变故障的状态。

例如:下面的步骤有关于一次事故,当一个数据文件已经从操作系统上删除,数据库报告错误。
 
一个select语句执行失败,并报出如下错误:
 SQL> select * from emp;
  select * from emp
  *
  ERROR at line 1:
  ORA-01116: error in opening database file 4
  ORA-01110: data file 4: '/u01/V112_oradata/users01.dbf'
  ORA-27041: unable to open file
  Linux Error: 2: No such file or directory
  Additional information: 3 

  DRA命令‘list failure’提供了此次问题的详细信息:
  Recovery Manager: Release 11.2.0.3.0 - Production on Wed Aug 21 10:12:36 2013
  Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

  connected to target database: V112 (DBID=2335388877)

  RMAN> list failure;

  using target database control file instead of recovery catalog
  List of Database Failures
  =========================
  Failure ID Priority Status    Time      Detected Summary
  ---------- -------- --------- --------- --------------------------------------------
  82        HIGH    OPEN      21-AUG-13 One or more non-system datafiles are missing 

做为DRA的下一步操作,使用命令'advise failure',获得修复该问题的建议方案:

 RMAN> advise failure;

  List of Database Failures
  =========================

  Failure ID Priority Status    Time Detected Summary
  ---------- -------- --------- ------------- -------
  82        HIGH    OPEN      21-AUG-13    One or more non-system datafiles are missing

  analyzing automatic repair options; this may take some time
  allocated channel: ORA_DISK_1
  channel ORA_DISK_1: SID=28 device type=DISK
  analyzing automatic repair options complete

  Mandatory Manual Actions
  ========================
  no manual actions available

  Optional Manual Actions
  =======================
  1. If file /u01/V112_oradata/users01.dbf was unintentionally renamed or moved, restore it
  2. If file /u01/V112_oradata/test01.dbf was unintentionally renamed or moved, restore it

  Automated Repair Options
  ========================
  Option Repair Description
  ------ ------------------
  1 Restore and recover datafile 4; Restore and recover datafile 5
    Strategy: The repair includes complete media recovery with no data loss
    Repair script: /u02/app/oracle/diag/rdbms/v112/V112/hm/reco_1311249797.hm 

DRA信息中描述了,2个数据文件的缺失,并且建议还原和恢复。

如前所述,DRA可以修复故障。执行修复脚本之前,可以预览所建议的命令:
 
 RMAN> repair failure preview;

  Strategy: The repair includes complete media recovery with no data loss
  Repair script: /u02/app/oracle/diag/rdbms/v112/V112/hm/reco_1311249797.hm

  contents of repair script:
    # restore and recover datafile
    sql 'alter database datafile 4, 5 offline';
    restore datafile 4, 5;
    recover datafile 4, 5;
    sql 'alter database datafile 4, 5 online'; 

现在,你可以决定是否手动运行上面的脚本或让DRA来执行修复:

 RMAN> repair failure;

  Strategy: The repair includes complete media recovery with no data loss
  Repair script: /u02/app/oracle/diag/rdbms/v112/V112/hm/reco_1311249797.hm

  contents of repair script:
    # restore and recover datafile
    sql 'alter database datafile 4, 5 offline';
    restore datafile 4, 5;
    recover datafile 4, 5;
    sql 'alter database datafile 4, 5 online';

  Do you really want to execute the above repair (enter YES or NO)? yes
  executing repair script

  sql statement: alter database datafile 4, 5 offline

  Starting restore at 21-AUG-13
  using channel ORA_DISK_1

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Reduce the use of MySQL memory in Docker Reduce the use of MySQL memory in Docker Mar 04, 2025 pm 03:52 PM

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

How do you alter a table in MySQL using the ALTER TABLE statement? How do you alter a table in MySQL using the ALTER TABLE statement? Mar 19, 2025 pm 03:51 PM

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

How to solve the problem of mysql cannot open shared library How to solve the problem of mysql cannot open shared library Mar 04, 2025 pm 04:01 PM

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

Run MySQl in Linux (with/without podman container with phpmyadmin) Run MySQl in Linux (with/without podman container with phpmyadmin) Mar 04, 2025 pm 03:54 PM

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

What is SQLite? Comprehensive overview What is SQLite? Comprehensive overview Mar 04, 2025 pm 03:55 PM

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

Running multiple MySQL versions on MacOS: A step-by-step guide Running multiple MySQL versions on MacOS: A step-by-step guide Mar 04, 2025 pm 03:49 PM

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

How do I configure SSL/TLS encryption for MySQL connections? How do I configure SSL/TLS encryption for MySQL connections? Mar 18, 2025 pm 12:01 PM

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)? What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)? Mar 21, 2025 pm 06:28 PM

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

See all articles