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.

 

 

 

 

Recent Posts

Start typing and press Enter to search