Java Mailing List Archive

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

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

[suse-oracle] db_recovery_file_dest_size

Sergey Yudin

2006-03-31

Replies:

I have init settings:

db_recovery_file_dest   = /u02/oradata
db_recovery_file_dest_size= 21474836480

After startup alert log contains:
.....
Starting background process QMNC
QMNC started with pid=29, OS id=6321
Fri Mar 31 11:42:08 2006
Completed: ALTER DATABASE OPEN
Fri Mar 31 11:42:08 2006
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
....

underlying filesystem has:

$ df -k /u02/oradata
Filesystem       1K-blocks    Used Available Use% Mounted on
/dev/md0         35529728  1823900 33705828  6% /u02
Press any key to continue...

Why does oracle complains "not reflect the amount of space available" ?



OS: SPES9-SP3-x64, filesystem: XFS

Oracle:
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE   10.2.0.2.0    Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

SQL>

With best regards...


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.