TSPITR results in ORA-27303: additional information: failed to start instance

(Doc ID 395763.1)

Last updated on DECEMBER 27, 2016

Applies to:

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

Symptoms

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

Changes

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms