RE: RMAN question

From: <John.Hallas_at_vodafone.co.uk>
Date: Fri, 07 Feb 2003 05:19:05 -0800
Message-ID: <F001.00546EDB.20030207051905@fatcity.com>

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: <John.Hallas_at_vodafone.co.uk
  INET: John.Hallas_at_vodafone.co.uk

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 - 07:19:05 CST