ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.85% used
来源:互联网 发布:淘宝卖家查看店铺粉丝 编辑:程序博客网 时间:2024/04/25 23:22
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.85% used
2012-11-24 01:27:38| 分类:Oracle | 标签:|举报|字号大中小 订阅
Errors in file /opt/oracle/admin/test/bdump/test_mmon_9344.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.85% used, and has 24658944 remaining bytes available.
Fri Nov 23 23:23:55 2012
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Nov 23 23:23:55 2012
--查看当前 recovery_file_dest 使用情况
set lines 200
select substr(name,1,30) name,space_limit as quota,space_used as used,space_reclaimable as reclaimable,number_of_files as files from v$recovery_file_dest;
解决方法一:
--扩大db_recovery_file_dest_size大小
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0
解决方法二:
--清理快速恢复区信息
NAME QUOTA USED RECLAIMABLE FILES
------------------------------------------------------------ ---------- ---------- ----------- ----------
/opt/oracle/flash_recovery_are 2147483648 2122824704 0 50
rman 执行:
run {
crosscheck archivelog all;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired archivelog all;
delete noprompt expired backup;
resync catalog;
}
--查看执行之后 recovery_file_dest 使用情况
NAME QUOTA USED RECLAIMABLE FILES
------------------------------------------------------------ ---------- ---------- ----------- ----------
/opt/oracle/flash_recovery_are 2147483648 0 0 0
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.85% used, and has 24658944 remaining bytes available.
Fri Nov 23 23:23:55 2012
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Nov 23 23:23:55 2012
--查看当前 recovery_file_dest 使用情况
set lines 200
select substr(name,1,30) name,space_limit as quota,space_used as used,space_reclaimable as reclaimable,number_of_files as files from v$recovery_file_dest;
解决方法一:
--扩大db_recovery_file_dest_size大小
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0
解决方法二:
--清理快速恢复区信息
NAME QUOTA USED RECLAIMABLE FILES
------------------------------------------------------------ ---------- ---------- ----------- ----------
/opt/oracle/flash_recovery_are 2147483648 2122824704 0 50
rman 执行:
run {
crosscheck archivelog all;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired archivelog all;
delete noprompt expired backup;
resync catalog;
}
--查看执行之后 recovery_file_dest 使用情况
NAME QUOTA USED RECLAIMABLE FILES
------------------------------------------------------------ ---------- ---------- ----------- ----------
/opt/oracle/flash_recovery_are 2147483648 0 0 0
0 0
- ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.85% used
- ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 87.41% used
- ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 100.00% used
- ORA-19815: WARNING: db_recovery_file_dest_size of 36676042752 bytes is 100.00% used
- ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 87.41% used, and has 270457856 remaining bytes available.
- ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 100.00% used, and has 0 remain
- oracle归档日志满了的处理方法 (ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 87.41% use)
- ORA-19815: WARNING: string of string bytes is string%% used, and has string remaining bytes available.
- ORA-19815: WARNING: db_recovery_file_dest_size
- ORA-19815: WARNING: db_recovery_file_dest_size is 100.00% 处理方法
- The stack 'CSTACK' is filled to 92% (368 bytes used out of 400). The warning threshold is set to 90.%
- ORA-27063: number of bytes read/written is incorrect
- warning: the frame size of 1456 bytes is larger than 1024 bytes
- warning: the frame size of 1040 bytes is larger than 1024 bytes
- warning: the frame size of 1040 bytes is larger than 1024 bytes
- warning: the frame size of 1040 bytes is larger than 1024 bytes
- warning: the frame size of 1104 bytes is larger than 1024 bytes [-Wframe-larger-than=]
- warning: the frame size of 1040 bytes is larger than 1024 bytes
- 使用NPOI导入导出标准Excel
- JavaWeb:报错信息The superclass "javax.servlet.http.HttpServlet" was not found on the Java Build Path
- hadoop mapreduce 之wordcount 编译执行
- IIS Express 启用目录浏览
- NYOJ 520 & HDU 2136 Largest prime factor(筛法思想)
- ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.85% used
- rails开发流程
- iOS提交发布应用(Xcode5)到App Store 详细解析
- 一维DFT
- 网络基础
- 第十二周 求数的阶乘(递归算法)
- MongoDB 开篇
- JavaWeb——Day20_1
- HDU 4734F(x) 题解 (记忆化DP)