Resize Operation Completed For File# 201; FILE# Does Not Exist (Doc ID 2246369.1)()

GOAL

alert.log has many entries with:

Problematic file# 201 is not existing.

SOLUTION

It’s tempfiles and its number is generated dynamically based on parameter db_files – default value 200.We have to subtract db_files value to get the file number in v$tempfile or db_files parameter value + tempfile# so in this case 201-200=1 is the tempfile#.There is one Enhancement request raised for this issue to include filename as well in meaasage.

However these messages are for information only and you can disable this using below parameter:

————————

GOAL

alert.log has many entries with:

Problematic file# 201 is not existing.

SOLUTION

It’s tempfiles and its number is generated dynamically based on parameter db_files – default value 200.We have to subtract db_files value to get the file number in v$tempfile or db_files parameter value + tempfile# so in this case 201-200=1 is the tempfile#.There is one Enhancement request raised for this issue to include filename as well in meaasage.

However these messages are for information only and you can disable this using below parameter: