My Oracle Support Banner

TSPITR results in ORA-27303: additional information: failed to start instance (Doc ID 395763.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Tablespace point-in-time recovery fails with the following errors:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/26/2006 07:47:27
ORA-19852: error creating services for auxiliary instance sjff (error 0)
ORA-27302: failure occurred at:
ORA-27303: additional information: failed to start instance

debug trace shows:

DBGSQL: EXEC SQL AT TARGET begin sys . dbms_backup_restore .
manageAuxInstance ( :lorasid , :lclean ) ; end ; [08:06:00.968]
DBGSQL: sqlcode=-19852 [08:06:00.983]
DBGMISC: krmksqlerror called from file krmk.c, line 30943 [08:06:00.983]
DBGMISC: krmicomp: error 6003 signalled during compilation [08:06:01.015]
DBGMISC: ENTERED krmkmrsr [08:06:01.015]

DBGSQL: EXEC SQL AT TARGET select decode(status,'OPEN',1,0) ,
decode(archiver,'FAILED',1,0) into :b1,:b2 from v$instance [08:06:01.015]
DBGSQL: sqlcode=0 [08:06:01.015]
DBGSQL: :b1 = 1
DBGSQL: :b2 = 0


A TSPITR had already been executed and cancelled because of other errors.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.