Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: amerar@iwc.net
Newsgroups: comp.databases.oracle.server
Subject: Re: Deleting in RMAN
Date: 5 May 2005 08:42:22 -0700
Organization: http://groups.google.com
Lines: 24
Message-ID: <1115307742.174565.173090@o13g2000cwo.googlegroups.com>
References: <1115306655.552159.21130@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 204.27.169.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1115307748 11735 127.0.0.1 (5 May 2005 15:42:28 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 5 May 2005 15:42:28 +0000 (UTC)
In-Reply-To: <1115306655.552159.21130@o13g2000cwo.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=204.27.169.1;
   posting-account=mynT1QsAAAD3HY2Ts4oHrOdjT1e3xIOv
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:242078


As an addendum, I ran a 'report obsolete orphan' command and received
the following output.  I'm trying to see how I can delete 'datafile
copies'.

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_ctlf