User Tools

Site Tools


operations:db_ncedc:db_log

Oracle Backup Files

  • Obsolete Oracle backup files should be removed periodically on dcucb & publicdb, e.g.:
% rman TARGET / RCVCAT rman/****@ucbrcat
RMAN> REPORT OBSOLETE;
...
RMAN> DELETE FORCE OBSOLETE;
...
RMAN> QUIT;
  • To update the retention policy:
RMAN> SHOW RETENTION POLICY;

RMAN configuration parameters for database with db_unique_name DCMP2 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 45 DAYS;

new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 45 DAYS;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN>
operations/db_ncedc/db_log.txt · Last modified: 2024/04/02 10:14 by stephane