Re: rman archive log list not in order
- From: Jared Still <jkstill@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Fri, 29 Jan 2010 08:04:58 -0800
I don't believe so, at least not with the LIST command.
You can logon as the catalog owner and run queries
in SQLplus against the rc_* views.
BTW, if you are going to crosspost, it is usually
helpful to use BCC
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Fri, Jan 29, 2010 at 4:40 AM, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx>wrote:
> 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:
