Home » RDBMS Server » Backup & Recovery » ora-19809,ora-19804 (Oracel 10g Red Hat 4.1.2-41 )
ora-19809,ora-19804 [message #461020] Wed, 16 June 2010 02:42 Go to next message
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
Re: ora-19809,ora-19804 [message #461457 is a reply to message #461020] Fri, 18 June 2010 02:35 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
Hello

Can anyone reply on my post???
thanks.
Re: ora-19809,ora-19804 [message #462147 is a reply to message #461457] Wed, 23 June 2010 01:01 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
PLEASE REPLY
Re: ora-19809,ora-19804 [message #462267 is a reply to message #462147] Wed, 23 June 2010 05:51 Go to previous message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
PLEASE REPLY
Previous Topic: RMAN copy / merge Incrementals
Next Topic: ORA-06553: PLS-553: character set name is not recognized
Goto Forum:
  


Current Time: Sat Nov 29 00:29:38 CST 2014

Total time taken to generate the page: 0.08679 seconds