案例:Oracle数据库10g中释放flash_recovery_area解决ORA-19815错误。
错误现象:备份Oracle数据库10g时出现下面的错误:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100。
00% used, and has 0 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。
*************************************************************
此时flash_recovery_area已经手工释放空间,即使切换到一个全新的磁盘也无法解决此问题。
继续连接数据库的查询:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10。
1。0。2。0 - Production on Mon Mar 28 11:45:30 2005
Copyright (c) 1982, 2004, Oracle。 All rights reserved。
全部