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.
Do you want to learn Oracle dataguard, then read the following articles.
Oracle DataGuard Physical Standby Installation Step by Step Using RMAN -1