[Translated from mos] What is the maximum value of Db_recovery_file_dest_size? dbrecoveryfiledest

[Translated from mos] What is the maximum value of Db_recovery_file_dest_size? dbrecoveryfiledest
What is the maximum value of Db_recovery_file_dest_size?

Reference Original:
What Is Maximum Size For Db_recovery_file_dest_size In Oracle 10.2, 11.1, 11.2 (Doc ID 1404822.1)

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

Solution:
The maximum value of db_recovery_file_dest_size is 17179869182 GB.
The database is oracle10. Recently, db_recovery_file_dest_size has been filled up to the set maximum value, and the database goes down.

Hi.baidu.com/...7.html

Refer
 
Alter system set DB_RECOVERY_FILE_DEST_SIZE = 10g does the statement take effect immediately? Do you still need to restart the database?

DB_RECOVERY_FILE_DEST_SIZE This is a session-level command and does not need to be restarted;