rman archive log list not in order

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 29 Jan 2010 07:40:26 -0500
Message-Id: <4B6290E9.3406.000B.1_at_gcrta.org>



We recently changed from using 1 disk channel to using 2 channels. Now when I do a "list backup of archivelog all" command, the logs are not listed in sequence. Is there any way to list the logs in sequence:  

  List of Archived Logs in backup set 224483   Thrd Seq Low SCN Low Time Next SCN Next Time

  • ------- ---------- --------- ---------- --------- 1 378 6406989351 28-JAN-10 6407633628 28-JAN-10
BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ---------------
224484  69.98M     DISK        00:00:14     28-JAN-10
        BP Key: 224489   Status: AVAILABLE  Compressed: YES  Tag:
TAG20100128T21
3349

        Piece Name: R:\RMAN_BKUP\BACKUP_TAPROD_96L4KETU_1_1  

  List of Archived Logs in backup set 224484   Thrd Seq Low SCN Low Time Next SCN Next Time

  • ------- ---------- --------- ---------- --------- 1 377 6405812219 27-JAN-10 6406989351 28-JAN-10
BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ ---------------
224524  198.50K    DISK        00:00:02     28-JAN-10
        BP Key: 224536   Status: AVAILABLE  Compressed: YES  Tag:
TAG20100128T21
4051

        Piece Name: R:\RMAN_BKUP\BACKUP_TAPROD_9AL4KFB3_1_1  

  List of Archived Logs in backup set 224524   Thrd Seq Low SCN Low Time Next SCN Next Time

  • ------- ---------- --------- ---------- --------- 1 379 6407633628 28-JAN-10 6407633957 28-JAN-10
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 29 2010 - 06:40:26 CST

Original text of this message