DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Reset incarnation Failed - ORA-19507

  1. #1
    Join Date
    Dec 2000
    Posts
    75
    I am testing restore until time on a database from a hot backup. Once the successful 1st restore, I want to restore from an old backup, so I used reset database incarnation to that number. However I keep getting ORA-19507error as below. Before resetting db, I also did recover database until cancel and alter database open resetlogs. Did I miss anything else.

    begin database restore and recovery

    ${ORACLE_HOME}/bin/$RMAN target / rcvcat rman/rman@rcat cmdfile "$CMDFILE"


    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-06006: connected to target database: TEST (not mounted)
    RMAN-06008: connected to recovery catalog database

    RMAN> run {
    2> # Restore all datafiles, and recovers them completely.
    3> allocate channel t1 type 'SBT_TAPE' ;
    4> allocate channel t2 type 'SBT_TAPE';
    5> restore controlfile to '/u02/oradata/TEST/control01.ctl';
    6> restore controlfile to '/u03/oradata/TEST/control02.ctl';
    7> restore controlfile to '/u04/oradata/TEST/control03.ctl';
    8> sql "alter database mount";
    9> restore database
    10> until time "to_date('Aug 30 2001 12:00:00','Mon DD YYYY HH24:MI:SS')";
    11> recover database
    12> until time "to_date('Aug 30 2001 11:55:00','Mon DD YYYY HH24:MI:SS')";
    13> sql "alter database open resetlogs";
    14> release channel d1;
    15> release channel d2;
    16> release channel d3;
    17> }
    18>
    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: t1
    RMAN-08500: channel t1: sid=10 devtype=SBT_TAPE
    RMAN-08526: channel t1: VERITAS NetBackup for Oracle8 - Release 3.2GA

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: t2
    RMAN-08500: channel t2: sid=11 devtype=SBT_TAPE
    RMAN-08526: channel t2: VERITAS NetBackup for Oracle8 - Release 3.2GA
    RMAN-03022: compiling command: restore

    RMAN-03022: compiling command: IRESTORE
    RMAN-03023: executing command: IRESTORE
    RMAN-08016: channel t1: starting datafile backupset restore
    RMAN-08502: set_count=121 set_stamp=439118532 creation_time=30-AUG-01
    RMAN-08021: channel t1: restoring controlfile
    RMAN-08505: output filename=/u02/oradata/TEST/control01.ctl
    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: t1
    RMAN-08031: released channel: t2
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: restore
    RMAN-03007: retryable error occurred during execution of command: IRESTORE
    RMAN-07004: unhandled exception during command execution on channel t1
    RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file
    , handle="bk_121_1_439118532", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: sbtrestore: Backup file not found.
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIE
    CE

    goodhealth

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    closing this thread since there is a previous one about this matter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width