RAC修改spfile位置
RAC修改spfile位置
[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 8 22:36:39 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select status from gv$instance;
STATUS
------------------------
OPEN
OPEN
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_name string orcl
1.查看当前的DATABASE spfile 位置
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +ORCLDG/orcl/spfileorcl.ora
2.备份 pfile
[oracle@rac1 ~]$ cd $ORACLE_HOME/dbs
[oracle@rac1 ~]$ more initorcl1.ora
spfile='+ORCLDG/orcl/spfileorcl.ora'
[oracle@rac1 ~]$ cp initorcl1.ora initorcl1.orabak
3.重新在指定路径创建 spfile
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL> create pfile from spfile;
SQL> create spfile='+ORCL_FRA' from pfile;
4.查看新创建spfile位置
[oracle@rac1 ~]$ su - grid
[grid@yyzfrac1 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 6144 5218 2048 1585 0 Y OCRDG/
MOUNTED EXTERN N 512 4096 1048576 204800 204704 0 204704 0 N ORCLDG/
MOUNTED EXTERN N 512 4096 1048576 204800 204704 0 204704 0 N ORCL_FRA/
ASMCMD> cd ORCL_FRA
ASMCMD> ls
ORCL/
ASMCMD> cd orcl
ASMCMD> ls
CONTROLFILE/
PARAMETERFILE/
control01.ctl
control02.ctl
ASMCMD> cd PARAMETERFILE/
ASMCMD> ls
spfile.258.836345535
5.指定新的spfile别名
ASMCMD>mkalias +ORCL_FRA/ORCL/PARAMETERFILE/spfile.258.836345535 +ORCL_FRA/ORCL/spfileorcl.ora
6.用srvctl修改新的rac数据库spfile 位置
[oracle@yyzfrac2 dbs]$ srvctl modify database -d orcl -p +orcl_fra/orcl/spfileorcl.ora
7.删除原来的spfile
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL>alter diskgroup orcldg drop file '+orcldg/orcl/spfileorcl.ora';
8.分别在两个节点中更新initorcl1.ora initorcl2.ora
内容为spfile='+orcl_fra/orcl/spfileorcl.ora'
9.重新启动数据库
[oracle@rac1 ~]$srvctl stop database -d orcl
[oracle@rac1 ~]$srvctl start database -d orcl
10.在两节点查看spfile位置
SQL> set line 3000
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +ORCL_FRA/orcl/spfileorcl.ora
最新文章
- 四道简单DP
- Oracle补习班第五天
- [.NET自我学习]Delegate 泛型
- autotools工具使用记录
- .net reflector激活
- Hibernate核心思想—ORM机制(一)
- OpenGL ES 着色语言
- codevs 3123 高精度练习之超大整数乘法
- [HNOI2006]超级英雄Hero
- unix IO笔记
- C++ Primer 学习笔记_79_模板与泛型编程 --模板编译模型
- 27 自定义View小结
- (Android自定义View)来来来,一起再撸一个Material风格loadingView。
- 第一周——数据分析之表示 —— Numpy入门
- webveiw返回死循环问题以及在打开web页面会唤起浏览器打开的问题解决
- @Component注解的解析
- The logback manual #03# Configuration
- Codeforces 1076 E - Vasya and a Tree
- js加减运算·传参
- Git 学习之git 分支(三)