Oracle 12c DG，error：ORA-19815: WARNING: db_recovery_file_dest_size of 3145728000 bytes is 96.92% used, and has 96872960 remaining bytes available.
在我的一个12c的DG的备库上，检查Alert日志的时候发现了如题所示的告警。
具体如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
2018-12-18T17:40:21.746945+08:00 Media Recovery Waiting for thread 1 sequence 45 Fetching gap sequence in thread 1, gap sequence 45-68 2018-12-18T17:40:22.458591+08:00 Completed: alter database recover managed standby database disconnect from session 2018-12-18T17:42:18.403378+08:00 FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 45-68 DBID 1520552370 branch 992771642 FAL[client]: All defined FAL servers have been attempted. ------------------------------------------------------------------------- Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that's sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps. ------------------------------------------------------------------------- （过多的输出，...） 2018-12-18T17:51:27.279736+08:00 Errors in file /u01/app/oracle/diag/rdbms/orclstdby/orcl/trace/orcl_m000_15625.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 3145728000 bytes is 96.92% used, and has 96872960 remaining bytes available. 2018-12-18T17:51:27.280216+08:00 ************************************************************************ You have following choices to free up space from recovery area: 1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard, then consider changing RMAN ARCHIVELOG DELETION POLICY. 2. Back up files to tertiary device such as tape using RMAN BACKUP RECOVERY AREA command. 3. Add disk space and increase db_recovery_file_dest_size parameter to reflect the new space. 4. Delete unnecessary files using RMAN DELETE command. If an operating system command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands. ************************************************************************ |
备库上查看下DB_RECOVERY的相关设置：
|
1 2 3 4 5 6 7 |
SQL> show parameter db_recovery NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /oradata/fast_recovery_area db_recovery_file_dest_size big integer 3000M SQL> |
文件系[……]
- Posted on:
-
Author:
Adamhuan
- Categories: Oracle Dataguard
- Tags: alert, archived log, DB_RECOVERY_FILE_DEST, DG, error, FRA, ORA-19815, ORA-19815: WARNING: db_recovery_file_dest_size of 3145728000 bytes is 96.92% used， and has 96872960 remaining bytes available., Oracle, Rman, size, SQL, 归档日志, 错误
- Leave a comment: Oracle 12c DG，error：ORA-19815: WARNING: db_recovery_file_dest_size of 3145728000 bytes is 96.92% used, and has 96872960 remaining bytes available.