Oracle 释放flash recovery area的四种方法
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle 释放flash recovery area的四种方法,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含6519字,纯文字阅读大概需要10分钟。
内容图文
早上收到一台Linux服务器磁盘告警邮件以及监控告警日志程序发来的邮件。检查过后,发现Linux服务器中一个分区没有空间了。主要原因是由于昨晚程序员做升级时,产生了大量的归档日志,导致联机重做日志无法归档,出现下面错误:
363 | Wed Mar 19 02:33:16 2014 | ORA-00312: online log 2 thread 1: ‘/u01/app/oracle/oradata/mes/redo02.log‘
369 | Wed Mar 19 02:34:16 2014 | ORA-16014: log 2 sequence# 75999 not archived, no available destinations
370 | Wed Mar 19 02:34:16 2014 | ORA-00312: online log 2 thread 1: ‘/u01/app/oracle/oradata/mes/redo02.log‘
373 | Wed Mar 19 02:34:16 2014 | ORA-16014: log 2 sequence# 75999 not archived, no available destinations
374 | Wed Mar 19 02:34:16 2014 | ORA-00312: online log 2 thread 1: ‘/u01/app/oracle/oradata/mes/redo02.log‘
383 | Wed Mar 19 02:39:16 2014 | ORA-19502: write error on file "/u03/flash_recovery_area/mes/archivelog/2014_03_19/o1_mf_1_75999_9lk4pngn_.arc", blockno 108545 (blocksize=512)
384 | Wed Mar 19 02:39:16 2014 | ORA-27072: File I/O error
由于当时比较急,于是手工删除了昨天的归档日志,释放了大量空间,结果发现告警日志出现了如下错误:
ORA-19815: WARNING: db_recovery_file_dest_size of 42949672960 bytes is 100.00% used, and has 7684830208 remaining bytes available.
Wed Mar 19 08:48:48 2014
************************************************************************
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.
************************************************************************
Wed Mar 19 08:48:54 2014
Thread 1 advanced to log sequence 76076 (LGWR switch)
出现这个错误时因为:当手工删除了归档日志以后,Rman备份会检测到日志缺失,从而无法进一步继续执行。所以此时需要手工执行crosscheck过程,之后Rman备份可以恢复正常。
如上所示,Oracle 提供了4中方法解决这个问题:
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.
翻译如下:
你可以采用下面选项释放闪回恢复区的空间:
1:考虑修改RMAN备份保留策略,如果你使用的Data Guard,应该考虑修改RMAN归档日志删除策略。
2:使用RMAN BACKUP RECOVERY AREA命令将备份至于第三方设备(例如磁带)
3:增加磁盘空间并增加db_recovery_file_dest_size大小。
<DIV style=‘margin: 20px 0px 10px; padding: 4px; border: 1px solid silver; width: 97.5%; text-align: left; line-height: 10pt; overflow: auto; font-family: "Courier New", courier, monospace; font-size: 10pt; cursor: text; direction: ltr; max-height: 200px; background-color: rgb(244, 244, 244);‘ id="codeSnippetWrapper"> <DIV style=‘padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: rgb(244, 244, 244);‘ id="codeSnippet"><PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: white;‘> 1:SQL> show parameter db_recovery_file_dest<PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: rgb(244, 244, 244);‘> 2: <PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: white;‘> 3: NAME TYPE VALUE<PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: rgb(244, 244, 244);‘> 4: <PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: white;‘> 5: ------------------------------------ ----------- ------------------------------<PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: rgb(244, 244, 244);‘> 6: <PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: white;‘> 7: db_recovery_file_dest string /u03/flash_recovery_area<PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: rgb(244, 244, 244);‘> 8: <PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: white;‘> 9: db_recovery_file_dest_size big integer 40G<PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: rgb(244, 244, 244);‘> 10: <PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: white;‘> 11:SQL>alter system set db_recovery_file_dest_size=48G scope=both;<PRE style=‘margin: 0em; padding: 0px; width: 100%; text-align: left; color: black; line-height: 10pt; overflow: visible; font-family: "Courier New", courier, monospace; font-size: 10pt; direction: ltr; background-color: rgb(244, 244, 244);‘> 12:内容总结
以上是互联网集市为您收集整理的Oracle 释放flash recovery area的四种方法全部内容,希望文章能够帮你解决Oracle 释放flash recovery area的四种方法所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。