PowerProtect Data Manager 19.12 Oracle RMAN User Guide

Dry run of ddutil command reports backup copies to be deleted

When you run the ddutil -r command with the -a DRY_RUN option, the command does not perform any backup copy deletion from the RMAN catalog, but only reports the backup copies to be deleted:

ddutil -r -a SID=<SID> -a DRY_RUN=TRUE [-b <begin_time>] -e <end_time> [-a TAG_NAME=<tag_ID> -a CONNECTION_TYPE={OS|DB|WALLET} -a TNS_SERVICE=<TNS_service>]

Other than the -a DRY_RUN option, the only mandatory options are -a SID=<SID> and -e <end_time>. The other listed options are optional.

For example, the following command reports the backup copies to be deleted from the RMAN catalog for the specified SID, time, tag ID, and database authentication connection:

ddutil -r -a SID=orcl -a DRY_RUN=TRUE -e "Thu Jul 29 16:00:13 IST 2022" -a TAG_NAME=23d20a24 -a CONNECTION_TYPE=DB -a TNS_SERVICE=orcl
 
RMAN instance:
Oracle system ID: orcl
Following backup pieces will be deleted from catalog:
 
./PLCTLP-d2394afd-08d6-4093-bf18-32d17418fa3b/Automated_data_ORCL_1630219917_gn13r70f_1
./PLCTLP-d2394afd-08d6-4093-bf18-32d17418fa3b/Automated_data_ORCL_1630219917_gm13r70f_1
./PLCTLP-d2394afd-08d6-4093-bf18-32d17418fa3b/Automated_data_ORCL_1630219917_go13r70j_1
       :

Delete all backups with a specified asset tag

To delete all the backups from the RMAN catalog with a specified asset tag, run the ddutil -r command with the -a TAG_NAME=<tag_ID> option.

For example:

OS Authentication:
ddutil -r -a SID=orcl -a TAG_NAME=d617af34 -e "Thu Jul 29 16:00:13 IST 2022"
 
Database Authentication:
ddutil -r -a SID=orcl -a TAG_NAME=d617af34 -e "Thu Jul 29 16:00:13 IST 2022" -a CONNECTION_TYPE=DB -a TNS_SERVICE=orcl
 
Wallet Authentication:
ddutil -r -a SID=orcl -a TAG_NAME=d617af34 -e "Thu Jul 29 16:00:13 IST 2022" -a CONNECTION_TYPE=WALLET -a TNS_SERVICE=orcl

Delete all backups for a specified time range

To delete all the backups from the RMAN catalog for a specified time range, run the ddutil -r command with the -b <begin_time> (optional) and -e <end_time> options.

For example:

OS Authentication:
ddutil -r -a SID=orcl -b "Fri Jul 1 16:00:00 IST 2022" -e "Thu Jul 29 16:00:13 IST 2022"
 
Database Authentication:
ddutil -r -a SID=orcl -b "Fri Jul 1 16:00:00 IST 2022" -e "Thu Jul 29 16:00:13 IST 2022" -a CONNECTION_TYPE=DB -a TNS_SERVICE=orcl
 
Wallet Authentication:
ddutil -r -a SID=orcl -b "Fri Jul 1 16:00:00 IST 2022" -e "Thu Jul 29 16:00:13 IST 2022" -a CONNECTION_TYPE=WALLET -a TNS_SERVICE=orcl