Re: Deleting in RMAN

On 5 May 2005 11:16:47 -0700, amerar_at_iwc.net wrote:

>Hi Ken,
>
>Delete then individually? How do I identify them? They all have the
>same name....
>
>RMAN> report obsolete orphan;
>
>RMAN-03022: compiling command: report
>Report of obsolete backups and copies
>Type Key Completion Time Filename/Handle
>-------------------- ------ ------------------ --------------------
>Datafile Copy 14316 02-MAY-05
>/u02/backup/mpcpilot/rman_backup/backup_mpcpilot_ctlfile
>Datafile Copy 14351 02-MAY-05
>/u02/backup/mpcpilot/rman_backup/backup_mpcpilot_ctlfile
>Datafile Copy 15064 03-MAY-05
>/u02/backup/mpcpilot/rman_backup/backup_mpcpilot_ctlfile
>Datafile Copy 15101 03-MAY-05
>/u02/backup/mpcpilot/rman_backup/backup_mpcpilot_ctlfile
>Datafile Copy 21341 04-MAY-05
>/u02/backup/mpcpilot/rman_backup/backup_mpcpilot_ctlfile
>Datafile Copy 21381 04-MAY-05
>/u02/backup/mpcpilot/rman_backup/backup_mpcpilot_ctlfile
>

You identify them by their primary key as listed :

change datafilecopy 14316,14351,15064,15101,21341,21381 delete;

• Kenneth Koenraadt