OS : Solaris 11.1 SPARC
DB : 11.2.0.4
i have the following rman script running everyday and i have noticed that rman takes the backup of the same archive logs multiple times with different backupsets , can somebody shed some lights on this ?
Q : if i keep executing the same script multiple times on the same session it keeps backing up the arcvhivelog with different backup sets , isn't suppose to say that these archive logs are already backed Up ?
backup script :
backup check logical format '/xxxxxxxxxxx/%d_pre_arc_%T_%U' archivelog all;
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
545 2.51M DISK 00:00:00 2015.10.05 09:01:57
BP Key: 545 Status: AVAILABLE Compressed: NO Tag: TAG20151005T090157
Piece Name: /xxxxxxxx/SID_pre_arc_20151005_ggqiucc5_1_1
List of Archived Logs in backup set 545
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 25636 8939328403 2015.10.04 08:24:22 8939328762 2015.10.04 08:34:22
1 25637 8939328762 2015.10.04 08:34:22 8939329142 2015.10.04 08:44:23
1 25638 8939329142 2015.10.04 08:44:23 8939329527 2015.10.04 08:54:24
1 25786 8939393742 2015.10.05 08:55:26 8939394166 2015.10.05 09:01:55
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
547 2.54M DISK 00:00:00 2015.10.05 09:03:58
BP Key: 547 Status: AVAILABLE Compressed: NO Tag: TAG20151005T090357
Piece Name: /xxxxxxxx/SID_pre_arc_20151005_giqiucfu_1_1
List of Archived Logs in backup set 547
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 25636 8939328403 2015.10.04 08:24:22 8939328762 2015.10.04 08:34:22
1 25637 8939328762 2015.10.04 08:34:22 8939329142 2015.10.04 08:44:23
1 25638 8939329142 2015.10.04 08:44:23 8939329527 2015.10.04 08:54:24
1 25786 8939393742 2015.10.05 08:55:26 8939394166 2015.10.05 09:01:55
1 25787 8939394166 2015.10.05 09:01:55 8939394260 2015.10.05 09:03:56
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
549 2.58M DISK 00:00:01 2015.10.05 09:05:49
BP Key: 549 Status: AVAILABLE Compressed: NO Tag: TAG20151005T090548
Piece Name: /xxxxxxx/SID_pre_arc_20151005_gkqiucjc_1_1
List of Archived Logs in backup set 549
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 25636 8939328403 2015.10.04 08:24:22 8939328762 2015.10.04 08:34:22
1 25637 8939328762 2015.10.04 08:34:22 8939329142 2015.10.04 08:44:23
1 25638 8939329142 2015.10.04 08:44:23 8939329527 2015.10.04 08:54:24
1 25786 8939393742 2015.10.05 08:55:26 8939394166 2015.10.05 09:01:55
1 25787 8939394166 2015.10.05 09:01:55 8939394260 2015.10.05 09:03:56
1 25788 8939394260 2015.10.05 09:03:56 8939394342 2015.10.05 09:05:47
thanks all
/Sam