1 2 Previous Next 17 Replies Latest reply: Dec 3, 2012 1:27 PM by user12004297 RSS

    how to change the location of db_recovery_file_dest

    user12004297
      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