ORA-19750: change tracking file | ORA-19751 ORA-17502 ORA-15046 ORA-17503 ORA-15012

I got ” ORA-19750: change tracking file | ORA-19751 ORA-17502 ORA-15046 ORA-17503 ORA-15012 ” error in Oracle database during Open resetlogs.

 

ORA-19750: change tracking file | ORA-19751 ORA-17502 ORA-15046 ORA-17503 ORA-15012

 

Details of error are as follows.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file:
'+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701'
ORA-17502: ksfdcre:4 Failed to create file
+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701
ORA-15046: ASM file name '+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701' is
not in single-file creation form
ORA-17503: ksfdopn:2 Failed to open file
+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701
ORA-15012: ASM file '+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701' does not
exist

SQL

 

 

ORA-19750: change tracking file

ORA-19751 ORA-17502 ORA-15046 ORA-17503 ORA-15012

 

This error is related with the Block Change Tracking file. Database is restored from full backup, then recovered the database and open database with resetlogs mode. But database is not opened because of Change tracking file as follows.

 

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file:
'+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701'
ORA-17502: ksfdcre:4 Failed to create file
+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701
ORA-15046: ASM file name '+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701' is
not in single-file creation form
ORA-17503: ksfdopn:2 Failed to open file
+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701
ORA-15012: ASM file '+DATA/MSDB/CHANGETRACKING/ctf.391283.1057227701' does not
exist

 

To solve this error, Disable the Block Change tracking as follows, then open database.

SQL> alter database disable block change tracking;

Database altered.

SQL> alter database open;

Database altered.

SQL>

 

 

If you want to learn more details about Block Change tracking, read the following post.

Block Change Tracking in Oracle

 

 

 

 

Do you want to learn Oracle dataguard, then read the following articles.

Oracle DataGuard Physical Standby Installation Step by Step Using RMAN -1