一次在RAC下,修改参数后的PFILE,SPFILE转换日志

来源:互联网 发布:打印五线谱软件 编辑:程序博客网 时间:2024/03/29 19:28
SQL> alter system set db_recovery_file_dest_size=2G scope=both;
alter system set db_recovery_file_dest_size=2G scope=both
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use


SQL> show parameter spfile;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
spfile                     string
SQL> create spfile='+DATA/racdb/spfileracdb.ora' from pfile;

File created.

SQL> show parameter spfile;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
spfile                     string
SQL> alter system set db_recovery_file_dest_size=2G scope=both;
alter system set db_recovery_file_dest_size=2G scope=both
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE is in use



SQL> create spfile='+DATA/racdb/spfileracdb.ora' from pfile='/opt/app/oracle/product/11.2.0/dbs/initracdb1.ora';

File created.


先生成一个SPFILE

SQL> show parameter recovery;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     +RECOVERY
db_recovery_file_dest_size         big integer 2G
recovery_parallelism             integer     0
SQL> show parameter spfile;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
spfile                     string     /opt/app/oracle/product/11.2.0
                         /dbs/spfileracdb1.ora
SQL> alter system set db_recovery_file_dest_size=2G scope=both;

System altered.

再用生成的SPFILE 生成一个PFILE,

SQL> create pfile from spfile;

File created.

SQL> create spfile='+DATA/racdb/spfileracdb.ora' from pfile='/opt/app/oracle/product/11.2.0/dbs/initracdb1.ora';

File created.

SQL>

SQL> alter system set db_recovery_file_dest_size=2G scope=both;

System altered.

后面可以把/opt/app/oracle/product/11.2.0/dbs/initracdb1.ora
修改为以下内容:
spfile='+DATA/racdb/spfileracdb.ora'

指定到共享ASM里的spfile


原创粉丝点击