Step1:
We want to ensure the block change tracking is enabled in our database or not by using the below sql statement.
i.e,
SQL> select filename,status from v$block_change_tracking;
FILENAME
——————————————————————————–
STATUS
———-
/u01/app/oracle/RMAN/ORADBA/TRACKING_FILE/block_change_TESTDB.log
ENABLED
Step 2:
If you see there is block change tracking was enabled then, Workaround the following solutions anyone.
Solution 1:
Increase size of SGA_TARGET and SGA_MAX_SIZE by 20%
alter system set SGA_TARGET= scope=spfile;
alter system set SGA_MAX_SIZE= scope=spfile;
Then,
Increase size of large_pool_size,
alter system set large_pool_size= scope=spfile;
Solution 2:
Disabled the block change tracking parameter by using the below command,
alter database disable block change tracking ;
Then ensure it is disabled perfectly by issuing the below command,
select filename,status from v$block_change_tracking;
FILENAME
—————————
STATUS
———-
DISABLED
If you use any one of the solutions from above the alert will be cleared.