RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/09/2007 12:01:22
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation




At the end of duplication of database using rman duplicate command was giving the above error . It kept coming again and again whenever i tried to duplicate.


After a search on google i found that having another session with system user will cause rman to throw this error. I found myself having another session which i used to start up database in nomount mode was still in an active state. 


After closing that session and rerunning the duplicate command did the work successfully


 Helpful Link
http://www.orafaq.com/forum/t/78078/2/

Comments

  1. ITS NOT ABOUT THE SESSION OPEN ...ITS ALL ABOUT THE MEMORY SO NOT TO WORRY ...AFTER TYPING CTRL+C
    COMMAND GO TO DUPLICATE DATABASE COMMAND PROMPT AND TYPE ALTER DATABASE OPEN ,THEN IT SHOWS DATABAE SHOULS OPEN WITH RESETLOG OPTION .THEN OPEN THE DATABASE WITH ATER DATABASE OPENRESETLOG ;
    THEN UE DATABAE WILL OPEN


    DO IT ! ALL THE BEST

    ReplyDelete
    Replies
    1. Dear Anand,

      Please the below MOS

      Duplicate database RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation [ID 420609.1]

      Delete
  2. Hi Anand,

    I had faced the above issue and did your solution its working fine.
    Thanks
    Renga

    ReplyDelete

Post a Comment

Popular posts from this blog

Error processing request - Contact your application administrator apex 20.1

APP-FND-01436: List of Values cannot find any values for you to choose error from concurrent request program parameter (R12 12.1.3)

WEB ADI - issues encountered during initial access