FAQ
Call all Rman Gurus, :)

Has anybody worked with "optional" archivelog mount point and RMAN arc
removal process?

When RMAN goes to remove old arclogs... it will choke if it cannot find the
arclogs to delete.

I have here another script removing the "optional" arclogs..which RMAN does
not know about...

My question is: will Rman know not to fail if the archivelog which are
designated as optional are missing...?

Normally it would...error like this if it cannot find the archlog if it was
manditory.

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

RMAN-03002: failure of backup command at 08/22/2005 11:32:51
RMAN-06059: expected archived log not found, lost of archived log
compromises recoverability
ORA-19625: error identifying file
/ltspsig/u04/orabackup_backups/ltspsig.0818.1629/ltspsig56408196810000000245
.arc
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3

Brian Spears

Search Discussions

  • Fuad Arshad at Aug 22, 2005 at 2:12 pm
    we use this to fix this occasional issue
    backup archivelog all skip inaccessible format '%d%U_%t.arc' filesperset 10 dele
    te input;

    "Spears, Brian" wrote:

    Call all Rman Gurus, :)

    Has anybody worked with "optional" archivelog mount point and RMAN arc removal process?

    When RMAN goes to remove old arclogs… it will choke if it cannot find the arclogs to delete.

    I have here another script removing the "optional" arclogs..which RMAN does not know about…

    My question is: will Rman know not to fail if the archivelog which are designated as optional are missing…?

    Normally it would…error like this if it cannot find the archlog if it was manditory.

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

    RMAN-03002: failure of backup command at 08/22/2005 11:32:51
    RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
    ORA-19625: error identifying file /ltspsig/u04/orabackup_backups/ltspsig.0818.1629/ltspsig56408196810000000245.arc
    ORA-27037: unable to obtain file status
    HPUX-ia64 Error: 2: No such file or directory
    Additional information: 3

    Brian Spears
  • Marquez, Chris at Aug 25, 2005 at 10:19 am
    Brian,


    Did you ever figure this out.
    I to am considering and otpion archvie log dest and I'm all to familier
    with what happens when RMAN can ot find log when using only one arch
    dest.


    It wiould be cool if RMAN could try both dest *if* it found a missing
    log on the primary dest.


    Basicly I looking for exepcing with RMAN and a multi dest arch
    config...the behavior.


    Chris Marquez
    Oracle DBA

    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Spears, Brian
    Sent: Monday, August 22, 2005 2:44 PM
    To: oracle-l_at_freelists.org
    Subject: Rman with optional archive logs

    Call all Rman Gurus, :)

    Has anybody worked with "optional" archivelog mount point and RMAN arc
    removal process?

    When RMAN goes to remove old arclogs... it will choke if it cannot find
    the arclogs to delete.

    I have here another script removing the "optional" arclogs..which RMAN
    does not know about...

    My question is: will Rman know not to fail if the archivelog which are
    designated as optional are missing...?

    Normally it would...error like this if it cannot find the archlog if it
    was manditory.

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

    RMAN-03002: failure of backup command at 08/22/2005 11:32:51
    RMAN-06059: expected archived log not found, lost of archived log
    compromises recoverability
    ORA-19625: error identifying file
    /ltspsig/u04/orabackup_backups/ltspsig.0818.1629/ltspsig5640819681000000
    0245.arc
    ORA-27037: unable to obtain file status
    HPUX-ia64 Error: 2: No such file or directory
    Additional information: 3

    Brian Spears

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 22, '05 at 1:46p
activeAug 25, '05 at 10:19a
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase