• 数据库启动和RMAN备份报错


    数据库启动和RMAN备份报错:
    ORA-19804: cannot reclaim string bytes disk space from string limit
    Cause: Oracle cannot reclaim disk space of specified bytes from the DB_RECOVERY_FILE_DEST_SIZE limit.
    Action: There are five possible solutions:
    1) Take frequent backup of recovery area using RMAN.
    2) Consider changing RMAN retention policy.
    3) Consider changing RMAN archivelog deletion policy.
    4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
    5) Delete files from recovery area using RMAN.

    oracle10g在默认情况下,归档日志是保存在闪回恢复区的,如果你建库的时候用的默认设置,
    闪回恢复区应该是2G,空间被占满了以后就无法再归档了
    执行下面的语句,可以看到闪回恢复区的使用情况
    1、select reason,object_type,suggested_action from dba_outstanding_alerts;

    2、 select * from v$recovery_file_dest;
    select * from v$flash_recovery_area_usage

    解决方法:
    1.将归档设置到其他目录,修改alter system set log_archive_dest = 其他路径
    2.转移或者删除闪回恢复区里的归档日志。
    3.增大闪回恢复区。
    ALTER SYSTEM SET db_recovery_file_dest_size=4g scope=both;

    利用RMAN删除无效归档日志
    ---查询无效归档日志
    RMAN>crosscheck archivelog all;
    删除无效归档日志
    RMAN>delete expired archivelog all;

    然后设定合理的备份策略来避免备份归档的日志太多
    RMAN>configure retention policy to recovery window of 7 days;
    RMAN>configure retention policy to redundancy 3;

  • 相关阅读:
    10. 正则表达式匹配
    124. 二叉树中的最大路径和。 递归
    1028. 从先序遍历还原二叉树。 深搜
    1014. 最佳观光组合. 转变思路
    297. 二叉树的序列化与反序列化.
    1300. 转变数组后最接近目标值的数组和. 二分
    15. 三数之和. 双指针法⭐
    1. 两数之和. 哈希表
    739. Daily Temperatures. 单调栈
    面试题46. 把数字翻译成字符串. 递归
  • 原文地址:https://www.cnblogs.com/chinaops/p/13587713.html
Copyright © 2020-2023  润新知