RMAN指定备份集恢复

 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