How to move ASM spfile to a different disk group [ID 1082943.1]
How to move ASM spfile to a different disk group [ID 1082943.1]
Goal
The goal is to move ASM spfile from one disk group to another.
During initial ASM setup the spfile might have been created in a default disk group (e.g. DATA). The requirement is now to move the ASM spfile to another disk group.
According to Oracle ASM documentation it should be possible to use 'asmcmd spmove' command to move ASM spfile:
Oracle Database Storage Administrator's Guide 11g Release 2 (11.2)
Section ASMCMD Instance Management Commands
Section ASMCMD Instance Management Commands
spmove
Purpose: Moves an Oracle ASM SPFILE from source to destination and automatically updates the GPnP profile.
But an attempt to move the ASM spfile fails as follows:
$ asmcmd spmove +DATA/asm/asmparameterfile/REGISTRY.253.715881237 +PLAY/spfileASM.ora
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DATA/asm/asmparameterfile/REGISTRY.253.715881237' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+DATA/asm/asmparameterfile/REGISTRY.253.715881237' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
Solution
To move ASM spfile to another disk group, either make use of intermediate pfile:
1.Create intermediate pfile from the current spfile
2.Create spfile in a new disk group from the intermediate pfile
3.Restart the HA stack to verify that ASM starts up fine with moved spfile
4.Remove the original spfile
2.Create spfile in a new disk group from the intermediate pfile
3.Restart the HA stack to verify that ASM starts up fine with moved spfile
4.Remove the original spfile
or use 'asmcmd spcopy' command
1.Copy spfile with -u option - to update GPnP profile in RAC environment
2.Restart the HA stack to verify that ASM starts up fine with copiedspfile
3.Remove the original spfile
This is an example of moving ASM spfile in a single instance environment, by making use intermediate pfile
2.Restart the HA stack to verify that ASM starts up fine with copiedspfile
3.Remove the original spfile
This is an example of moving ASM spfile in a single instance environment, by making use intermediate pfile
1. Create intermediate pfile from the current spfile
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL*Plus: Release 11.2.0.1.0 Production on
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> show parameter spfile
NAME TYPE VALUE
------- ------- --------------------------------------------------
spfile string +DATA/asm/asmparameterfile/registry.253.715881237
------- ------- --------------------------------------------------
spfile string +DATA/asm/asmparameterfile/registry.253.715881237
SQL> create pfile='/tmp/pfile+ASM.ora' from spfile;
File created.
2. Create spfile in a new disk group from the intermediate pfile
SQL> create spfile='+PLAY' from pfile='/tmp/pfile+ASM.ora';
File created.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
3. Restart the HA stack to verify that ASM starts up fine with moved spfile
$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ''
...
CRS-4133: Oracle High Availability Services has been stopped.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '
...
CRS-4133: Oracle High Availability Services has been stopped.
$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
CRS-4123: Oracle High Availability Services has been started.
Verify that the new spfile is being used
$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
SQL> show parameter spfile
NAME TYPE VALUE
------- ------- --------------------------------------------------
spfile string +PLAY/asm/asmparameterfile/registry.253.715963539
------- ------- --------------------------------------------------
spfile string +PLAY/asm/asmparameterfile/registry.253.715963539
SQL> select name, state from v$asm_diskgroup;
NAME STATE
----- -----------
DATA MOUNTED
PLAY MOUNTED
----- -----------
DATA MOUNTED
PLAY MOUNTED
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
The use of new spfile can also be verified with asmcmd as follows:
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option
The use of new spfile can also be verified with asmcmd as follows:
$ asmcmd spget
+PLAY/asm/asmparameterfile/registry.253.715963539
4. Remove the original spfile
+PLAY/asm/asmparameterfile/registry.253.715963539
4. Remove the original spfile
$ asmcmd rm +DATA/asm/asmparameterfile/registry.253.715881237
And this is an example of moving ASM spfile with 'asmcmd spcopy'
1. Copy spfile with -u option - to update GPnP profile in RAC environment
$ asmcmd spget
+DATA/asm/asmparameterfile/registry.253.722601213
+DATA/asm/asmparameterfile/registry.253.722601213
$ asmcmd lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Votin g_files Name
MOUNTED EXTERN N 512 4096 1048576 14658 9814 0 9814 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 9772 8507 0 8507 0 N PLAY/
MOUNTED EXTERN N 512 4096 1048576 9772 9212 0 9212 0 N RECO/
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Votin g_files Name
MOUNTED EXTERN N 512 4096 1048576 14658 9814 0 9814 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 9772 8507 0 8507 0 N PLAY/
MOUNTED EXTERN N 512 4096 1048576 9772 9212 0 9212 0 N RECO/
$ asmcmd spcopy -u +DATA/asm/asmparameterfile/registry.253.722601213 +PLAY/spfileASM.ora
2. Restart the HA stack to verify that ASM starts up fine with copiedspfile
2. Restart the HA stack to verify that ASM starts up fine with copiedspfile
$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ''
...
CRS-4133: Oracle High Availability Services has been stopped.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '
...
CRS-4133: Oracle High Availability Services has been stopped.
$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
CRS-4123: Oracle High Availability Services has been started.
$ asmcmd spget
+PLAY/spfileASM.ora
3. Remove the original spfile
+PLAY/spfileASM.ora
3. Remove the original spfile
$ asmcmd ls -l +DATA/asm/asmparameterfile
Type Redund Striped Time Sys Name
ASMPARAMETERFILE UNPROT COARSE JUN 25 10:00:00 Y REGISTRY.253.722601213
Type Redund Striped Time Sys Name
ASMPARAMETERFILE UNPROT COARSE JUN 25 10:00:00 Y REGISTRY.253.722601213
$ asmcmd rm +DATA/asm/asmparameterfile/registry.253.722601213
NOTE: The disk group that holds ASM spfile has to have COMPATIBLE.ASM value of 11.2 or higher.
NOTE: The disk group that holds ASM spfile has to have COMPATIBLE.ASM value of 11.2 or higher.
References
Oracle Database Storage Administrator's Guide 11g Release 2 (11.2), Chapter 3 Administering Oracle ASM Instances, Section Initialization Parameter Files for an Oracle ASM Instance
Oracle Database Storage Administrator's Guide 11g Release 2 (11.2), Section ASMCMD Instance Management Commands
Oracle Database Storage Administrator's Guide 11g Release 2 (11.2), Chapter 3 Administering Oracle ASM Instances, Section Initialization Parameter Files for an Oracle ASM Instance
Oracle Database Storage Administrator's Guide 11g Release 2 (11.2), Section ASMCMD Instance Management Commands
相關內容
--------------------------------------------------------------------------------
產品
--------------------------------------------------------------------------------
產品
--------------------------------------------------------------------------------
•Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
關鍵字
--------------------------------------------------------------------------------
ASM; AUTOMATIC STORAGE MANAGEMENT; DESTINATION; DISK GROUP; PFILE; SPFILE
錯誤
--------------------------------------------------------------------------------
ORA-15028; ORA-15032; CRS-2673; CRS-2791; CRS-2677; CRS-2793; CRS-4133; CRS-4123
關鍵字
--------------------------------------------------------------------------------
ASM; AUTOMATIC STORAGE MANAGEMENT; DESTINATION; DISK GROUP; PFILE; SPFILE
錯誤
--------------------------------------------------------------------------------
ORA-15028; ORA-15032; CRS-2673; CRS-2791; CRS-2677; CRS-2793; CRS-4133; CRS-4123
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-721538/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to Increase CSS Misscount in single instance ASM installations [ID 729878.1]CSSASM
- move linux os from disk A to disk B with 0 lossLinux
- Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’None
- ASM下遷移spfileASM
- 【ASM】ASM啟動無法找到spfile問題原因ASM
- how to move a MediaWiki wiki from one server to anotherServer
- 7.98 GROUP_ID
- How to Add a New Disk new partition in centos7CentOS
- 將spfile從ASM裡遷移到檔案系統ASM
- How To Turn SNMP On/Off ? [ID 472530.1]
- ORA-15020:discoverd duplicate ASM disk "XXX_CJCDB_OCR_0002"ASM
- Oracle OCP(13):GROUPING & GROUPING_ID & GROUP_ID & GROUPING SETSOracle
- What is OPAQUE_TRANSFORM Hint and how to Control it [ID 780503.1]OpaqueORM
- How to Collect Diagnostics for Database Hanging Issues (Doc ID 452358.1)Database
- 【CURSOR】How to Monitor and tune Open and Cached Cursors (Doc ID 1430255.1)
- 【ASM】ORA-27504 ORA-27300 ORA-27303 while starting ASM (Doc ID 2281441.1)ASMWhile
- How to redirect to a specific web page after sign out from Entra IDWeb
- How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1OracleGo
- 3.5 Different
- different random numbers generatorrandom
- 2.3.3.3.2 Applications at Different VersionsAPP
- 11.23 Two Different Worlds
- 2.4.8 Step 7: 建立spfile
- WPF mvvm canvas move elements via mouse down, up and move eventsMVVMCanvas
- NTFS Disk by Omi NTFS Mac;NTFS Disk by Omi NTFSMac
- CF1408F Two Different
- LeetCode—283—Move ZeroesLeetCode
- oracle 分割槽表move和包含分割槽表的lob moveOracle
- Script of Narrative Writing from different point of viewView
- 2.7.5 SPFILE初始化引數
- RAC環境修改spfile的位置
- [20201221]spfile設定問題.txt
- WPF Image zoomin zoomout moveOOM
- How to ssh
- 2.7.4 建立伺服器引數(SPFILE)伺服器
- alter table move與shrink space
- Office365 OneDrive Geo Move
- 12C 線上MOVE
- [20190706]Same dog, different leash – functions in SQL.txtFunctionSQL