After Restore/Recover Open Fails When BCT Resides on ASM

(Doc ID 2106736.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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

Symptoms

Error opening database after restore/recover of the database with BCT on ASM:


RMAN-03002: failure of sql statement command at 02/12/2016 21:35:17
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file: '+DATA/IHEM/CHANGETRACKING/ctf.289.903641315'
ORA-17502: ksfdcre:4 Failed to create file +DATA/IHEM/CHANGETRACKING/ctf.289.903641315
ORA-15046: ASM file name '+DATA/IHEM/CHANGETRACKING/ctf.289.903641315' is not in single-file creation form
ORA-17503: ksfdopn:2 Failed to open file +DATA/IHEM/CHANGETRACKING/ctf.289.903641315
ORA-15012: ASM file '+DATA/IHEM/CHANGETRACKING/ctf.289.903641315' does not exist

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