ORACLE还原初始化参数

重置初始化参数
语法：
ALTER SYSTEM RESET parameter_name [SCOPE = MEMORY|SPFILE|BOTH] [SID= ‘sid’|’*’]
小布老师视频中提到:
alter system set fast_start_mttr_target=250;(修改初始化参数默认是scope=both)
但是当用reset进行初始化参数还原时却遇到问题!
SQL> alter system reset fast_start_mttr_target scope=both sid='*';
alter system reset fast_start_mttr_target scope=both sid='*'
*
ERROR at line 1:
ORA-32009: cannot reset the memory value for instance * from instance orcl
注解：
语法上说可以加both, 实际上不能BOTH，否则
ORA-32009: cannot reset the memory value for instance * from instance orcl
还原语法：
SQL> alter system reset fast_start_mttr_target scope=spfile sid='*';

System altered.