Skip to content

Archive for

ORA-19852: error creating services for auxiliary instance

During Auxiliary instance creation , the following error appeared.

RMAN> run{
2> set newname for datafile 12 to ‘D:\backup\%f’;
3> recover tablespace testtbs
4> until scn 8448197
5> auxiliary destination ‘D:\backupnew’;
6> }

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
Tablespace SYSTEM
Tablespace UNDOTBS2

Creating automatic instance, with SID=’CBka’
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
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. 🙂