FAQ
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).

Search Discussions

  • John.Hallas_at_vodafone.co.uk at Feb 7, 2003 at 1:19 pm
    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:
    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).
  • Daiminger, Helmut at Feb 7, 2003 at 1:24 pm
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedFeb 7, '03 at 11:38a
activeFeb 7, '03 at 1:24p
posts3
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase