rman archive log list not in order

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
  • Date: Fri, 29 Jan 2010 07:40:26 -0500

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

Other related posts: