一次在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'
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
- 一次在RAC下,修改参数后的PFILE,SPFILE转换日志
- oracle spfile pfile 参数修改
- RAC 修改 spfile 参数
- RAC 修改 spfile 参数
- RAC 修改 spfile 参数
- RAC 修改 spfile 参数
- RAC 修改 spfile 参数
- RAC 修改 spfile 参数
- Spfile、Pfile的修改相关
- Spfile、Pfile的修改相关
- rac模式下如何处理spfile文件参数故障(没有备份pfile)
- Oracle 的参数文件pfile与spfile
- oracle的参数文件 pfile和spfile
- oracle的参数文件 pfile和spfile
- oracle的参数文件:pfile和spfile
- [oracle]初始化参数文件spfile、pfile及修改参数的两种方式
- 11g RAC中pfile和spfile的使用总结
- pfile spfile静态和动态修改配置参数
- VC Progress onTimer
- csapp2e 家庭作业 4.46
- 二十三种设计模式笔记
- Cocos2d-x中Class的说明
- 原来学习的就是intel汇编呀
- 一次在RAC下,修改参数后的PFILE,SPFILE转换日志
- PPT资料下载 - 问题驱动的软件测试设计:强化测试用例设计
- 测试人员的承诺
- 记录下可以进行NAT的地址
- [C#基础教程之]C# 实现多线程的同步方法详解
- Eclipse十大常用快捷键
- [C#基础教程之]C#多线程详解
- linux系统性能优化及瓶颈分析
- Using WebSocket in .NET 4.5 (Part 1)