【翻譯自mos文章】參數Db_recovery_file_dest_size的最大值是多少,dbrecoveryfiledest

來源:互聯網
上載者:User

【翻譯自mos文章】參數Db_recovery_file_dest_size的最大值是多少,dbrecoveryfiledest
參數Db_recovery_file_dest_size的最大值是多少?

參考原文:
What Is Maximum Size For Db_recovery_file_dest_size In Oracle 10.2, 11.1, 11.2 (Doc ID 1404822.1)

適用於:
Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

解決方案:
db_recovery_file_dest_size 的最大值是17179869182G
資料庫是oracle10,最近頻頻發生db_recovery_file_dest_size被佔滿至設定的最大值,然後資料庫就宕掉了

hi.baidu.com/...7.html

參考下
 
alter system set DB_RECOVERY_FILE_DEST_SIZE=10g 這個語句是不是及時生效的 還需不需要重啟資料庫?

DB_RECOVERY_FILE_DEST_SIZE這個是session級的命令,不用重啟;
 

相關關鍵詞:
相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.