Shulou(Shulou.com)06/01 Report--

Dealing with the problem of full space in the flash area of Oracle database

Author: Zhao full text net name: guestart

As soon as I arrived at work this morning, I found that an alarm appeared on the overview page of a database server on EMCC.

Query alert_orcl13.log and find the following error

Errors in file / u01/app/oracle/diag/rdbms/orcl13/orcl13/trace/orcl13_arc3_34080.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 68719476736 bytes is 100.00% used, and has 0 remaining bytes available.

System command was used to delete files, then use RMAN CROSSCHECK and

*

DELETE EXPIRED commands.

You have following choices to free up spacefrom recovery area:

*

1. Consider changing RMAN RETENTION POLICY.If you are using Data Guard

ARC0: Error 19809 Creating archive log fileto'+ DATA'

Then consider changing RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such astape using RMAN

BACKUP RECOVERY AREA command.

3. Add disk space and increasedb_recovery_file_dest_size parameter to

Reflect the new space.

4. Delete unnecessary files using RMANDELETE command. If an operating

System command was used to delete files, then use RMAN CROSSCHECK and

DELETE EXPIRED commands.

*

It is found that the capacity of the flashback area has reached 100%, so what is the current capacity of the flashback area?

SYS@orcl13 > show parameterdb_recovery_file_dest_size

NAME TYPE VALUE

Db_recovery_file_dest_size big integer 64G

Increase the capacity of the flashback area to 100G

Check the location of the archived files by the way.

Oh, I suddenly realized that the archived files were saved in the flashback area, which exploded the capacity of the flashback area.

Archived files are increasing all the time, either when backing up with rman without setting a policy for clearing archived logs, or when rman backups are not performed.

Check to see if a rman backup has been made

It turns out that there is no rman backup. Because it is a test library, it is caused by not using rman backup after the archiving function is turned on.

Now turn on rman backup

Check the log file of alert_orcl13.log again. The archiving operation has been switched, and everything is fine.

If you think this article is helpful to you, you are welcome to follow the DBA study notes on Wechat official account: guestart. Your support is my greatest encouragement!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.