Oracle database Flash back log full

The Site page cannot be displayed intact. Checking the Web service is normal, so there may be a problem with the ORACLE database.

First check that the flashback log is full

Then check that the archive log file is full. Use the following commands to see the current archive log file usage:

Select * from v$recovery_file_dest;

Select sum(percent_space_used)*3/ -  fromV$flash_recovery_area_usage;

select   * from  v$flash_recovery_area_usage;

select   * from  v$version;

Flashback space log file directory, maximum value (set to 20G ), current usage value

execute select   * from  v$flash_recovery_area_usage; statement

can seearchived LOGthe usage rate is3.84%, because I have deleted the archived log files. Before deleting the archive log is99.46This number indicates that our archive log has used most of the space. WhenArchived_logof thepercent_space_usedthe value of the field exceeds90%,It is possible to have a database exception, to clean up in time

So enter the rman program Delete Archive log

rman Target SYS / Pass @prjdb

crosscheck Archivelog All ;

delete  archivelog until time  ' sysdate ' ;  -- delete log              for the specified time;

Delete Expired Archivelog All ; -- Delete an expired log

From for notes (Wiz)

Oracle database Flash back log full