db_recovery_file_dest_size设置

个人QQ 149196034 希望技术朋友家人！

今天一查看alert.log,发现归档日志很多，db_recovery_file_dest_size设置是初始值2G，used 100%

DELETE EXPIRED commands.
system command was used to delete files, then use RMAN CROSSCHECK and
4. Delete unnecessary files using RMAN DELETE command. If an operating
reflect the new space.
3. Add disk space and increase db_recovery_file_dest_size parameter to
BACKUP RECOVERY AREA command.
2. Back up files to tertiary device such as tape using RMAN
then consider changing RMAN ARCHIVELOG DELETION POLICY.
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
You have following choices to free up space from flash recovery area:

ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 95.81% used, and has 90079232 remaining bytes availab
le.

1：db_recovery_file_dest_size目录

SQL> show parameter db_recovery
;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle/flash_recovery_area
db_recovery_file_dest_size big integer 2G
SQL> SP2-0223: No lines in SQL buffer.
SQL> alter system set db_recovery_file_dest_size=4096m;

System altered.

SQL> show parameter db_recovery

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

alter tablespace system add datafile '/oracle/oradata/zxhs/system02.dbf' size 4096m;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22934571/viewspace-1040631/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22934571/viewspace-1040631/