dbf' is corrupt
Impact: Some objects in tablespace
XPORT_DW might be unavailable
Similar information is available in OEM; Figure 12-18 shows the OEM page when you click
the Perform Recovery link, as you did earlier in this chapter.
Chapter 12: Using Recovery Manager (RMAN) 467
In your RMAN session, you use the advise failure command to see a possible course of action:
RMAN> advise failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
1022 HIGH OPEN 05-SEP-07 One or more non-system
datafiles are corrupt
Impact: See impact for individual child failures
List of child failures for parent failure ID 1022
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
1025 HIGH OPEN 05-SEP-07 Datafile 9:
'/u02/oradata/xport_dw.dbf' is corrupt
Impact: Some objects in tablespace
XPORT_DW might be unavailable
analyzing automatic repair options; this may take some time
using channel ORA_DISK_1
analyzing automatic repair options complete
FIGURE 12-18 OEM Recovery Advisor interface
468 Oracle Database 11g DBA Handbook
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
no manual actions available
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Restore and recover datafile 9
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/dw/dw/hm/reco_3725543542.
Pages:
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713