ORA19809

# ORA19809
## Recovery文件满了
```sql
SQL> ho oerr ora 19809
19809, 00000, "limit exceeded for recovery files"
//*Cause: The limit for recovery files specified by the
//        DB_RECOVERY_FILE_DEST_SIZE was exceeded.
// *Action: There are five possible solutions:
//          1) Take frequent backup of recovery area using RMAN.
//          2) Consider changing RMAN retention policy.
//          3) Consider changing RMAN archived log deletion policy.
//          4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
//          5) Delete files from recovery area using RMAN.
```

## 问题处理
遇到的问题是dg无法创建archivelog文件，所以需要查看具体产生原因。

- 确认磁盘空间是否足够

```shell
[oracle@orcl-dg /]$ df -h
df: `/root/.gvfs': Permission denied
Filesystem                      Size   Used  Avail   Use%   Mounted on
/dev/mapper/osavg-lv_root       83G    5.7G   73G    8%     /
tmpfs                           16G    224K   16G    1%     /dev/shm
/dev/sda1                       477M   79M    370M   18%    /boot
/dev/mapper/osavg-lv_home       394G   32G    342G   9%     /oracle
/oracle/orasoft/oel610x64.iso   3.8G   3.8G   0      100%   /mnt/cdrom
```

- 确认recovery

```sql
# 主库
SQL> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------------------------
db_recovery_file_dest                string      /oracle/app/oracle/recovery_area
db_recovery_file_dest_size           big integer 8G

# 备库
SQL> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------------------------
db_recovery_file_dest                string      /oracle/app/oracle/recovery_area
db_recovery_file_dest_size           big integer 4G

# 可以看出来问题在这里，主库比备库的容量大一倍导致dg无法传输日志，需要修改recovery文件大小
alter system set db_recovery_file_dest_size=8G;
```