Saturday, 10 September 2011

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/