Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!not-for-mail
From: Kenneth Koenraadt
Newsgroups: comp.databases.oracle.server
Subject: Re: Deleting in RMAN
Date: Thu, 05 May 2005 20:03:42 GMT
Message-ID: <427a7b2f.8779390@news.inet.tele.dk>
References: <1115306655.552159.21130@o13g2000cwo.googlegroups.com> <427a5fad.1736687@news.inet.tele.dk> <1115317006.983172.211590@z14g2000cwz.googlegroups.com>
X-Newsreader: Forte Free Agent 1.11/32.235
X-Antivirus: avast! (VPS 0518-3, 04-05-2005), Outbound message
X-Antivirus-Status: Clean
Lines: 32
Organization: TDC Totalloesninger
NNTP-Posting-Host: 80.199.156.222
X-Trace: 1115323422 dread11.news.tele.dk 150 80.199.156.222:55447
X-Complaints-To: abuse@post.tele.dk
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:242111

On 5 May 2005 11:16:47 -0700, amerar@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