How to resize flash_recovery_area
597676Apr 4 2008 — edited Apr 4 2008Hello,
I am a newbie in Oracle. Recently I created a DB instance and set up in archivelog mode with 2G flash_recovery_area. But now I reliazed 2G is too small for my DB. So I need to increase size. In SQL PLUS, I enter below command:
sql:> connect sys/password@sid as sysdba
sql:> alter system SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='*';
sql:> show parameter db_recovery_file_dest_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 10G
It looks like I increased flash_recovery_area size to 10GB. But in EM console, I goto Maintenance --> Configure Recovery Settings--> under Flash Recovery Area, it still shows size 2GB.
Does anyone can give me any advice? did I use wrong step?
Many thanks!