Shulou(Shulou.com)05/31 Report--

How to understand DRA features, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

DRA automatically collects data failure information when it encounters an error. In addition, it can check for faults in advance. In this mode, it can detect and analyze data failures before the database process discovers corruption and sends error messages.

Advantages of DRA:

? Data Recovery Advisor can potentially detect, analyze, and repair data failures before a database process discovers the corruption and signals an error. Early warnings help limit damage caused by corruption.DRA can detect, analyze and fix database errors

? Manually assessing symptoms of data failures and correlating them into a problem statement can be complex, error-prone, and time-consuming. Data Recovery Advisor automatically diagnoses failures, assesses their impact, and reports these findings to the user.

? Traditionally, users must manually determine repair options along with the repair impact. If multiple failures are present, then users must determine the right sequence of repair execution and try to consolidate repairs. In contrast, Data Recovery Advisor automatically determines the best repair options and runs checks to make sure that these options are feasible in your environment.

? Execution of a data repair can be complex and error-prone. If you choose an automated repair option, then Data Recovery Advisor executes the repair and verifies its success.

The following commands are part of the DRA feature in rman

LIST FAILURE, ADVISE FAILURE, REPAIR FAILURE, and CHANGE FAILURE.

List failure can view operational errors and their impact.

Options for advice failure to view fixes, which generally include automatic and manual

Repair failure can use repaire failure to fix errors after advice failure

Manually modified the user01.dbf file

RMAN > list failure

No failures found that match specification

No errors were found.

Sqlplus connect to database, query table

SQL > select * from scott.emp

Select * from scott.emp

*

ERROR at line 1:

ORA-01116: error in opening database file 4

ORA-01110: data file 4:'/ u01 *

ORA-27041: unable to open file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

List failure again

RMAN > list failure

List of Database Failures

=

Failure ID Priority Status Time Detected Summary

--

42 HIGH OPEN 2017-07-30 19:54:08 One or more non-system datafiles are missing

One or more non-system data files are missing

RMAN > advise failure

List of Database Failures

=

Failure ID Priority Status Time Detected Summary

--

42 HIGH OPEN 2017-07-30 19:54:08 One or more non-system datafiles are missing

Analyzing automatic repair options; this may take some time

Using channel ORA_DISK_1

Analyzing automatic repair options complete

Mandatory Manual Actions

=

1. If file / u01/app/oracle/oradata/test/users01.dbf was unintentionally renamed or moved, restore it

2. If you have an export of tablespace USERS, then drop and re-create the tablespace and import the data.

3. Contact Oracle Support Services if the preceding recommendations cannot be used, or if they do not fix the failures selected for repair

Optional Manual Actions

=

No manual actions available

Automated Repair Options

=

No automatic repair options available

There is no automatic repair option

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.