In ORACLE10G, the default archiving path is $ ORACLE_BASE/flash_recovery_area. For this path,
ORACLE has a limit that only 2 GB of space can be used for archiving logs by default. You can use the following two SQL statements to view the limit.
1. select * fromv $ recovery_file_dest;
SQL> showparameterdb_recovery_file_dest (this is more user-friendly and intuitive)
When the number of archived logs is greater than 2 GB, an error that cannot be archived will be reported because there is no more space to accommodate more archived logs.
For example:
RA-19809: limitexceededforrecoveryfiles
ORA-19804: cannotreclaim10017792bytesdiskspacefrom2147483648limit
ARC0: Error19809Creatingarchivelogfileto '/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_04_30/o1_mf_1_220_0 _. arc'
In this case, we can modify its default limit, for example, adding it to 5 Gb or more, or resetting the archive path to another path.
The statement for changing the limit is as follows:
Altersystemsetdb_recovery_file_dest_size = 5368709102 (5G5x1024x1024x1024 = 5G)
Or you can directly modify the archive path.
SQL> altersystemsetlog_archive_dest_1 = 'location =/u01/archivelog 'scope = both;
Note: If the default path has a size limit of 2 GB, there is no size limit after the path is modified.
This article is from the oracle technology discussion blog, please be sure to keep this source http://jackdba.blog.51cto.com/801693/1300562