ITPub博客

首页 > Linux操作系统 > Linux操作系统 > vmware server 2.0安装oracle10grac之迁移ASM spfile至共享设备

vmware server 2.0安装oracle10grac之迁移ASM spfile至共享设备

原创 Linux操作系统 作者:xuelu2000 时间:2012-02-14 18:02:57 0 删除 编辑
Moving ASM spfile to a shared device in RAC
If using pfile, it must be a filesystem file on local filesystem.
If using spfile, then it can be in the following locations.
-- a filesystem file spfile on local filesystem
-- spfile on shared device
-- a ASM file in a ASM diskgroup (only for spfile for DB instances before 11.2)
Trying to put ASM spfile on a shared device.
Solution
Here are steps to put ASM spfile on a shared device.
1. Edit the pfile and make sure all the parameters could be used for all instances.
2. Login to ASM with sqlplus and startup nomount with pfile.
3. Run the following commands
SQL> create spfile= from pfile;
SQL> Shutdown immediate
--此处的,应用单引号标注,比如裸设备而言——'/dev/raw/raw6'
4. Backup the pfile to a new filename.
5. Modify the pfile to have only the following entry.
spfile=
--此处的,应用单引号标注,比如裸设备而言——'/dev/raw/raw6'

6. Do step 4 and 5 on remote nodes.
7. Startup the instances on all nodes with sqlplus to see if it works.
8. If all works, update the OCR ASM registry to have the new spfile location with srvctl command.
Usage: srvctl modify asm -n -i [-o ] [-p ]
-n Node name
-i ASM instance name
-o ORACLE_HOME path
-p Server parameter file path
--对于oracle 10.2.0.1而言,-o选项是无效的。实际实施时,直接去掉-o选项即可。
--另外,此处存在一个疑问:如果想将ASM实例从spfile恢复回pfile,如何更新OCR ASM registry???

9. Repeat step 8 for all nodes.
10. Test instance startup with srvctl on all nodes.
From Oracle

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/95233/viewspace-716284/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-23

  • 博文量
    89
  • 访问量
    237145