OraFAQ Forum: Backup & Recovery » ora-19809,ora-19804

Home » RDBMS Server » Backup & Recovery » ora-19809,ora-19804 (Oracel 10g Red Hat 4.1.2-41 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-19809,ora-19804 [message #461020]

Wed, 16 June 2010 02:42

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Hi

I am trying to take backup from RMAN using backup database skip offline skip readonly.
I got an error massage
ORA-19809: limit exceeded for recovery files & ORA-19804.
Then I queried
-select name,floor(space_limit / 1024 / 1024) "Size MB"
2 ,ceil(space_used / 1024 / 1024) "Used MB"
3 from v$recovery_file_dest
4 order by name;
NAME Size MB Used MB
/u01/app/oracle/flash_recovery_area 2049 2048

Then I changed this parameter using alter system set db_recovery_file_dest_size=5059 scope=both;

but still error message is same.
Can u please help me out that how can I check how much size should I increase of db_recovery_file_dest_size and what to do.

Best Regards//
Neha

Report message to a moderator