Listing the backups of a database between two specific points in time can be very helpful in determining what changes were made to the database between those two points. The list can also help when trying to restore the database to a previous state.
To create a list of the backups between two points in time, use the SQL command SELECT * FROM msdb.dbo.backupset WHERE backup_start_date = ‘start date’ AND backup_start_date <= 'end date'.
For example, to list the backups between November 1, …
List Backup Of Controlfile Autobackup
Oracle database controlfiles can be automatically backed up by the LIST BACKUP OF CONTROLLFILE command.
This command can be used to create a backup of the controlfile in a user-specified directory.
The controlfile autobackup feature can be used to quickly create a backup of the controlfile in the event of a database failure.
The controlfile autobackup feature can also be used to create a backup of the controlfile before making changes to the controlfile.
