RMAN指定备份集恢复

今天在做数据库恢复的时候遇到一个问题，就是有两个目录下面的备份集，想指定备份集来恢复，回来查了下资料，下面做个简单的实验

今天在做数据库恢复的时候遇到一个问题，就是有两个目录下面的备份集，想指定备份集来恢复，回来查了下资料，，下面做个简单的实验记录：

RMAN> run{
2> allocate channel a1 type disk;
3> allocate channel a2 type disk;
4> backup database format='/home/Oracle/backup/db_arch_%U';
5> release channel a1;
6> release channel a2;
7> }

released channel: ORA_DISK_1
allocated channel: a1
channel a1: sid=144 devtype=DISK

allocated channel: a2
channel a2: sid=148 devtype=DISK

Starting backup at 02-JUL-11
channel a1: starting full datafile backupset
channel a1: specifying datafile(s) in backupset
input datafile fno=00001 name=/home/oracle/app/oracle/oradata/zwh/system01.dbf
input datafile fno=00003 name=/home/oracle/app/oracle/oradata/zwh/sysaux01.dbf
channel a1: starting piece 1 at 02-JUL-11
channel a2: starting full datafile backupset
channel a2: specifying datafile(s) in backupset
input datafile fno=00002 name=/home/oracle/app/oracle/oradata/zwh/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/app/oracle/oradata/zwh/users01.dbf
channel a2: starting piece 1 at 02-JUL-11
channel a2: finished piece 1 at 02-JUL-11
piece handle=/home/oracle/backup/db_arch_6kmgfc5a_1_1 tag=TAG20110702T231137 comment=NONE
channel a2: backup set complete, elapsed time: 00:00:07
channel a2: starting full datafile backupset
channel a2: specifying datafile(s) in backupset
including current control file in backupset
channel a2: starting piece 1 at 02-JUL-11
channel a2: finished piece 1 at 02-JUL-11
piece handle=/home/oracle/backup/db_arch_6lmgfc5i_1_1 tag=TAG20110702T231137 comment=NONE
channel a2: backup set complete, elapsed time: 00:00:07
channel a2: starting full datafile backupset
channel a2: specifying datafile(s) in backupset
including current SPFILE in backupset
channel a2: starting piece 1 at 02-JUL-11
channel a2: finished piece 1 at 02-JUL-11
piece handle=/home/oracle/backup/db_arch_6mmgfc5q_1_1 tag=TAG20110702T231137 comment=NONE
channel a2: backup set complete, elapsed time: 00:00:08
channel a1: finished piece 1 at 02-JUL-11
piece handle=/home/oracle/backup/db_arch_6jmgfc5a_1_1 tag=TAG20110702T231137 comment=NONE
channel a1: backup set complete, elapsed time: 00:00:59
Finished backup at 02-JUL-11

released channel: a1

released channel: a2

在这个时候我在scott用户下删除了2条记录，表空间是users，用于恢复比较用~

RMAN> run{
2> allocate channel a1 type disk;
3> allocate channel a2 type disk;
4> backup database format='/home/oracle/backup2/db2_arch_%U';
5> release channel a1;
6> release channel a2;
7> }

using target database control file instead of recovery catalog
allocated channel: a1
channel a1: sid=141 devtype=DISK

allocated channel: a2
channel a2: sid=143 devtype=DISK

Starting backup at 02-JUL-11
channel a1: starting full datafile backupset
channel a1: specifying datafile(s) in backupset
input datafile fno=00001 name=/home/oracle/app/oracle/oradata/zwh/system01.dbf
input datafile fno=00003 name=/home/oracle/app/oracle/oradata/zwh/sysaux01.dbf
channel a1: starting piece 1 at 02-JUL-11
channel a2: starting full datafile backupset
channel a2: specifying datafile(s) in backupset
input datafile fno=00002 name=/home/oracle/app/oracle/oradata/zwh/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/app/oracle/oradata/zwh/users01.dbf
channel a2: starting piece 1 at 02-JUL-11
channel a2: finished piece 1 at 02-JUL-11
piece handle=/home/oracle/backup2/db2_arch_6omgfciq_1_1 tag=TAG20110702T231850 comment=NONE
channel a2: backup set complete, elapsed time: 00:00:07
channel a2: starting full datafile backupset
channel a2: specifying datafile(s) in backupset
including current control file in backupset
channel a2: starting piece 1 at 02-JUL-11
channel a2: finished piece 1 at 02-JUL-11
piece handle=/home/oracle/backup2/db2_arch_6pmgfcj3_1_1 tag=TAG20110702T231850 comment=NONE
channel a2: backup set complete, elapsed time: 00:00:13
channel a2: starting full datafile backupset
channel a2: specifying datafile(s) in backupset
including current SPFILE in backupset
channel a2: starting piece 1 at 02-JUL-11
channel a2: finished piece 1 at 02-JUL-11
piece handle=/home/oracle/backup2/db2_arch_6qmgfcjj_1_1 tag=TAG20110702T231850 comment=NONE
channel a2: backup set complete, elapsed time: 00:00:04
channel a1: finished piece 1 at 02-JUL-11
piece handle=/home/oracle/backup2/db2_arch_6nmgfciq_1_1 tag=TAG20110702T231850 comment=NONE
channel a1: backup set complete, elapsed time: 00:00:54
Finished backup at 02-JUL-11

released channel: a1

released channel: a2

RMAN> list backup of database;

using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
201 Full 24.06M DISK 00:00:05 02-JUL-11
BP Key: 201 Status: AVAILABLE Compressed: NO Tag: TAG20110702T231137
Piece Name: /home/oracle/backup/db_arch_6kmgfc5a_1_1 --第一次备份集的目录
List of Datafiles in backup set 201
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1645604 02-JUL-11 /home/oracle/app/oracle/oradata/zwh/undotbs01.dbf
4 Full 1645604 02-JUL-11 /home/oracle/app/oracle/oradata/zwh/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
204 Full 568.33M DISK 00:00:52 02-JUL-11
BP Key: 204 Status: AVAILABLE Compressed: NO Tag: TAG20110702T231137
Piece Name: /home/oracle/backup/db_arch_6jmgfc5a_1_1
List of Datafiles in backup set 204
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1645603 02-JUL-11 /home/oracle/app/oracle/oradata/zwh/system01.dbf
3 Full 1645603 02-JUL-11 /home/oracle/app/oracle/oradata/zwh/sysaux01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
205 Full 24.06M DISK 00:00:03 02-JUL-11
BP Key: 205 Status: AVAILABLE Compressed: NO Tag: TAG20110702T231850
Piece Name: /home/oracle/backup2/db2_arch_6omgfciq_1_1 --第二次备份集的目录
List of Datafiles in backup set 205
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1645939 02-JUL-11 /home/oracle/app/oracle/oradata/zwh/undotbs01.dbf
4 Full 1645939 02-JUL-11 /home/oracle/app/oracle/oradata/zwh/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
208 Full 568.33M DISK 00:00:53 02-JUL-11
BP Key: 208 Status: AVAILABLE Compressed: NO Tag: TAG20110702T231850
Piece Name: /home/oracle/backup2/db2_arch_6nmgfciq_1_1
List of Datafiles in backup set 208
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1645938 02-JUL-11 /home/oracle/app/oracle/oradata/zwh/system01.dbf
3 Full 1645938 02-JUL-11 /home/oracle/app/oracle/oradata/zwh/sysaux01.dbf

RMAN> run{
2> set until scn=1645604; --执行不完全恢复
3> restore database from tag='TAG20110702T231137'; --指定备份集的tag值，在list backup of database中可以查到
4> recover database;
5> sql 'alter database open resetlogs';
6> }

Starting restore at 03-JUL-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /home/oracle/app/oracle/oradata/zwh/undotbs01.dbf
restoring datafile 00004 to /home/oracle/app/oracle/oradata/zwh/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db_arch_6kmgfc5a_1_1 --第一次的备份集中读取
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup/db_arch_6kmgfc5a_1_1 tag=TAG20110702T231137
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /home/oracle/app/oracle/oradata/zwh/system01.dbf
restoring datafile 00003 to /home/oracle/app/oracle/oradata/zwh/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db_arch_6jmgfc5a_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/backup/db_arch_6jmgfc5a_1_1 tag=TAG20110702T231137
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
Finished restore at 03-JUL-11

Starting recover at 03-JUL-11
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 96 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/ZWH/archivelog/2011_07_02/o1_mf_1_96_70ygz9cv_.arc
archive log filename=/home/oracle/app/oracle/flash_recovery_area/ZWH/archivelog/2011_07_02/o1_mf_1_96_70ygz9cv_.arc thread=1 sequence=96
media recovery complete, elapsed time: 00:00:04
Finished recover at 03-JUL-11