Prev: Oracle Materialized Views in a RAC
Next: Streams Replication: Is Supplemental logging mandatory?
From: sandeep pande on 11 May 2010 05:19
On Mar 25, 3:57 pm, moongeegee <moongee...(a)gmail.com> wrote:
> I have a windowsXP with Oracle 10g installed and using RMAN backup.
> I got an error as below, someone set the RMAN backup before I take
> over this project. I am still learning how to use RMAN, but I need to
> resolve
> the problem. Please help.
> ORA-19804: cannot reclaim nnnnnnnnn bytes disk space from nnnnnnnnnnnn
> limit
>
> I have a lot of free disk space, but still got an error as above.
>
> The 10g version I have as below:
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
> PL/SQL Release 10.2.0.1.0 - Production
> "CORE 10.2.0.1.0 Production"
> TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
> NLSRTL Version 10.2.0.1.0 - Production
>
> each time I got an error as ORA-19804, then I need to manually delete
> some backup files in FLASH_RECOVERY_AREA that is in my
> C drive. However, I have plenty of disk space in my C drive.

Hi,
increase the flash recovery area size default 2gb.

alter system set db_recovery_file_dest_size=<size> scope=both

Regards
Sandy
 | 
Pages: 1
Prev: Oracle Materialized Views in a RAC
Next: Streams Replication: Is Supplemental logging mandatory?