Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 12 22:28:23 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1149657212)

RMAN> RUN
2> {
3> ALLOCATE CHANNEL MY_CHANNEL TYPE DISK;
4> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
5> SET NEWNAME FOR DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\MYDATAFILE.DBF' TO 'e:\new folder (3)\MYDATAFILE.DBF';
6> RECOVER TABLESPACE 'MYTABLESPACE' UNTIL TIME "TO_DATE('2007-07-12 10:27:00','YYYY-MM-DD HH24:MI:SS')" AUXILIARY DESTINATION 'e:\new folder (3)';
7> SQL 'ALTER TABLESPACE "MYTABLESPACE" ONLINE';
8> }
9> 
using target database control file instead of recovery catalog
allocated channel: MY_CHANNEL
channel MY_CHANNEL: sid=132 devtype=DISK

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

executing command: SET NEWNAME

Starting recover at 12-JUL-07
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point in time

List of tablespaces expected to have UNDO segments
tablespace SYSTEM
tablespace UNDOTBS1

Creating automatic instance, with SID='jmkx'
released channel: MY_CHANNEL
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/12/2007 22:28:36
ORA-19852: error creating services for auxiliary instance jmkx (error 0)
ORA-27302: failure occurred at: 
ORA-27303: additional information: failed to start instance

Recovery Manager complete.

SQL> exec dbms_backup_restore.manageauxinstance ('TSPITR',1);