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

Thread: unable to find archivelog rman 8060

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Posts
    200

    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.


    run
    {
    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'
    (database);
    backup current controlfile;
    sql 'alter system switch logfile';
    sql 'alter system archive log current';
    backup
    format 's80_d%d_arch_s%s'
    (archivelog
    from time 'SYSDATE-2'
    thread 1
    channel t1);
    backup
    format 's80_d%d_arch_s%s'
    (archivelog
    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
    Location
    Ireland/Dublin
    Posts
    688
    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!
    Dmitri

  3. #3
    Join Date
    Sep 2001
    Posts
    200
    Thanks
    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