Oracle Rman 中backuppiece 的uncatalog 和 backupset 的delete

本文是原创文章,转载请注明出处:http://write.blog.csdn.net/postedit/42424083

 

本文基于Oracle 10.2.0.4版本进行如下的测试:

 

RMAN> list backup of archivelog all;

中间略去很多,只保留下面的这个:

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1410    326.36M    DISK        00:00:41     05-JAN-15
        BP Key: 1409   Status: AVAILABLE  Compressed: NO  Tag: TAG20150105T102705   -------------------->BP Key: 1409 

        Piece Name: F:\LOG_FIPRUSNS_1_1

  List of Archived Logs in backup set 1410
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1191    23261014   25-DEC-14 23279746   26-DEC-14
  1    1192    23279746   26-DEC-14 23293125   03-JAN-15
  1    1193    23293125   03-JAN-15 23296401   03-JAN-15
  1    1194    23296401   03-JAN-15 23300534   03-JAN-15
  1    1195    23300534   03-JAN-15 23304302   03-JAN-15
  1    1196    23304302   03-JAN-15 23308204   03-JAN-15
  1    1197    23308204   03-JAN-15 23316571   03-JAN-15
  1    1198    23316571   03-JAN-15 23316578   03-JAN-15
  1    1199    23316578   03-JAN-15 23343180   04-JAN-15
  1    1200    23343180   04-JAN-15 23367540   05-JAN-15
  1    1201    23367540   05-JAN-15 23368004   05-JAN-15
  1    1202    23368004   05-JAN-15 23368006   05-JAN-15
  1    1203    23368006   05-JAN-15 23368009   05-JAN-15
  1    1204    23368009   05-JAN-15 23368011   05-JAN-15
  1    1205    23368011   05-JAN-15 23369315   05-JAN-15

RMAN> change  backuppiece 1409 uncatalog; -->uncatalog 的含义是删除在控制文件中的记录,对os上的备份文件不会动!(不会删除os上的备份文件)

uncataloged backuppiece
backup piece handle=F:\LOG_FIPRUSNS_1_1 recid=1409 stamp=868184831
Uncataloged 1 objects

RMAN> list backup of archivelog all;

 

让该备份文件回来的方法:

RMAN> catalog backuppiece 'F:\LOG_FIPRUSNS_1_1';

cataloged backuppiece
backup piece handle=F:\LOG_FIPRUSNS_1_1 recid=1413 stamp=868188578    ----->该命令可以多次执行,每次执行recid 加1

RMAN> catalog backuppiece 'F:\LOG_FIPRUSNS_1_1';

cataloged backuppiece
backup piece handle=F:\LOG_FIPRUSNS_1_1 recid=1414 stamp=868188598    ----->该命令可以多次执行,每次执行recid 加1

 

下面看catalog回来后BSkey 和BP Key 的变化:

RMAN> list backup of archivelog all;

中间略去很多,只保留下面的这个:

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1410    326.36M    DISK        00:00:41     05-JAN-15     -------------------->BS Key: 1410 ,BS Key编号没变
        BP Key: 1414   Status: AVAILABLE  Compressed: NO  Tag: TAG20150105T102705------->BP Key: 1414 ,BP Key编号变了,加1

        Piece Name: F:\LOG_FIPRUSNS_1_1

  List of Archived Logs in backup set 1410
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1191    23261014   25-DEC-14 23279746   26-DEC-14
  1    1192    23279746   26-DEC-14 23293125   03-JAN-15
  1    1193    23293125   03-JAN-15 23296401   03-JAN-15
  1    1194    23296401   03-JAN-15 23300534   03-JAN-15
  1    1195    23300534   03-JAN-15 23304302   03-JAN-15
  1    1196    23304302   03-JAN-15 23308204   03-JAN-15
  1    1197    23308204   03-JAN-15 23316571   03-JAN-15
  1    1198    23316571   03-JAN-15 23316578   03-JAN-15
  1    1199    23316578   03-JAN-15 23343180   04-JAN-15
  1    1200    23343180   04-JAN-15 23367540   05-JAN-15
  1    1201    23367540   05-JAN-15 23368004   05-JAN-15
  1    1202    23368004   05-JAN-15 23368006   05-JAN-15
  1    1203    23368006   05-JAN-15 23368009   05-JAN-15
  1    1204    23368009   05-JAN-15 23368011   05-JAN-15
  1    1205    23368011   05-JAN-15 23369315   05-JAN-15

 

下面测试backupset 从catalog中撤销:

RMAN> change  backupset 1410 uncatalog; ---------------------->backupset 不能用change uncatalog!!!

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of uncatalog command at 01/05/2015 14:14:31
RMAN-06122: CHANGE .. UNCATALOG not supported for BACKUPSET


RMAN> change  backupset 1410 delete; -->change backupset delete 的效果包括2个层面:删除在控制文件中的记录,删除os上的备份文件!

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1414    1410    1   1   AVAILABLE   DISK        F:\LOG_FIPRUSNS_1_1

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=F:\LOG_FIPRUSNS_1_1 recid=1414 stamp=868188598
Deleted 1 objects


RMAN>


----此时,os上的F:\LOG_FIPRUSNS_1_1这个文件已经被删除了。


若是在change backupset delete 之前,手工拷贝了该backuppiece,然后change backupset delete ,之后,想注册回来的方法是:

 

RMAN>  catalog backupset 'G:\LOG_FIPRUSNS_1_1';  -------------->没有catalog backupset这个命令。

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "backupset": expecting one of: "archivelog, back
up, backuppiece, controlfilecopy, clone, datafilecopy, device, db_recovery_file_
dest, recovery, start"
RMAN-01007: at line 1 column 9 file: standard input

RMAN>  catalog backuppiece 'G:\LOG_FIPRUSNS_1_1'; ---> 跟上面一样的 catalog backuppiece 命令,只是换成了G盘下的。G盘下的该文件是事先手工拷贝出来的。

cataloged backuppiece
backup piece handle=G:\LOG_FIPRUSNS_1_1 recid=1415 stamp=868200682


下面查看BS Key 和BP Key

RMAN> list backup of archivelog all;


中间略去很多,只保留下面的这个:


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1410    326.36M    DISK        00:00:41     05-JAN-15            ----------------->BS Key: 1410 ,BS Key编号一直没变。
        BP Key: 1415   Status: AVAILABLE  Compressed: NO  Tag: TAG20150105T10270--->BP Key: 1415 ,BP Key编号变了,加1了。

        Piece Name: G:\LOG_FIPRUSNS_1_1

  List of Archived Logs in backup set 1410
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    1191    23261014   25-DEC-14 23279746   26-DEC-14
  1    1192    23279746   26-DEC-14 23293125   03-JAN-15
  1    1193    23293125   03-JAN-15 23296401   03-JAN-15
  1    1194    23296401   03-JAN-15 23300534   03-JAN-15
  1    1195    23300534   03-JAN-15 23304302   03-JAN-15
  1    1196    23304302   03-JAN-15 23308204   03-JAN-15
  1    1197    23308204   03-JAN-15 23316571   03-JAN-15
  1    1198    23316571   03-JAN-15 23316578   03-JAN-15
  1    1199    23316578   03-JAN-15 23343180   04-JAN-15
  1    1200    23343180   04-JAN-15 23367540   05-JAN-15
  1    1201    23367540   05-JAN-15 23368004   05-JAN-15
  1    1202    23368004   05-JAN-15 23368006   05-JAN-15
  1    1203    23368006   05-JAN-15 23368009   05-JAN-15
  1    1204    23368009   05-JAN-15 23368011   05-JAN-15
  1    1205    23368011   05-JAN-15 23369315   05-JAN-15

RMAN>

 

总结:

1. change  backuppiece 1409 uncatalog; -->uncatalog 的含义是删除在控制文件中的记录,对os上的备份文件不会动!(不会删除os上的备份文件)
2. backupset 不能用change uncatalog!!backupset只能用下面的change delete!!!
3. change  backupset 1410 delete;      -->change backupset delete 的效果包括2个层面:删除在控制文件中的记录,删除os上的备份文件!
4. BP Key 这个会随着每次“ catalog backuppiece”的成功执行而递增,因此,BP Key不是保留在备份片中的。
5. BS Key 这个不会随着 每次“ catalog backuppiece”的成功执行而变化,因此,BS Key 是保留在备份片中的。



  

 

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。