Thinking in Linux…

今天例行检查发现日志报如下错误：
Errors in file /opt/oracle/admin/abcd/bdump/abcd_arc1_30960.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 85.19% used, and has 318134784 remaining bytes available.
*************************************************************
You have the following choices to free up space from
flash recovery area:
1. Consider changing your RMAN retention policy.
If you are using dataguard, then consider changing your
RMAN archivelog deletion policy.
2. Backup files to tertiary device such as tape using the
RMAN command BACKUP RECOVERY AREA.
3. Add disk space and increase the db_recovery_file_dest_size
parameter to reflect the new space.
4. Delete unncessary files using the RMAN DELETE command.
If an OS command was used to delete files, then use
RMAN CROSSCHECK and DELETE EXPIRED commands.
*************************************************************

SQL> show parameter recov;

NAME                                 TYPE
———————————— ———————-
VALUE
——————————
db_recovery_file_dest                string
/opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size           big integer
2G
recovery_parallelism                 integer
0

将db_recovery_file_dest_size大小修改为4G

SQL> alter system set db_recovery_file_dest_size=4G;

System altered.

SQL> show parameter recov;

NAME                                 TYPE
———————————— ———————-
VALUE
——————————
db_recovery_file_dest                string
/opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size           big integer
4G
recovery_parallelism                 integer
0