How to query archive space in Oracle-Oracle-php.cn

How to query archive space in Oracle

WBOY

Release： 2022-05-30 17:14:11

Original

5341 people have browsed it

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.

How to query archive space in Oracle

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to query archive space in oracle

1. Here you can see the space usage in the flash recovery area:

SQL> select * From v$flash_recovery_area_usage;

Copy after login

The example is as follows:

How to query archive space in Oracle

2. Note that this step is to truly check the actual usage of the archive space:

SQL> select * from v$recovery_file_dest;

Copy after login

The example is as follows:

How to query archive space in Oracle

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

Copy after login

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

Copy after login

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

Copy after login

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!