Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to change the location of db_recovery_file_dest

user12004297Nov 13 2012 — edited Dec 3 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2012
Added on Nov 13 2012
17 comments
1,731 views