Hi experts,
I need your help to understant the retention redundancy applied for archivelog.
I Know that when we have for instance a redundancy 1 we keep one backup of the database, but what about the archivelog?
I have done a test for the archivelog, and i notice that I still have two copy for the same archivelog sequence after doing a "delete obsolete":
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1645465 1.00M SBT_TAPE 00:00:00 04-OCT-19
BP Key: 1645478 Status: AVAILABLE Compressed: YES Tag: TAG20191004T062616
Handle: 3tudess9_1_1 Media:
List of Archived Logs in backup set 1645465
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 14 2487545212 04-OCT-19 2487545577 04-OCT-19
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1645567 1.00M SBT_TAPE 00:00:01 04-OCT-19
BP Key: 1645575 Status: AVAILABLE Compressed: YES Tag: TAG20191004T063601
Handle: 3vudeteh_1_1 Media:
List of Archived Logs in backup set 1645567
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 14 2487545212 04-OCT-19 2487545577 04-OCT-19