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 10.2.0.2 and later
Information in this document applies to any platform.
Tablespace point-in-time recovery fails with the following errors:
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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