hm
RMAN>
Clicking the Advise And Recover button in Figure 12-19 gives you the same advice, as you
might expect; Figure 12-20 shows the RMAN script that OEM will execute to recover from the
media failure.
FIGURE 12-19 OEM Recovery Advisor recommended actions
Chapter 12: Using Recovery Manager (RMAN) 469
In any case, you perform a straightforward tablespace recovery in RMAN using the
recommendations in /u01/app/oracle/diag/rdbms/dw/dw/hm/reco_3725543542.hm, which
not uncoincidentally are the same recommendations you see in Figure 12-20:
RMAN> sql 'alter database datafile 9 offline';
sql statement: alter database datafile 9 offline
RMAN> restore datafile 9;
Starting restore at 05-SEP-07
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 00009 to /u02/oradata/xport_dw.dbf
channel ORA_DISK_1: reading from backup piece
+RECOV/dw/backupset/2007_09_05/nnndf0_tag20070905t230653_0.304.632531225
channel ORA_DISK_1: piece
handle=+RECOV/dw/backupset/2007_09_05/
nnndf0_tag20070905t230653_0.304.632531225 tag=TAG20070905T230653
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 05-SEP-07
FIGURE 12-20 OEM Recovery Advisor RMAN command summary
470 Oracle Database 11g DBA Handbook
RMAN> recover datafile 9;
Starting recover at 05-SEP-07
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:02
Finished recover at 05-SEP-07
RMAN> sql 'alter database datafile 9 online';
sql statement: alter database datafile 9 online
RMAN>
Miscellaneous Operations
In the next few sections, we??™ll cover some of the other capabilities of RMAN, beyond the backup,
restore, and recovery operations.
Pages:
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714