Home > Database > Mysql Tutorial > body text

Oracle闪回区管理

WBOY
Release: 2016-06-07 17:06:03
Original
940 people have browsed it

Errors in file /home/Oracle/diag/rdbms/orarpt/orarpt/trace/orarpt_mmon_22508.trc: ORA-19815: WARNING: db_recovery_fil

今天数据库重启时,查看alert日志发现上面的错误,虽然现在数据库可以正常启动运行,但当这个db_recovery_file_dest_size使用100%的时候,,
将会报错ORA-19809: limit exceeded for recovery files,数据库将会因无法归档而挂起。

查看闪回区的信息

查看alert告警,以及oracle给出的处理建议。

这里我只试了第3、4种方法

第3种修改方法,扩展闪回区

现在已经将闪回区空间扩充到了4G,也就是新增了2G。

第4种修改方法,清空闪回区
注意,刚才直接将db_recovery_file_dest目下的文件删除,SPACE_USED也不会释放。

再查看闪回区的信息,SPACE_USED已经释放。

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template