Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to migrate spfile under ASM". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to migrate spfile under ASM".

There are two ways to apply How to move ASM spfile to a different disk group [ID 1082943.1] to 11R2: migration through intermediate files using create pfile/spflie, and spcopy command that comes with asmcmd. The first method is relatively simple, the steps are as follows: create pfile='/tmp/pfile+ASM.ora' from spfile;create spfile='+PLAY' from pfile='/tmp/pfile+ASM.ora' Crsctl stop hascrsctl start has-restart verification: let's introduce the spcopy command because GPnP profile records spfile path information. Copy spfile with-u option-to update GPnP profile in RAC environment$ asmcmd spget+DATA/asm/asmparameterfile/registry.253.722601213$ asmcmd lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Votin g_files NameMOUNTED EXTERN N 512 4096 1048576 14658 9814 0 9814 0 N DATA/MOUNTED EXTERN N 512 4096 1048576 9772 8507 08507 0 N PLAY/MOUNTED EXTERN N 512 4096 1048576 9772 9212 09212 0 N RECO/$ asmcmd spcopy-u + DATA/asm/asmparameterfile/registry.253.722601213 + PLAY/spfileASM.ora2. Restart the HA stack to verify that ASM starts up fine with copiedspfile$ crsctl stop hasCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on '... CRS-4133: Oracle High Availability Services has been stopped.$ crsctl start hasCRS-4123: Oracle High Availability Services has been started.$ asmcmd spget+PLAY/spfileASM.ora3. Remove the original spfile$ asmcmd ls-l + DATA/asm/asmparameterfileType Redund Striped Time Sys NameASMPARAMETERFILE UNPROT COARSE JUN 25 10:00:00 Y REGISTRY.253.722601213$ asmcmd rm + DATA/asm/asmparameterfile/registry.253.722601213NOTE: The disk group that holds ASM spfile has to have COMPATIBLE.ASM value of 11.2 or higher. Thank you for reading, the above is the content of "how to migrate spfile under ASM". After the study of this article, I believe you have a deeper understanding of how to migrate spfile under ASM, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.