Helmut, This thread came up a couple of days ago The answers were to use the commands change datafilecopy delete or change backuppiece delete Also have a look at the script $ORACLE_HOME/rdbms/demo/rman1.sh to automate the process from the output of report obsolete HTH John
-----Original Message----- Sent: 07 February 2003 11:39 To: Multiple recipients of list ORACLE-L 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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
