Re: ORA-19804: cannot reclaim nnnnnnn bytes disk space from nnnnnnnnnn limit
From: sandeep pande <sandy.soft80_at_gmail.com>
Date: Tue, 11 May 2010 02:19:04 -0700 (PDT)
Message-ID: <39820093-6ec4-473c-936b-be559e4685b4_at_u3g2000prl.googlegroups.com>
On Mar 25, 3:57 pm, moongeegee <moongee..._at_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.
Date: Tue, 11 May 2010 02:19:04 -0700 (PDT)
Message-ID: <39820093-6ec4-473c-936b-be559e4685b4_at_u3g2000prl.googlegroups.com>
On Mar 25, 3:57 pm, moongeegee <moongee..._at_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
Received on Tue May 11 2010 - 04:19:04 CDT