1. Change the archive path
In oracle10g, the default archive path is $oracle_base/flash_recovery_area. For this path,
Oracle has a limitation that only 2G of space is available to the archive log by default, and you can use the following two SQL statements to view its limitations
1. Select * from V$recovery_file_dest;
SQL >show parameter db_recovery_file_dest (this friendlier and more intuitive)
When the number of archived logs is greater than 2G, there will be no more room for more archive logs to report errors that cannot continue to be archived.
Such as:
Ra-19809:limit exceeded for recovery files
Ora-19804:cannot Reclaim 10017792 bytes disk space from 2147483648 limit
Arc0:error 19809 Creating archive log file to '/u01/app/oracle/flash_recovery_area/orcl/archivelog/2007_04_30/o1_mf_1 _220_0_.arc '
At this point we can modify its default restrictions, such as adding it to 5G or more, or resetting the archive path to another path, and there is no limit to this.
The change limit statement is as follows:
Alter system set DB_RECOVERY_FILE_DEST_SIZE=5368709102 (here is 5G 5x1024x1024x1024=5g)
or directly modify the path of the archive
Sql> alter system set log_archive_dest_1= ' Location=/u01/archivelog ' scope =both;
2. Change the archive mode
sql> archive log list;
sql> shutdown immediate;
sql> startup Mount;
sql> ALTER DATABASE Archivelog;
sql> ALTER DATABASE open;
sql> archive log list;
-----End----