DG中用物理备库的备份来恢复主库(二)

一、验证备库单个数据文件的备份能否用于主库恢复

2、在主库中将6号数据文件相关备份删除

[oracle@DG1 ~]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Mon Oct 21 06:53:29 2013

connected to target database: ORCL (DBID=1357156209)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1 Full 600.20M DISK 00:01:18 21-OCT-13

BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20131021T062947

Piece Name: /oracle/backup/db_01omuier_1_1.bak

List of Datafiles in backup set 1

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 Full 419827 21-OCT-13 /oracle/oradata/orcl/system01.dbf

2 Full 419827 21-OCT-13 /oracle/oradata/orcl/undotbs01.dbf

3 Full 419827 21-OCT-13 /oracle/oradata/orcl/sysaux01.dbf

4 Full 419827 21-OCT-13 /oracle/oradata/orcl/users01.dbf

5 Full 419827 21-OCT-13 /oracle/oradata/orcl/example01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2 Full 6.80M DISK 00:00:04 21-OCT-13

BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20131021T062947

Piece Name: /oracle/backup/db_02omuihh_1_1.bak

Control File Included: Ckp SCN: 419856 Ckp time: 21-OCT-13

SPFILE Included: Modification time: 21-OCT-13

RMAN> delete backup;

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=145 devtype=DISK

List of Backup Pieces

BP Key BS Key Pc# Cp# Status Device Type Piece Name

------- ------- --- --- ----------- ----------- ----------

1 1 1 1 AVAILABLE DISK /oracle/backup/db_01omuier_1_1.bak

2 2 1 1 AVAILABLE DISK /oracle/backup/db_02omuihh_1_1.bak

Do you really want to delete the above objects (enter YES or NO)? yes

deleted backup piece

backup piece handle=/oracle/backup/db_01omuier_1_1.bak recid=1 stamp=829376987

deleted backup piece

backup piece handle=/oracle/backup/db_02omuihh_1_1.bak recid=2 stamp=829377077

Deleted 2 objects

RMAN> list backup;

RMAN>exit

上一条