两次 backup archivelog like

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

检查归档日志

[oracle@rac1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 22 04:52:56 2020
Version 19.3.0.0.0Copyright (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.0SQL> 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.10517485499 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-20RMAN> 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-20Starting Control File and SPFILE Autobackup at 22-SEP-20RMAN-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 storageRMAN> 
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.10517485499 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:13RMAN> 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.10517485499 rows selected.