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 see its limitations
1. Select * from V$recovery_file_dest;
SQL >show parameter Db_recovery_file_dest (this is more friendly and intuitive some)
When the number of archived logs is greater than 2G, there is no more space to accommodate more archive logs, which can be reported as an error 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 limit, for example, to increase it to 5G or more, you can also reset the archive path to another path, there is no such limit.
The change limit statement is as follows:
Alter system set DB_RECOVERY_FILE_DEST_SIZE=5368709102 (5G 5x1024x1024x1024=5g here)
or modify the path of the archive directly
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----
Change the Oracle archive mode path