两次 backup archivelog like


试试在12.1~19c的RAC连续运行两次 backup archivelog like ‘+%’ not backed up 1 times; 看第二次有没有归档日志

检查归档日志

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 22 04:52:56 2020
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select name from v$archived_log;

NAME
--------------------------------------------------------------------------------
+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_1.271.1051712653
+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_5.272.1051712689
+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_2.273.1051714497
+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_6.274.1051714499
+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_7.275.1051714499
+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_4.280.1051746963
+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_2_seq_5.282.1051749313
+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_1_seq_8.281.1051748533
+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_2_seq_3.279.1051748549

9 rows selected.

第一次备份归档日志

RMAN> backup archivelog like '++DATA/SCUTECH/ARCHIVELOG.%' not backed up 1 times; 

Starting backup at 22-SEP-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=250 instance=scutech1 device type=DISK
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 22-SEP-20

RMAN> backup archivelog like '+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_2_seq_3.279%' not backed up 1 times; 

Starting backup at 22-SEP-20
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=2 sequence=3 RECID=9 STAMP=1051751667
channel ORA_DISK_1: starting piece 1 at 22-SEP-20
channel ORA_DISK_1: finished piece 1 at 22-SEP-20
piece handle=/opt/oracle/app/oracle/product/19c/dbhome_1/dbs/02vb1a8r_1_1 tag=TAG20200922T045658 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:20:56
Finished backup at 22-SEP-20

Starting Control File and SPFILE Autobackup at 22-SEP-20

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 09/22/2020 05:25:41
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

RMAN> 
RMAN> 

检查第一次备份归档日志后的日志

SQL> col name form a70
SQL> select FIRST_TIME,NAME from v$archived_log;


FIRST_TIME		NAME
----------------------- ----------------------------------------------------------------------
Sep 21 2020 14:24:10	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_1.271.1051712653
Sep 21 2020 14:18:20	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_5.272.1051712689
Sep 21 2020 14:27:08	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_2.273.1051714497
Sep 21 2020 14:24:47	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_6.274.1051714499
Sep 21 2020 14:54:54	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_7.275.1051714499
Sep 21 2020 22:54:11	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_4.280.1051746963
Sep 22 2020 00:00:21	+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_2_seq_5.282.1051749313
Sep 21 2020 15:18:15	+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_1_seq_8.281.1051748533
Sep 21 2020 14:54:55	+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_2_seq_3.279.1051748549

9 rows selected.

第2次备份

RMAN>  backup archivelog like '+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_2_seq_3.279%' not backed up 1 times; 

Starting backup at Sep 22 2020 05:30:12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=255 instance=scutech1 device type=DISK
skipping archived log of thread 2 with sequence 3; already backed up
Finished backup at Sep 22 2020 05:30:13

RMAN> quit

检查第2次备份归档日志后的日志

SQL> SQL>  set linesize 200
SQL> select FIRST_TIME,NAME from v$archived_log;


FIRST_TIME		NAME
----------------------- ----------------------------------------------------------------------
Sep 21 2020 14:24:10	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_1.271.1051712653
Sep 21 2020 14:18:20	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_5.272.1051712689
Sep 21 2020 14:27:08	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_2.273.1051714497
Sep 21 2020 14:24:47	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_6.274.1051714499
Sep 21 2020 14:54:54	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_1_seq_7.275.1051714499
Sep 21 2020 22:54:11	+DATA/SCUTECH/ARCHIVELOG/2020_09_21/thread_2_seq_4.280.1051746963
Sep 22 2020 00:00:21	+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_2_seq_5.282.1051749313
Sep 21 2020 15:18:15	+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_1_seq_8.281.1051748533
Sep 21 2020 14:54:55	+DATA/SCUTECH/ARCHIVELOG/2020_09_22/thread_2_seq_3.279.1051748549

9 rows selected.
姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
<p> <b><span style="background-color:#FFE500;">【超实用课程内容】</span></b> </p> <p> <br /> </p> <p> <br /> </p> <p> 本课程内容包含讲解<span>解读Nginx的基础知识,</span><span>解读Nginx的核心知识、带领学员进行</span>高并发环境下的Nginx性能优化实战,让学生能够快速将所学融合到企业应用中。 </p> <p> <br /> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b><br /> </b> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b><span style="background-color:#FFE500;">【课程如何观看?】</span></b> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> PC端:<a href="https://edu.csdn.net/course/detail/26277"><span id="__kindeditor_bookmark_start_21__"></span></a><a href="https://edu.csdn.net/course/detail/27216">https://edu.csdn.net/course/detail/27216</a> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 移动端:CSDN 学院APP(注意不是CSDN APP哦) </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 本课程为录播课,课程永久有效观看时长,大家可以抓紧时间学习后一起讨论哦~ </p> <p style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <br /> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <strong><span style="background-color:#FFE500;">【学员专享增值服务】</span></strong> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b>源码开放</b> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 课件、课程案例代码完全开放给你,你可以根据所学知识,自行修改、优化 </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 下载方式:电脑登录<a href="https://edu.csdn.net/course/detail/26277"></a><a href="https://edu.csdn.net/course/detail/27216">https://edu.csdn.net/course/detail/27216</a>,播放页面右侧点击课件进行资料打包下载 </p> <p> <br /> </p> <p> <br /> </p> <p> <br /> </p>
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页