Is the DML statement an error because the control file cannot be expanded or is there another reason ?, Dml also has

Is the DML statement an error because the control file cannot be expanded or is there another reason ?, Dml also has

Today, I have handled a very interesting fault problem. The reason is as follows:

 

The customer's incoming call consultation control file cannot be expanded, and the database can only be queried but does not support DML. remote support is required. The first response to receiving the call was whether the CONTROL_FILE_RECORD_KEEP_TIME parameter was set too small because the backup of the database was retained for up to 60 days.

 

After remote access, first view the Control File View:

 

After conversion, the current control file is about 25 MB. If you are interested, you should be impressed that in the HACMP + RAC + RAW architecture, the control files are generally 256 M or M, the current value is only 25 M, and ASM can be automatically expanded. So I felt strange.

 

Create another test table for verification:

 

 

Table creation statement hang

 

Check the alert log of the database:

 

The reason why the database can only be queried but cannot be DML is not related to the reason why the "control file cannot be expanded". It must be because the archiving path is full, resulting in the database hang and waiting for online log Archiving

 

This idea is verified as follows:

The archive directory is also in the DATA disk group.

 

 

The DATA disk group is currently only available for MB.

 

At this point, the root cause of the problem has been found. solution:

Connect to RMAN to delete archived logs

delete noprompt archivelog all completed before 'sysdate-2';

 

Query the disk group usage:

The remaining 35 GB space is available, and the application returns to normal.

 

 

Inspiration:

The final solution to the problem is very simple, but I want to share my thoughts on how to solve the problem: when receiving the problem, I should first learn about the problem from the customer, however, remember to perform one-to-one verification on the clues provided by the customer to avoid providing error directions for us to diagnose the problem, because the signal source obtained by the customer is itself incorrect, just like in this case, the customer also calls remote development engineers to report "control files cannot be expanded.

 

 

Bytes -------------------------------------------------------------------------------------------------

This article comes from my technical blog http://blog.csdn.net/robo23

For reprinting, please mark the source text link; otherwise, you will be held legally responsible!

Two transactions run at the same time a transaction contains DDL statements and a DML statement. Why should I report an error:

DDL will modify the data dictionary. DML will modify the data. If it is for the same object (such as a table), it will cause problems.

Which command is not a DML statement?

Create table
This is DDL.