ORA-19815

if you are backing up to DB_RECOVERY_FILE_DEST_SIZE then you are using RMAN. Check the RMAN settings -

RMAN> show all;

How big is your flash recovery area (FRA)? How big is your backup ? How frequently are you running backups ?

Do this to report if there are obsolete backups you can remove -

Run the following sql to see if there is any space that is reclaimable -

SELECT * FROM V$RECOVERY_FILE_DEST;

If anything shows up under SPACE_RECLAIMABLE column go ahead and run the following -

RMAN> report obsolete;
RMAN> delete obsolete;

If after all this the space is still an issue, you can try this if you have a tape configured for RMAN. Dont forget to allocate channels before you run the command.

RMAN> backup recovery area;

With the above command you are backing up all the files in the FRA to tape.
This should mark the space occupied by the files in the FRA will be marked as reclaimable. And the files get deleted whenever any space is required for any new operation.

constantly check V$RECOVERY_FILE_DEST to check the reclaimable space.

If you need to immediately delete some old backups do the following -

RMAN > list backup summary;

pick the oldest dated keys and start deleting them -

RMAN > delete backupset {key};

Hi
Thanks for the response

yesterday i had increased the db_recovery_file_dest_size from 2GB to 8GB by "Alter system set db_recovery_file_dest_size = 8;" .But i found the same error(ora-19815) again while i ran the bkup.sh script.In this script i take export backup and tablespace backup.

As you have mentioned to run show all or other commands on RMAN> prompt.but following errors come.
******************************************************************************
RMAN> show all
2> ;

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 09/06/2006 11:59:27
RMAN-06171: not connected to target database
*****************************************************************************
But the SELECT * FROM V$RECOVERY_FILE_DEST query gives result like

Name-/oracle/app/flash_recovery_area
Space limit- 8
space used -2147369472
space reclamaible- 0
number of files -91

I'm in confusion. Pls do write to me..

rgds
prasant

Prasant, You seem to be using recovery catalog. Connect to it first.

rman> connect target;
rman> connect catalog rmanuser/pass@catalogdb
rman> show all;

And I dont think you increased the size of your FRA. You actually set it to 8 bytes not 8GB. Check the numbers showing up in the resultset for the query.

The correct syntax - Alter system set db_recovery_file_dest_size = 8G; but before you do this do you know you have enough space in the filesystem where this is located ?

Also from the result set it appears there is no space that can reclaimed. In other words the backups are all valid and still within your retention time period. Once you get the SHOW ALL to work you will know what the retention period is.

Also can you tell if you have RMAN configured to backup to tape on your system ? if so backup the recovery area first. Check my previous posts for syntax.

Thanks Techji

You are right.i had set the size to 8byes. i made it 8G again. now it doesn't show any error during hotbackup.

Secondly what you had written "connect target" was accepted in rman> prompt.
But i'm not sure about the rmanuser and password and catalogdb details.
i ran the query "select * from dba_users".but no user like "rman" i found in the result set.
please be elaborate on it.
thanks
Prasant