Home » RDBMS Server » Server Administration » ORA-19815: WARNING: db_recovery_file_dest_size
ORA-19815: WARNING: db_recovery_file_dest_size [message #148849] Mon, 28 November 2005 12:09 Go to next message
bmahireddy
Messages: 14
Registered: March 2005
Junior Member
Version: 10.1.0.3.0 on Solaris

During startup of database, its generating ORA-19815.
Have tried to clear-out(delete) the unwanted archived logs but still getting the warning. It should have considered the released space.
Any ideas (Did any one face the same problem)

Thanks,

*** SERVICE NAME:(SYS$BACKGROUND) 2005-11-28 11:42:31.205
*** SESSION ID:(155.1) 2005-11-28 11:42:31.205
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 96.53% used, and has 74465280 remaining bytes available.
*** 2005-11-28 11:42:31.205
*************************************************************
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.
*************************************************************
$ pwd


11/28/2005 11:51:04 AM Mahi>@param
Enter Prameter Name: db_recovery_file_dest

DEFAULT   SES_MODIF SYS_MODIFI MODIFIED   ADJUSTED  NAME                               VALUE
NUM TYPE
--------- --------- ---------- ---------- --------- ---------------------------------- -------------------------------------
--- ----
FALSE     FALSE     IMMEDIATE  FALSE      FALSE     db_recovery_file_dest              /u02/oradata/cg01/flash_recovery_area
479    2
FALSE     FALSE     IMMEDIATE  FALSE      FALSE     db_recovery_file_dest_size         2147483648
480    6

11/28/2005 11:51:04 AM Mahi>@archived_log


RMAN> show retention policy ;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;

RMAN>
Re: ORA-19815: WARNING: db_recovery_file_dest_size [message #148852 is a reply to message #148849] Mon, 28 November 2005 12:19 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is just a warning and mostly is related to flash recovery.
Did you try any of the provided choices?
Delete expired may help.

Previous Topic: ORA-00205 error, when installing oracle10g on linux
Next Topic: Oracle 9i - Error while adding passwords in DB creation
Goto Forum:
  


Current Time: Thu Feb 13 16:57:47 CST 2025