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>