ORA-19852: error creating services for auxiliary instance
During Auxiliary instance creation , the following error appeared.
2> set newname for datafile 12 to ‘D:\backup\%f’;
3> recover tablespace testtbs
4> until scn 8448197
5> auxiliary destination ‘D:\backupnew’;
executing command: SET NEWNAME
Starting recover at 01-JAN-11
using channel ORA_DISK_1
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Creating automatic instance, with SID=’CBka’
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of recover command at 01/01/2011 14:43:56
ORA-19852: error creating services for auxiliary instance CBka (error 0)
ORA-27302: failure occurred at:
ORA-27303: additional information: failed to start instance
You need to run following command in sql prompt.
SQL> exec dbms_backup_restore.manageauxinstance (‘TSPITR’,1);
PL/SQL procedure successfully completed.
Now you can try to re-exeucte , It should be work. 🙂