-- List backups
list backup;
-- Delete obsolete backups
delete obsolete;
DELETE OBSOLETE RECOVERY WINDOW OF 7 DAYS;
DELETE OBSOLETE REDUNDANCY = 3;
DELETE EXPIRED ARCHIVELOG ALL;
-- Show configuration
show all;
-- Crosscheck
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
-- Catalog backups
-- Cataloging Files in the Flash Recovery Area
CATALOG RECOVERY AREA NOPROMPT;
-- Catalog the backup pieces held in the location set for db_recovery_file_dest parameter:
catalog db_recovery_file_dest;
-- archived logs
CATALOG ARCHIVELOG '?/oradata/archive1_30.dbf', '?/oradata/archive1_31.dbf', '?/oradata/archive1_32.dbf';
-- backup pieces
CATALOG BACKUPPIECE '?/oradata/01dmsbj4_1_1.bcp';
|