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

Thread: RAMN Error Message

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    RAMN Error Message

    Hi all,
    I'm trying to backup level-0 of the target database. Everything seems OK except at the end of backup I get the error message as following:
    The stored script:
    replace script backup0 {
    allocate channel d1 type disk;
    backup
    incremental level 0
    format '/opt/apps/oracle/backup/%d_%s_%p'
    filesperset 1
    (database include current controlfile);
    sql 'alter system archive log current';
    release channel d1;
    }

    using:
    rman target / catalog rman/rman@rcat
    RMAN>run {execute script backup0;}

    Error Message:
    .....
    ....
    ......

    RMAN-08010: channel d1: specifying datafile(s) in backupset
    RMAN-08522: input datafile fno=00007 name=/opt/apps/oracle/product/8.1.5/dbs/oradata/soldb/drsys01_SOL.dbf
    RMAN-08013: channel d1: piece 1 created
    RMAN-08503: piece handle=/opt/apps/oracle/backup/SOLDB_35_1 comment=NONE
    RMAN-08525: backup set complete, elapsed time: 00:00:35
    RMAN-03023: executing command: partial resync
    RMAN-08003: starting partial resync of recovery catalog
    RMAN-08005: partial resync complete

    RMAN-03022: compiling command: sql
    RMAN-06162: sql statement: alter system archive log current
    RMAN-03023: executing command: sql
    RMAN-03026: error recovery releasing channel resources
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-07005: error during channel cleanup
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-10032: unhandled exception during execution of job step 1:
    RMAN-10035: exception raised in RPC:
    S0U¼¤äè!¼ôÜä
    RMAN-10031: ORA-3114 occurred during call to DBMS_BACKUP_RESTORE.BACKUPCANCEL
    RMAN-03015: error occurred in stored script backup0
    RMAN-03006: non-retryable error occurred during execution of command: sql
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-20000: abnormal termination of job step
    RMAN-11003: failure during parse/execution of SQL statement: alter system archive log current
    RMAN-11001: Oracle Error: ORA-03113: end-of-file on communication channel

    Recovery Manager complete.


    Any idea
    //Hamhey

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Which OS ??
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    Hi
    The OS is solaris 8.0 and the Oracle version is 8.1.5

    //Hamhey

  4. #4
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Hi,

    Metalink has a subject on this. I tried to copy the link, but it doesn't forward you correctly.

    Go to metalink.oracle.com and search for "RMAN-03026".
    Choose "Receiving RMAN-03026 with comand list backup" in the result list.

    HTH,

    Erik


    Oops: it's a different OS (when I started typing, there were no other replies...)
    Last edited by efrijters; 06-10-2003 at 07:57 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    This could possibly be a bug.

    Raise an iTAR.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Aug 2000
    Posts
    87
    Hi Hamhey,

    Can you ur backup by changing onething in ur backup script.

    Instead of "sql 'alter system archive log current';" use "alter system switch logfile"

    I hope this would help u.

    regards,
    Vinod

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