Rman List Backup Lists Backups Beyond Bounds Of Completed Dates (Doc ID 2130174.1)

Last updated on MAY 04, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.
When issuing 'list backup' with completed dates between X and Y, rman lists all backups done since X.

Symptoms

 When we add 'device type' in list backup completed between X and Y , we get all the backup list completed since X instead of Y

Changes

 Eg.

rman>list backup device type disk completed between "to_date('30-03-2016 00:00:00','dd-mm-yyyy hh24:mi:ss')" and "to_date('02-04-2016 00:00:00','dd-mm-yyyy hh24:mi:ss')" ;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms