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

    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

      ------------------------------------ ----------- ------------------------------
      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