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:
3349
4051
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
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
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-lReceived on Fri Jan 29 2010 - 06:40:26 CST