备份集迁移到其他目录后加入到catalog的过程

下面演示将备份集mv到其他目录后加入catalog的过程.

1.列出当前的备份集信息(当前的备份集位于目录/u01/rman_backup/2011/201111/)

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
------- ---- -- ---------- ----------- ------------ ---------------

4 Full 351.26M DISK 00:00:51 30-NOV-11
        BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
        Piece Name: /u01/rman_backup/2011/201111/df_768589674_5_1.bak
  List of Datafiles in backup set 4
  File LV Type Ckp SCN Ckp Time Name
  ---- -- ---- ---------- --------- ----

  1 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/system01.dbf
  4 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

5 Full 173.91M DISK 00:00:55 30-NOV-11
        BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
        Piece Name: /u01/rman_backup/2011/201111/df_768589674_6_1.bak
  List of Datafiles in backup set 5
  File LV Type Ckp SCN Ckp Time Name
  ---- -- ---- ---------- --------- ----

  2 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/undotbs01.dbf
  3 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/sysaux01.dbf
  5 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/hxl01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

6 Full 6.77M DISK 00:00:03 30-NOV-11
        BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
        Piece Name: /u01/rman_backup/2011/201111/df_768589733_7_1.bak
  Control File Included: Ckp SCN: 530571 Ckp time: 30-NOV-11

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

7 Full 80.00K DISK 00:00:02 30-NOV-11
        BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
        Piece Name: /u01/rman_backup/2011/201111/df_768589735_8_1.bak
  SPFILE Included: Modification time: 30-NOV-11

2.将备份集mv到目录/u01/rman_backup/2011/201111/mybak

[oracle@hxl 201111]$ ls -1
20111130
df_768589674_5_1.bak
df_768589674_6_1.bak
df_768589733_7_1.bak
df_768589735_8_1.bak
mybak

[oracle@hxl 201111]$mv *.bak ./mybak

3.校验当前的备份集,因为备份集迁移到了其他目录,所以crosscheck后标记为EXPIRED.

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=147 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/rman_backup/2011/201111/df_768589674_5_1.bak recid=4 stamp=768589674
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/rman_backup/2011/201111/df_768589674_6_1.bak recid=5 stamp=768589674
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/rman_backup/2011/201111/df_768589733_7_1.bak recid=6 stamp=768589735
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/rman_backup/2011/201111/df_768589735_8_1.bak recid=7 stamp=768589737
Crosschecked 4 objects

4.删除过期的备份集

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------

4 4 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589674_5_1.bak
5 5 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589674_6_1.bak
6 6 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589733_7_1.bak
7 7 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589735_8_1.bak

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/u01/rman_backup/2011/201111/df_768589674_5_1.bak recid=4 stamp=768589674
deleted backup piece
backup piece handle=/u01/rman_backup/2011/201111/df_768589674_6_1.bak recid=5 stamp=768589674
deleted backup piece
backup piece handle=/u01/rman_backup/2011/201111/df_768589733_7_1.bak recid=6 stamp=768589735
deleted backup piece
backup piece handle=/u01/rman_backup/2011/201111/df_768589735_8_1.bak recid=7 stamp=768589737
Deleted 4 EXPIRED objects

5.查看当前的备份集,因为标记为过期的备份集已经删除,所以当前catalog里没有备份集的记录.

RMAN> list backup;

6.逐个将备份集加入到catalog里

RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak';

cataloged backuppiece
backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak recid=12 stamp=769250367

RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak';

cataloged backuppiece
backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak recid=13 stamp=769250424

RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak';

cataloged backuppiece
backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak recid=14 stamp=769250451

RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak';

cataloged backuppiece
backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak recid=15 stamp=769250478

7.列出迁移到mybak目录后的备份集

RMAN> list backup;

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

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

4 Full 351.26M DISK 00:00:51 30-NOV-11
        BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
        Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
  List of Datafiles in backup set 4
  File LV Type Ckp SCN Ckp Time Name
  ---- -- ---- ---------- --------- ----

  1 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/system01.dbf
  4 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

5 Full 173.91M DISK 00:00:55 30-NOV-11
        BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
        Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak
  List of Datafiles in backup set 5
  File LV Type Ckp SCN Ckp Time Name
  ---- -- ---- ---------- --------- ----

  2 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/undotbs01.dbf
  3 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/sysaux01.dbf
  5 Full 530571 30-NOV-11 /u01/app/oracle/oradata/oracl/hxl01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

6 Full 6.77M DISK 00:00:03 30-NOV-11
        BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
        Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak
  Control File Included: Ckp SCN: 530571 Ckp time: 30-NOV-11

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------

7 Full 80.00K DISK 00:00:02 30-NOV-11
        BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
        Piece Name: /u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak
  SPFILE Included: Modification time: 30-NOV-11

CATALOG常用方法:

1.扫描备份片
CATALOG BACKUPPIECE '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak';

2.扫描归档日志
CATALOG ARCHIVELOG '/u01/rman_backup/archive_bak/archlog_78922.bak';

3.扫描数据文件拷贝,并且将其做为增量备份的level 0
CATALOG DATAFILECOPY '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak' LEVEL 0;

4.扫描控制文件拷贝
CATALOG CONTROLFILECOPY '/u01/app/oracle/oradata/oracl/control01.ctl'

5.扫描整个目录
CATALOG START WITH '/u01/rman_backup/2011/201111/mybak';

6.扫描闪回恢复区
CATALOG RECOVERY AREA NOPROMPT;