Mount ASM diskgroups with new ASM instance
Ref:
當ASM Disks 透過Storage Snapshot mirror 到異機去, 而異機上面沒有任何duplicated OS環境,
會需要透過一些特殊手法讓新安裝的Grid Infrastructure 認到ASM LUN Header, 進而掛載並讀取裡面的資料檔案
#Prerequisites
Install Grid Infrastructure required RPM, ASMLIB RPM
# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
# oracleasm listdisks
DISK1
DISK2
DISK3
DISK4
DISK5
FRA1
Install "Oracle Grid Infrastructure software only" option
After installation finished run noted perl script as root to configure Grid Infrastructure for a Stand-Alone server.
For my configuration script looks like this:
To configure Grid Infrastructure for a Stand-Alone Server run the following command as the root user:
/u01/app/11.2.0.1/grid/perl/bin/perl -I/u01/app/11.2.0.1/grid/perl/lib -I/u01/app/11.2.0.1/grid/crs/install /u01/app/11.2.0.1/grid/crs/install/roothas.pl
Start cssd if it's not running.
# ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE
ora.diskmon
1 OFFLINE OFFLINE
# ./crs_start ora.cssd
Attempting to start `ora.cssd` on member `asterix`
Attempting to stop `ora.diskmon` on member `asterix`
Stop of `ora.diskmon` on member `asterix` succeeded.
Attempting to start `ora.diskmon` on member `asterix`
Start of `ora.diskmon` on member `asterix` succeeded.
Start of `ora.cssd` on member `asterix` succeeded.
手動再 $GRID_HOME/dbs 下編輯init+ASM.ora
*.asm_diskstring='/dev/oracleasm/disks'
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
Register and start ASM instance.
$ export ORACLE_SID=+ASM
$ export ORACLE_HOME=/u01/app/11.2.0.1/grid
$ srvctl add asm -p $ORACLE_HOME/dbs/init+ASM.ora *註1
$ srvctl start asm
$ srvctl status asm
ASM is running on asterix
./asmca
Click "Mount all" to mount them all.
Install Oracle database software and create parameter file in "$ORACLE_HOME/dbs" to start database.
$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
$ export ORACLE_SID=ora11gr2
$ cd $ORACLE_HOME/dbs
$ cat initora11gr2.ora
*.spfile='+DATA1/ora11gr2/spfileora11gr2.ora'
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 29 14:29:37 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 668082176 bytes
Fixed Size 2216344 bytes
Variable Size 222301800 bytes
Database Buffers 436207616 bytes
Redo Buffers 7356416 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA1/ora11gr2/datafile/system.297.844627929
+DATA1/ora11gr2/datafile/sysaux.265.844627967
+DATA1/ora11gr2/datafile/undotbs1.266.844627991
+DATA1/ora11gr2/datafile/users.267.844628031
+DATA2/ora11gr2/datafile/marko.261.859213577
Database is successfully opened and you can register instance using SRVCTL command.
$ srvctl add database -d $ORACLE_SID -o $ORACLE_HOME -p $ORACLE_HOME/dbs/initora11gr2.ora
$ srvctl start database -d $ORACLE_SID
Final status.
$ ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
ONLINE ONLINE asterix
ora.DATA2.dg
ONLINE ONLINE asterix
ora.FRA1.dg
ONLINE ONLINE asterix
ora.asm
ONLINE ONLINE asterix Started
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE asterix
ora.diskmon
1 ONLINE ONLINE asterix
ora.ora11gr2.db
1 ONLINE ONLINE asterix Open
*註1
在12c Grid的環境要手動註冊ASM instance, 需指定ASM password file如下:
srvctl add asm -spfile +ORCL_DATA/asm/asmparameterfile/registry.253.917720447 -pwfile $ORACLE_HOME/dbs/orapw+ASM -diskstring '/dev/asmdisk/*'
srvctl add listener -l listener_ASM -o $ORACLE_HOME
srvctl start listener -l listener_ASM
srvctl config asm
ref:
https://vikasdba-bi.blogspot.tw/2017/06/upgrade-grid-infrastructure-11204-to.html
在12c Grid的環境要手動註冊ASM instance, 需指定ASM password file如下:
srvctl add asm -spfile +ORCL_DATA/asm/asmparameterfile/registry.253.917720447 -pwfile $ORACLE_HOME/dbs/orapw+ASM -diskstring '/dev/asmdisk/*'
srvctl add listener -l listener_ASM -o $ORACLE_HOME
srvctl start listener -l listener_ASM
srvctl config asm
ref:
https://vikasdba-bi.blogspot.tw/2017/06/upgrade-grid-infrastructure-11204-to.html
沒有留言:
張貼留言