DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2001

    hi all,
    I am on OPS and aix 4.3, 8.1.6, tsm. I have taken a backup, fine. I have restored it, fine. Now I want to recover but it fails with the error stack below. But the log "11205" that RMAN complains about was backed up. My backup log shows it.
    Secondly I have run a "list archivelog all" and it is in the catalog.
    Here is the output from the catalog.

    Seq Low SCN Next SCN Low Time Next Time
    ------- ---------- ---------- --------------- --------------
    11205 1658164724 1658175224 Jan 29 2002 23:55:26 Jan 30 2002 00:20:22

    it looks like it was generation started on the 29th and was completed on the 30th. Is this the problem? How do I solve it. take a look at my script.

    allocate channel t1 type 'sbt_tape' connect internal/XXXX@XXXXX;
    allocate channel t2 type 'sbt_tape' connect internal/XXXX@XXXXX;
    backup full
    format 's80_d%d_s%s'
    backup current controlfile;
    sql 'alter system switch logfile';
    sql 'alter system archive log current';
    format 's80_d%d_arch_s%s'
    from time 'SYSDATE-2'
    thread 1
    channel t1);
    format 's80_d%d_arch_s%s'
    from time 'SYSDATE-2'
    thread 2
    channel t2);
    release channel t1;
    release channel t2;

    RMAN-08024: channel t2: restore complete
    RMAN-08060: unable to find archivelog
    RMAN-08510: archivelog thread=2 sequence=11205
    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: recover
    RMAN-03006: non-retryable error occurred during execution of command: recover(4)
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-20000: abnormal termination of job step
    RMAN-06003: ORACLE error from target database: ORA-19634: filename required for
    this function
    ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 1959
    ORA-06512: at line 1
    Thanks so much

    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Mar 2001
    Try to execute this and after run "list archivelog all" command. Will you see your log?

    allocate channel for maintenance type 'sb_tape';
    crosscheck backup;
    change archivelog all crosscheck;
    change archivelog all vaildate;
    crosscheck backup of archivelog all;
    release channel;
    Best wishes!

  3. #3
    Join Date
    Sep 2001
    Life is what is happening today while you were planning tomorrow.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.