Re: Deleting in RMAN

From: <amerar_at_iwc.net>
Date: 5 May 2005 11:16:47 -0700
Message-ID: <1115317006.983172.211590@z14g2000cwz.googlegroups.com>

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
Received on Thu May 05 2005 - 13:16:47 CDT