This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Dec 3, 2012 11:27 AM by user12004297 RSS

how to change the location of db_recovery_file_dest

user12004297 Newbie
Currently Being Moderated
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
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points