As I mentioned earlier, Database Recovery Advisor is useful only if we use rman for our backups.
Backup validate check logical database archivelog ALL; # Check for physical corruption of files nitro speed car games to be restored.
SET linesize 120 column check_name format A30 column parameter_name format A15 column type format A15 column default_value format A15 column description format A20 select me check_name, me parameter_name,.type, fault_value, scription from vhm_check_param p, vhm_check c where eck_id AND ternal_check 'N' order BY me; check_name.
Rman retention policy is set to redundancy.Attempting to use the active partition recovery key 10.0.2 feature will result in the following error.The Database Recovery Advisor (DRA) is a new feature introduced in Oracle 11g to help us to diagnose any persistent failure with the database.If no such failures exist it will list LOW priority failures.Datafile unprot coarse JUL 03 12:00:00 Y undotbs1.258.Data recovery Advisor from SQL select * from VIR_failure; select * from VIR_manual_checklist; Newer Post, older Post, home, subscribe to: Post Comments (Atom).Enterprise Manager supports the Data Recovery Advisor and Health Monitor.# Check for physical corruption of files to be backed.For example, a failure associated with a tablespace you know longer use may be listed as a high priority, when in fact it has no effect on the normal running of your system.Mounted extern N N FRA_GRP/.
YES executing repair script Starting restore at 03-JUL-14 using channel ORA_disk_1 channel ORA_disk_1: starting datafile backup set restore channel ORA_disk_1: specifying datafile(s) to restore from backup set channel ORA_disk_1: restoring datafile 00004 to channel ORA_disk_1: reading from backup piece /rman/bkup_0kpbok52_1_1 channel ORA_disk_1: piece handle/rman/bkup_0kpbok52_1_1 tagTAG20140625T210329.
Data recovery Advisor from OEM, the advise home list all the failures from VIR_failure. .
I have taken the users tablespace offline and removed its datafile as below., rman sql alter tablespace users offline; sql statement: alter tablespace users offline starting full resync of recovery catalog full resync complete [email protected] asmcmd, asmcmd lsdg, state Type Rebal Sector Block.Rman repair failure preview; Strategy: The repair includes complete media recovery with no data loss Repair script: contents of repair script: # restore and recover datafile sql 'alter database datafile 4 offline restore datafile 4; recover datafile 4; sql 'alter database datafile 4 online rman.Health Monitor (dbms_HM) In the previous example the failure was detected and logged automatically in reaction to the table creation failure.If file was unintentionally renamed or moved, restore it Automated Repair Options Option Repair Description Restore and recover datafile 4 Strategy: The repair includes complete media recovery with no data loss Repair script: From the above details, we can clearly see that the advise failure.Using the preview option lists the contents of the repair script without applying.