close
有些參數在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; ================> 可以修改
範例: 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; ================> 可以修改
全站熱搜
留言列表