oracle10g的归档模式和归档路径的更改（国外英文资料）.doc

oracle10g的归档模式和归档路径的更改（国外英文资料） Oracle10gs archive mode and archive path changes Change the archive path In ORACLE10G, the default archive path is $ORACLE_BASE/flash_recovery_area. So for this path, One limitation of ORACLE is that only 2gb of space is available for archival logging, and you can use the following two SQL statements to view its limitations Select * from v $recovery_file_dest; NAME SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- / APPL/flash_recovery_area/arch 21474836480.0 SQL show parameter db_recovery_file_dest (this is more intuitive) NAME TYPE VALUE -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Db_recovery_file_dest string/APPL/flash_recovery_area/arch Db_recovery_file_dest_size big integer 2G When the number of archived logs is greater than 2G, there is no more room for more archival logs to be reported to be unable to continue archiving errors. Such as: -19809: limit exceeded for recovery files ORA 19804: cannot reclaimbytes disk space from 2147483648 limit Arc 0: Error 19809 create archive log file to / u01 / app/oracle/flash_recovery_area/ORCL/archivelog / 2007_04_30/o1_mf_1_220_.arc Then we can modify the default limit, such as increased to 5 gb or more, it can also be archived path back to the other path, there will be no this limit. The change limit statement is as follows: Alter system set db_recovery_file_dest_size = 40G scope = both (this is 5G 5x1024x1024x1024 = 5G) Or simply modify the path of the archive The SQL alter system set log_archive_dest_1 = location = / u01 / archivelog scope