Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] db_recovery_file_dest_size

Martin Klier

2006-03-31

Replies:

Hi,

Am Freitag 31 März 2006 10:27 schrieb Sergey Yudin:
> db_recovery_file_dest_size= 21474836480
> ...
> db_recovery_file_dest_size of 20480 MB is 8.61% used. This is a
> user-specified limit on the amount of space that will be used by this
> database for recovery-related files, and does not reflect the amount of
> space available in the underlying filesystem or ASM diskgroup.
> Fri Mar 31 11:43:07 2006
>...
> Why does oracle complains "not reflect the amount of space available" ?
The message is no complaint, it's informational, and absolutely uncritical.

Oracle want to tell you, that you have set a limit
(db_recovery_file_dest_size), and Oracle has used 8.61% of it. But Oracle
does not know how much space there REALLY is available. This means, Oracle
has not implemented a df-like function into the db_recovery_file_dest_size
check routine.

Do not worry, keep an eye on your disk fill state, and all will be well.

Kind regards
--
Mit freundlichen Grüßen

i.A. Martin Klier
Systemadministration / Datenbanken
-----------------------------------------------------------------
A.T.U Auto-Teile-Unger
Handels GmbH & Co. KG
Dr.-Kilian-Straße 4
D-92637 Weiden i. d. OPf.
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.