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'
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