有些參數在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; ================> 可以修改    
創作者介紹

香蕉皮

香 香蕉皮 發表在 痞客邦 PIXNET 留言(0) 人氣()