It doesnt complain. Just an informational phrase..
Since the size set by db_recovery_file_dest_size does not at all
reflect the real size on the underlaying filesystem.
In your case you have only used 20Gb out of 33Gb for recovery file dest, and
those 20 Gb is monitored in alert_log, but not the underlying
filesystem itself..
/Morgan
--
--------------------------------------------------------
010011010110111101110010011001110110000101101110001000000101011101101001011001110110011101100101
--------------------------------------------------------
And for those of you that don't read binary:
--------------------------------------------------------
Morgan Wigge
On 3/31/06, Sergey Yudin <sergey@(protected):
> 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
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
