flash_recovery_area size reporting
obakesan
I had a little whoopsie yesterday on my test database (10.2.0.1.0) with the
db_recovery_file_dest becomming full and me getting the following message in
my alert log:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00%
used, and has 0 remaining bytes available.
well, I recovered from this but thought it might make a good exersize to
explore. This leads me to a question about how it knows how much is in there.
Because my first attempt to "fill the area" used a simple ploy to increase the
amount held in $ORACLE_HOME/flash_recovery_area/$SID by just poking
some file in there with
dd if=/dev/zero of=$ORACLE_HOME/flash_recovery_area/$SID
this failed to have any impact on the system operation. So clearly the system
is not looking at the OS but only its own repository / catalog.
I would like to understand this more, for example to know which views I may be
able to query or how to best explore the system to understand this (as EM is
not the easiest tool to work with for this issue)
thanks :-)
See Ya
(when bandwidth gets better ;-)
Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat
blog: http://cjeastwd.blogspot.com/
please remove undies for reply
Cristian Cudizio
The content of FRA is managed by oracle and it is supposed you don't
write
manually anything into. V$FLASH_RECOVERY_AREA_USAGE
shows you contents occupation by type
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1110.htm#I1030377
Regards,
Cristian Cudizio
obakesan
In article
<aa5b18ad-61c7-4290...@d45g2000hsc.googlegroups.com>, Cristian
Cudizio <cristian...@yahoo.it> wrote:
>> I had a little whoopsie yesterday on my test database (10.2.0.1.0) with t=
[snip]
>> I would like to understand this more, for example to know which views I m=
>The content of FRA is managed by oracle and it is supposed you don't
>write manually anything into.
I guessed, but it was a quick n dirty :-)
>V$FLASH_RECOVERY_AREA_USAGE shows you contents occupation by type
bewdy ! Thanks!!
>http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_111=
>0.htm#I1030377
another good point ... thanks heaps :-)
Kind Reguards from Finland
(Sunny Suomi)