Method: 1. Use the "select * from v$recovery_file_dest" statement to check the actual usage of the archive space; 2. Use the "select * from v$flash_recovery_area_usage;" statement to check the flash recovery area space usage.
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
1. Here you can see the space usage in the flash recovery area:
SQL> select * From v$flash_recovery_area_usage;
The example is as follows:
2. Note that this step is to truly check the actual usage of the archive space:
SQL> select * from v$recovery_file_dest;
The example is as follows:
Expand knowledge:
Here I suggest following the following steps to determine: Is the archive space full?
1. First, determine the disk space of the archive directory from the system level:
[oracle@localhost bdump]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 26G 12G 14G 46% / /dev/sda2 19G 16G 2.8G 85% /oracle /dev/sda1 99M 24M 71M 25% /boot tmpfs 978M 508M 470M 52% /dev/shm
2. Determine the archive storage directory and the archive storage directory size
SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST -------这里默认使用的是DB_RECOVERY_FILE_DEST Oldest online log sequence 17 Next log sequence to archive 20 Current log sequence 20
You can also follow the following steps How to query the location of the archive
SQL> show parameter db_ NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_keep_cache_size big integer 0 db_name string lixora db_recovery_file_dest string /oracle/flash_recovery_area db_recovery_file_dest_size big integer 2G db_recycle_cache_size big integer 0 db_unique_name string lixora
Recommended tutorial: "Oracle Video Tutorial"
The above is the detailed content of How to query archive space in Oracle. For more information, please follow other related articles on the PHP Chinese website!