Friday, September 9, 2011

fast_recovery_area in 11gR2, its only in docs for windows

I am reading "Oracle® Database 2 Day DBA 11g Release 2 (11.2)".

Realized that FLASH RECOVERY AREA is renamed to FAST RECOVERY AREA.
Check here: http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/install.htm#BABGFDAG

Many suggest that the reason behind this rename could be the confusion flash word causes with flashback feature.

Modifying the post to add:
I did 11gR2 install on windows. Below is what I see:
SQL> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      C:\oracle\flash_recovery_area
db_recovery_file_dest_size           big integer 3852M

Does that mean the name change of flash recovery area is done only in documentation?????

Then I went ahead and checked on Linux where I had done 11.2.0.2 install.
SQL> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /oracle/admin/fast_recovery_area
db_recovery_file_dest_size           big integer 49920M

This means Oracle developer who was supposed to make that change for windows platform FORGOT to do it. :-)