Oracle學習心得-參數檔(initialization parameter file)的修改 @ 香蕉皮

有些參數在PFILE模式是無法透過alter system的方式修改，需要直接改文字模式的參數檔

(1)參數檔為SPFILE型態
   範例: SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') AS "Init File Type", NVL(value,'null') AS Path
           2 FROM v$parameter WHERE name = 'spfile';
              Init File Type         PATH
              -------------------    -------------------------------------------------------
              SPFILE                 C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SPFILEORCL.ORA

   alter system set log_archive_start=true scope=spfile; ======> 可以修改
   alter system set log_archive_start=true scope=memory
   alter system set log_archive_start=true scope=both
   alter system set log_archive_start=true;

   alter system set fast_start_mttr_target=60 scope=spfile; ===> 可以修改
   alter system set fast_start_mttr_target=60 scope=memory ====> 可以修改
   alter system set fast_start_mttr_target=60 scope=both ======> 可以修改
   alter system set fast_start_mttr_target=60; ================> 可以修改

(2)參數檔為PFILE
   範例: SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') AS "Init File Type", NVL(value,'null') AS Path
           2 FROM v$parameter WHERE name = 'spfile';
              Init File Type         PATH
              -------------------    -------------------------------------------------------
              PFILE                  null

   alter system set log_archive_start=true scope=spfile;
   alter system set log_archive_start=true scope=memory
   alter system set log_archive_start=true scope=both
   alter system set log_archive_start=true;

   alter system set fast_start_mttr_target=60 scope=spfile;
   alter system set fast_start_mttr_target=60 scope=memory ====> 可以修改
   alter system set fast_start_mttr_target=60 scope=both
   alter system set fast_start_mttr_target=60; ================> 可以修改