Oracle real-world case-Flashback storage space depletion solution (ORA-19815 solution)

This is a real oracle (ORA-19815 solution) case, hope to help everyone. Today, the platform of a friend company experienced slow login and slow data query. In addition, spotlight was used to monitor oracle

This is a real oracle (ORA-19815 solution) case, hope to help everyone. Today, the platform of a friend company experienced slow login and slow data query. In addition, spotlight was used to monitor oracle

This is a real oracle (ORA-19815 solution) case, hope to help everyone.

Today, the platform of a friend company experienced slow login and slow data query, and the failure to log on to oracle monitored through spotlight. By checking the system memory and processes, the record-filing space is free, I did not find any problems, and finally found me. I checked the memory and processes of the platform, and did not find any problems. Finally, I checked the oracle alarm log. I rented a Hong Kong server and found the following problems:

Is the ORA-19815 problem, through metalink query, is the flash back area space is exhausted, the solution I use to increase the flash back area storage space, to solve this problem

Check whether v $ recovery_file_dest tries

98.65% is used.

The following describes how to solve this problem.

Log on to the database

First, check the current flash back area size.

We can see that the size of the flash back area is 2 GB, So I expanded it to 10 Gb.

Then, check the usage of the flash back area.

Check the usage of the flash back area.

Reduced from 98.65% to 22.2%. Check the alarm log.

No longer repeated reports ORA-19815 error, website space, now flash back space use full problem has been solved.

Then, my spotlight monitoring can monitor oracle. The following figure shows how spotlight monitors oracle.

There are a lot of ways to solve the ORA-19815, I am just one of them, thanks to oracle's metalink

This article is from the "Yin-Technical Exchange" blog. Please keep this source