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

 

 1,547 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Do NOT follow this link or you will be banned from the site!