致各位关注我的大牛们：
首先现和大家说声抱歉，最近因为个人跳槽的事忙的不可开交，可能不能准确的每天都向大家更新我的文章，但是我会抽出时间尽量保证一周三篇的进度（六日除外），希望大家谅解。等我安定下来，我会持续每天更新我工作和生活的学习总结，希望能对大家有所帮助，也谢谢大家的支持。LOVE YOU ，PEACE！！！！
RMAN 注册丢失备份集
RMAN工具有时可能会丢失备份出来的备份集，这个一定要注意。先模拟一下数据库的故障情况
首先数据库做过一次全备，备份过后的数据文件是存在的，并且第一次恢复数据库，没有进行resetlog的操作，只有两个incarnation。
备份文件如下：
incarnation信息如下（先不要在意status，这个状态是我在做实验的时候切换到1上的）：
在做备份恢复实验的时候将oradata的所有文件全部删除，通过恢复控制文件，数据库开启到mount状态下，发现restore database甩出了一个报错。找不到对应的备份文件。
小编很是困惑，为什么找不到相应的备份文件？我明明有对应的备份文件啊，为什么提示没有呢？我们再查一下备份信息。
只有这两个控制文件的目录，我其他的文件呢？这里丢失的原因还不太明确，我猜测是因为在删除完oradata之后的那次kill数据库操作导致rman的catalog库丢失了对应的备份信息。幸好ORACLE有一种策略是能通过手动将对应的信息注册到RMAN catalog库当中。
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: home/oracle/backup/fullORCL20180418831
File Name: home/oracle/backup/fullORCL20180418841
File Name: home/oracle/backup/fullORCL20180418821
File Name: home/oracle/backup/fullORCL20180418811
File Name: /home/oracle/backup/archORCL20180418851
File Name: /home/oracle/backup/ctlORCL20180418801
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 80.00K DISK 00:00:00 10-JUL-17
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20170710T103327
Piece Name: /u01/oracle/fast_recovery_area/ORCL/backupset/2017_07_10/o1_mf_nnsnf_TAG20170710T103327_dp5svrf8_.bkp
SPFILE Included: Modification time: 10-JUL-17
SPFILE db_unique_name: ORCL
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 80.00K DISK 00:00:01 18-APR-18
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20180418T100516
Piece Name: /home/oracle/backup/spfileORCL20180418791
SPFILE Included: Modification time: 18-APR-18
SPFILE db_unique_name: ORCL
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 9.36M DISK 00:00:00 18-APR-18
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20180418T100531
Piece Name: /home/oracle/backup/fullORCL20180418831
Control File Included: Ckp SCN: 4660665 Ckp time: 18-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 80.00K DISK 00:00:00 18-APR-18
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20180418T100531
Piece Name: /home/oracle/backup/fullORCL20180418841
SPFILE Included: Modification time: 18-APR-18
SPFILE db_unique_name: ORCL
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 1.22G DISK 00:00:00 18-APR-18
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20180418T100531
Piece Name: /home/oracle/backup/fullORCL20180418821
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 4660530 18-APR-18 /u01/oracle/oradata/orcl/system01.dbf
2 Full 4660530 18-APR-18 /u01/oracle/oradata/orcl/sysaux01.dbf
5 Full 4660530 18-APR-18 /u01/oracle/oradata/orcl/example01.dbf
8 Full 4660530 18-APR-18 /u01/oracle/oradata/orcl/r.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 729.68M DISK 00:00:00 18-APR-18
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20180418T100531
Piece Name: /home/oracle/backup/fullORCL20180418811
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 4660529 18-APR-18 /u01/oracle/oradata/orcl/undotbs01.dbf
4 Full 4660529 18-APR-18 /u01/oracle/oradata/orcl/users01.dbf
6 Full 4660529 18-APR-18 /u01/oracle/oradata/orcl/weilai_business.dbf
7 Full 4660529 18-APR-18 /u01/oracle/oradata/orcl/test.dbf
9 Full 4660529 18-APR-18 /u01/oracle/oradata/orcl/yingji.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7 1.32G DISK 00:00:00 18-APR-18
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20180418T103925
Piece Name: /home/oracle/backup/archORCL20180418851
List of Archived Logs in backup set 7
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 134 3633477 08-FEB-18 3668689 09-FEB-18
1 135 3668689 09-FEB-18 3689752 09-FEB-18
1 136 3689752 09-FEB-18 3716204 11-FEB-18
1 137 3716204 11-FEB-18 3894391 11-FEB-18
1 138 3894391 11-FEB-18 3921578 12-FEB-18
1 139 3921578 12-FEB-18 3964941 23-FEB-18
1 140 3964941 23-FEB-18 3969166 23-FEB-18
1 141 3969166 23-FEB-18 3981353 23-FEB-18
1 142 3981353 23-FEB-18 4049037 23-FEB-18
1 143 4049037 23-FEB-18 4077702 24-FEB-18
1 144 4077702 24-FEB-18 4093674 24-FEB-18
1 145 4093674 24-FEB-18 4112775 24-FEB-18
1 146 4112775 24-FEB-18 4133930 24-FEB-18
1 147 4133930 24-FEB-18 4157154 25-FEB-18
1 148 4157154 25-FEB-18 4176867 25-FEB-18
1 149 4176867 25-FEB-18 4195210 25-FEB-18
1 150 4195210 25-FEB-18 4213184 26-FEB-18
1 151 4213184 26-FEB-18 4254252 26-FEB-18
1 152 4254252 26-FEB-18 4270189 26-FEB-18
1 153 4270189 26-FEB-18 4304272 27-FEB-18
1 154 4304272 27-FEB-18 4335877 28-FEB-18
1 155 4335877 28-FEB-18 4369838 01-MAR-18
1 156 4369838 01-MAR-18 4393592 01-MAR-18
1 157 4393592 01-MAR-18 4416077 01-MAR-18
1 158 4416077 01-MAR-18 4440414 01-MAR-18
1 159 4440414 01-MAR-18 4450199 02-MAR-18
1 160 4450199 02-MAR-18 4473770 04-MAR-18
1 161 4473770 04-MAR-18 4480085 04-MAR-18
1 162 4480085 04-MAR-18 4497233 04-MAR-18
1 163 4497233 04-MAR-18 4509988 06-MAR-18
1 164 4509988 06-MAR-18 4510655 06-MAR-18
1 165 4510655 06-MAR-18 4538869 06-MAR-18
1 166 4538869 06-MAR-18 4604070 06-MAR-18
1 167 4604070 06-MAR-18 4634889 07-MAR-18
1 168 4634889 07-MAR-18 4657127 18-APR-18
1 169 4657127 18-APR-18 4661000 18-APR-18
1 170 4661000 18-APR-18 4662061 18-APR-18
1 171 4662061 18-APR-18 4664558 18-APR-18
1 172 4664558 18-APR-18 4665152 18-APR-18
1 173 4665152 18-APR-18 4665700 18-APR-18
1 174 4665700 18-APR-18 4666544 18-APR-18
1 175 4666544 18-APR-18 4667125 18-APR-18
1 176 4667125 18-APR-18 4669311 18-APR-18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 9.36M DISK 00:00:00 18-APR-18
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20180418T100519
Piece Name: /home/oracle/backup/ctlORCL20180418801
Control File Included: Ckp SCN: 4660516 Ckp time: 18-APR-18
对应的备份片被注册到数据库当中，之后restore database 成功。
THAT'S ALL
BY CUI PEACE!!!!
本文分享自微信公众号 - 最帅dba工作笔记，如有侵权，请联系 service001@enmotech.com 删除。
