RMAN question

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Fri, 07 Feb 2003 03:38:41 -0800
Message-ID: <F001.00546DD8.20030207033841@fatcity.com>

Hi!

How do I make RMAN delete all obsolete backups? We are using a recovery catalog.

Example:

RMAN> report obsolete;

RMAN-03022: compiling command: report
Report of obsolete backups and copies

Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           523573 29012003-16:19:33 
Backup Piece         523575 29012003-16:19:33  03ee44q5_1_1
Backup Set           525544 31012003-03:47:24 
Backup Piece         525546 31012003-03:47:24  06ee80te_1_1
Backup Set           525545 31012003-08:04:25 
Backup Piece         525547 31012003-08:04:25  07ee8d2m_1_1
Backup Set           526282 01022003-03:34:14 
Backup Piece         526284 01022003-03:34:14  0aeealdg_1_1
Backup Set           526283 01022003-07:55:02 
Backup Piece         526285 01022003-07:55:02  0beeb0m0_1_1
Backup Set           527884 04022003-03:52:28 
Backup Piece         527886 04022003-03:52:28  0eeeiiig_1_1
Backup Set           527885 04022003-08:12:52 
Backup Piece         527887 04022003-08:12:52  0feeius4_1_1
Backup Set           528851 05022003-03:51:41 
Backup Piece         528853 05022003-03:51:41  0ieel6sk_1_1
Backup Set           528852 05022003-08:13:00 
Backup Piece         528854 05022003-08:13:00  0jeelj6h_1_1
Backup Set           529486 06022003-03:43:12 
Backup Piece         529488 06022003-03:43:12  0meenrds_1_1
Backup Set           529487 06022003-08:00:57 
Backup Piece         529489 06022003-08:00:57  0neeo72i_1_1

Now I want to delete those obsolete backups...

RMAN> delete obsolete;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found "obsolete": expecting one of: "expired, script"
RMAN-01007: at line 1 column 9 file: standard input

What would be the correct syntax?

This is 8.1.7 on solaris.

Thanks,
Helmut

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Daiminger, Helmut
  INET: Helmut.Daiminger_at_KirchGruppe.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Feb 07 2003 - 05:38:41 CST