Data recovery manager is a tool to help reduce MTTS (Mean time to recover). The GUI of data recovery manager is available in database control and grid control by selecting Perform Recovery in Availability tab. Data recovery manager has following commands:
- LIST FAILURE
- To list all the failures
- ADVISE FAILURE
- View repair options which typically include both automated and manual options.
- REPAIR FAILURE
- To repair failure automatically. Once the failure is repaired, the repair failure command closes the relevant repaired failure.
- CHANGE FAILURE
- Used to alter the status and priority of failure. You can change the status of the failure to closed when you manually repair it. You can also change the priority to high or to prioritu low. You cannot set the status to open nor can you set the priority to critical by issuing this command.
- To list all failures:
- rman > list failure
- To list details of a particular failure
- rman > list failure
detail
- List a subset of failure
- rman > list failure low ( low is the failure priority; high and critical are the other two failure priority values)
- rman > list failure close
- rman > list failure exclude failure
- To determine repair options for a subset of failure
- rman > advice failure <failure id>
- To see what will be repaired if repair failure command is invoked
- rman > repair failure preview
- After you list failures with list failure command, you should execute advise failure command before invoking repair failure command. Calling repair failure command before advise failure command results in error.
- Repair failure command repairs High and Critical failures in ADR and then closes them if they are fixed
- DRA can be used to detect and analyze data failures in single instance database but not in RAC.
- All failures can be automatically repaired by DRA except network I/O failures, which usually needs human intervention.
No comments:
Post a Comment