大家好，我是考100分的小小码 ，祝大家学习进步，加薪顺利呀。今天说一说skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂],希望您对编程的造诣更进一步.
问题描述：删除归档的备份，在进行归档的重新备份，提示：skipping archived logs of thread 1 from sequence 29 to 46; already backed up，这个也不算报错，接着之前的ORA-19625
1.进行备份，但是提示我归档已经存在，但是我已经把备份全都物理删除了，rm * /u01/app/oracle/oradata/Backup 已经删除过Backup下所有的备份，包括这些归档，但是提示过下边这些归档已经存在，很奇怪
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219154644911-1759142689.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图")
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://daima100.com/wp-content/themes/justnews/themer/assets/images/lazy.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图1")
然后我的备份路径下只有数据库的备份文件，没有归档备份？全部删掉重来
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219155418571-1378416998.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图2")
2.查看rman备份的归档信息，然而这个路径下是没有任何文件的，在之后find这个bak也是没有找到的
RMAN> list backup of archivelog all;
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219155307461-1278667051.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图4")
3.重启，重启完重新执行以下脚本，这里很有意思，看起来没有问题。
run{
allocate channel ch_1 type disk;
backup database format “/u01/app/oracle/oradata/Backup/database_$t_%u_%c.bak””;
backup archivelog all format “/u01/app/oracle/oradata/Backup/archive_$t_%u_%c.bak”;
}
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219155812511-1996285627.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图6")
4.但是下边这个就不明白了，我就已经删除归档备份了，怎么还有这几个归档已经有备份了，直接被跳过了，而且归档文件是存在的。这里是我重启完数据库，而且shutdown immediate了一次数据库，要注意的是这时会产生归档文件，所以数据库备份的是我shutdown产生的一次归档文件，之前的该跳过还是跳过了
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219161254671-1705721377.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图8")
5.后来才知道这个原因，物理删除归档备份，数据库是知道的，但是控制文件是还有记录的，这个单词一开始不知道什么意思，这次可记住了”过期“！
RMAN> crosscheck backup; 这里查看一下所有的备份，这里的备份是EXPIRED过期的，但是控制文件不知道，下边就要告诉控制文件
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219160526144-1385904729.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图10")
RMAN> delete expired backup; 删除掉过期的备份，选择yes
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219160648704-1454905631.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图12")
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219160705461-1698644102.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图14")
6.在此进行备份，第无数次备份了，这里需要注意的是最好一行一行来，点击回车系统会检测你的语法，备份成功
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219162124282-1676069792.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图16")
7.查看一下备份的文件，这里的归档备份是没有问题的，当时调整了show all命令的参数，设置成了两个备份归档保留数，先记录一下，忽略一下show all里边设置路径%_后边的错误语法，没有改过来，这里回头再研究一下
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219162216914-1709618741.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图18")
![skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]](https://www.yht7.com/upload/image/20191219/1538923-20191219162448466-1265154302.png "skipping archived logs of thread 1 from sequence 29 to 46; already backed up[通俗易懂]插图20")
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
转载请注明出处: https://daima100.com/10417.html
