ASM DB Startup / Shutdown Guide
ASM DB Startup / Shutdown Guide
Startup 절차는 CRS > ASM > DB 순서대로 Startup 하고,
Shutdown 절차는 DB > ASM > CRS 순서대로 Shutdown 하도록 한다.
CRS Startup
|
[root@asmdb /]# su - grid [grid@asmdb bin]$ ./crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.DATA.dg ora....up.type OFFLINE OFFLINE ora....ER.lsnr ora....er.type ONLINE ONLINE asmdb ora.asm ora.asm.type OFFLINE OFFLINE ora.asmdb.db ora....se.type OFFLINE OFFLINE ora.cssd ora.cssd.type ONLINE OFFLINE ora.diskmon ora....on.type ONLINE OFFLINE ora.evmd ora.evm.type ONLINE ONLINE asmdb ora.ons ora.ons.type OFFLINE OFFLINE [grid@asmdb bin]$ [grid@asmdb bin]$ ./crsctl start resource ora.cssd CRS-2672: Attempting to start 'ora.cssd' on 'asmdb' CRS-2672: Attempting to start 'ora.diskmon' on 'asmdb' CRS-2676: Start of 'ora.diskmon' on 'asmdb' succeeded CRS-2676: Start of 'ora.cssd' on 'asmdb' succeeded |
ASM Startup
|
[root@asmdb /]# su - grid [grid@asmdb bin]$ sqlplus '/as sysasm' SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 3 23:50:44 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance.
SQL> SQL> startup ASM instance started
Total System Global Area 284565504 bytes Fixed Size 1343692 bytes Variable Size 258055988 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL> |
DataBase Startup
|
[oracle@asmdb ~]$ sqlplus '/as sysdba' SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 3 23:51:43 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance.
SQL> SQL> startup ORACLE instance started.
Total System Global Area 849530880 bytes Fixed Size 1347480 bytes Variable Size 507510888 bytes Database Buffers 335544320 bytes Redo Buffers 5128192 bytes Database mounted. Database opened. |
DataBase Shutdown
|
[oracle@asmdb ~]$ sqlplus '/as sysdba' SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 3 23:53:02 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. |
ASM Shutdown
|
[grid@asmdb ~]$ sqlplus '/as sysasm' SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 3 23:54:03 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production With the Automatic Storage Management option
SQL> shutdown immediate; ASM diskgroups dismounted ASM instance shutdown |
CRS Shutdown
|
[root@asmdb /]# su - grid [grid@asmdb ~]$ crsctl stop resource ora.cssd CRS-2673: Attempting to stop 'ora.cssd' on 'asmdb' CRS-2677: Stop of 'ora.cssd' on 'asmdb' succeeded |
[참고] 유저 생성
※ DB Instance를 관리할 oracle 유저와 ASM Instance를 관리할 grid 유저를 생성한다.
|
groupadd –g 1000 oinstall groupadd –g 1100 dba groupadd –g 1200 oper groupadd –g 1300 asmadmin groupadd –g 1400 asmoper groupadd –g 1500 asmdba
useradd –g oinstall –G dba,asmdba,oper oracle useradd –g oinstall –G asmadmin,asmdba,asmoper,oper,dba grid |
출처: https://sanai200.tistory.com/57 [늅늅이의 시스템 운영 따라하기]