Home » RDBMS Server » Backup & Recovery » RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operat
RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operat [message #223449] Fri, 09 March 2007 00:03 Go to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hi All,

Here i'm create duplicate database from prod side using ramn.

I have use thsi cmd.

C:\>rman TARGET=sys/oracle@Adaptime AUXILIARY=sys/oracle@Oplus
Recovery Manager: Release 10.1.0.2.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: ORA101 (DBID=5128390)
connected to auxiliary database: testdb (not mounted)

RMAN>
run
2> {
3> allocate auxiliary channel c1 device type DISK;
4> allocate auxiliary channel c2 device type DISK;
5> allocate auxiliary channel c3 device type DISK;
6> DUPLICATE target database to TESTDB;
7>
}

}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 09-MAR-07

channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\SYSTEM01.DBF
restoring datafile 00002 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\SYSAUX01.DBF
restoring datafile 00004 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\USERS01.DBF
restoring datafile 00005 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\EXAMPLE01.DBF
channel c1: reading from backup piece D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ADAPTIME\BACKUPSET\2007_03_09\O1_MF_NNNDF_TAG20070309T10
140_2Z1V4G86_.BKP
channel c1: restored backup piece 1
piece handle=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ADAPTIME\BACKUPSET\2007_03_09\O1_MF_NNNDF_TAG20070309T104140_2Z1V4G86_.BKP tag=TA
20070309T104140
channel c1: restore complete, elapsed time: 00:00:56
Finished restore at 09-MAR-07
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "OPLUS" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\REDO01.LOG' ) SIZE 50 M REUSE,
GROUP 2 ( 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\REDO02.LOG' ) SIZE 50 M REUSE,
GROUP 3 ( 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\REDO03.LOG' ) SIZE 50 M REUSE
DATAFILE
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252


contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=616762865 filename=D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\UNDOTBS01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=616762865 filename=D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\SYSAUX01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=616762865 filename=D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=616762865 filename=D:\ORACLE\PRODUCT\10.2.0\ORADATA\OPLUS\EXAMPLE01.DBF

contents of Memory Script:
{
set until scn 796006;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 09-MAR-07

starting media recovery

archive log thread 1 sequence 8 is already on disk as file D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ADAPTIME\ARCHIVELOG\2007_03_09\O1_M
_1_8_2Z1V6DQT_.ARC
archive log filename=D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ADAPTIME\ARCHIVELOG\2007_03_09\O1_MF_1_8_2Z1V6DQT_.ARC thread=1 sequence=

media recovery complete, elapsed time: 00:00:04
Finished recover at 09-MAR-07

contents of Memory Script:
{
shutdown clone;
startup clone nomount ;
}
executing Memory Script

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

What's the prblem ?

Babu

[Updated on: Fri, 09 March 2007 01:00]

Report message to a moderator

Re: RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current op [message #223523 is a reply to message #223449] Fri, 09 March 2007 06:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
ORA-01013: user requested cancel of current operation

Seems you asked for it!
Re: RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current op [message #223573 is a reply to message #223523] Fri, 09 March 2007 11:19 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


I can't understand. Can you explain me.

Babu
Re: RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current op [message #223582 is a reply to message #223573] Fri, 09 March 2007 12:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Either you were impatient and tried to kill the process
or
You had another open session with SYSTEM user.
Re: RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current op [message #223648 is a reply to message #223582] Sat, 10 March 2007 00:50 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Yes your correct.

Now it's working well.
Previous Topic: How Media Management Layer works
Next Topic: Exporting specific view, procedures and packages into dump file
Goto Forum:
  


Current Time: Fri Dec 02 18:28:04 CST 2016

Total time taken to generate the page: 0.29642 seconds