how to change the location of db_recovery_file_dest
i have tried to alter system set db_recovery_file_dest='/oradata/fast_recovery_area' scope=spfile;
and when i do the
show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string
db_recovery_file_dest_size big integer 10G
all the files go to $ORACLE_HOME/dbs and i dont want them there HELP HELP how can i change it so it goes to '/oradata/fast_recovery_area
this is oracle 11G on linux