백업&복구 19번째 ASM 인스턴스설치하기(10g설치, 패치설치, ASM설정, DB설치포함)

1. ORACLE설치 이전 환경설정
ORACLE설치 환경설정은 http://gyh214.tistory.com/36 을 참조하세요 

2. ORACLE 설치하기 (10g, OUI로 설치합니다)

3. ORACLE patch설치하기(10.2.0.5)
( 파일준비는 http://gyh214.tistory.com/36 참조하세요, OUI로 깔 것이기 때문에 rsp파일은 만들지마세요 )

4. ASM생성  << 요거랑 다음 단계가 포인트입니다.

대략적인 단계
1) 추가한 디스크를 LVM으로 파티셔닝(fdisk)
2) 파티셔닝된 디스크들을 1개의 물리그룹으로 만듬(pvcreate)  (한개의 논리적 디스크로 만드는 과정입니다.)
3) 만들어진 1개의 물리그룹(논리적디스크)을 1개의 논리그룹으로 생성합니다(vgcreate)
4) 1개의 논리그룹을 여러개(여기서는 DATA, FRA 2개) 의 논리 볼륨으로 나눔(lvcreate)

4-1. power off한다음에 디스크추가하기
2G 5개추가하고, 나중에 백업실습용으로 20G짜리 하나 추가하겠습니다.
(20G짜리는 당장에는 쓰지 않으므로 추가만하고 별다른 설정은 하지 않습니다..)

4-2. 재부팅 후 5개의 디스크를 Linux LVM(8e)으로 파티션 작업합니다.

4-3. 여러개의 디스크를 1개의 물리그룹으로 매핑합니다.(pvcreate)

[root@database ~]# pvcreate /dev/sdc1 /dev/sdd1 /dev/sde1 /dev/sdf1 /dev/sdg1

  Physical volume "/dev/sdc1" successfully created

  Physical volume "/dev/sdd1" successfully created

  Physical volume "/dev/sde1" successfully created

  Physical volume "/dev/sdf1" successfully created

  Physical volume "/dev/sdg1" successfully created

4-4. 만들어진 물리그룹을 1개의 논리그룹으로 만듭니다.(vgcreate)

[root@database ~]# vgcreate asm /dev/sdc1 /dev/sdd1 /dev/sde1 /dev/sdf1 /dev/sdg1

  Volume group "asm" successfully created

4-5. 만들어진 논리그룹을 2개의 논리볼륨으로 나눕니다.
(ASM1에 DB설치하고, FRA1에 flashback정보를 저장합니다)

[root@database ~]# lvcreate -L 7.5G -n asm1 asm

  Logical volume "asm1" created

[root@database ~]# lvcreate -L 2.4G -n fra1 asm

  Rounding up size to full physical extent 2.40 GB

  Logical volume "fra1" created

[root@database ~]# lvscan

  ACTIVE            '/dev/asm/asm1' [7.50 GB] inherit

  ACTIVE            '/dev/asm/fra1' [2.40 GB] inherit

4-6. ASM lib(rary)설치하기

http://www.oracle.com/technetwork/topics/linux/asmlib/index-101839.html  
에서 OS버전에 맞게 다운로드합시다

[root@database ~]# uname -nr

database 2.6.9-34.ELsmp
http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel4-092650.html   

http://oss.oracle.com/projects/oracleasm/dist/files/RPMS/rhel4/x86/2.0.5/2.6.9-34.EL/oracleasm-2.6.9-34.ELsmp-2.0.5-1.el4.i686.rpm
http://oss.oracle.com/projects/oracleasm-support/dist/files/RPMS/rhel4/x86/2.1.7/oracleasm-support-2.1.7-1.el4.i386.rpm
http://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.4-1.el4.i386.rpm 

(위의 링크는 RHEL4, 2.6.9-34.ELsmp버젼, Intel IA32 (x86) Architecture 에 맞게 다운받는 것입니다.)
(기본적으로 위 처럼 3가지를 다운받아야합니다.oracleasm, oracleasm-support, oracleasmlib)
RHEL5 2.6.18-128.el5(x86) : 

RHEL5-2.6.18-128.el5.zip

다운받은 후 rpm 설치해줍니다.

[root@database download]# ls

oracleasm-2.6.9-34.ELsmp-2.0.5-1.el4.i686.rpm  oracleasmlib-2.0.4-1.el4.i386.rpm

oracleasm-support-2.1.7-1.el4.i386.rpm

[root@database download]# rpm -Uvh *

경고: oracleasm-support-2.1.7-1.el4.i386.rpm: V3 DSA signature: NOKEY, key ID b38a8516

준비 중...               ########################################### [100%]

   1:oracleasm-support      ########################################### [ 33%]

   2:oracleasm-2.6.9-34.ELsm########################################### [ 67%]

   3:oracleasmlib           ########################################### [100%]

4-7. ASM라이브러리 환경설정
(1)

[root@database ~]# /etc/init.d/oracleasm configure

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

driver.  The following questions will determine whether the driver is

loaded on boot and what permissions it will have.  The current values

will be shown in brackets ('[]').  Hitting <ENTER> without typing an

answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle

Default group to own the driver interface []: dba

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver:                     [  OK  ]

Scanning the system for Oracle ASMLib disks:               [  OK  ]

(2)

[root@database ~]# /etc/init.d/oracleasm enable

Writing Oracle ASM library driver configuration: done

Initializing the Oracle ASMLib driver:                     [  OK  ]

Scanning the system for Oracle ASMLib disks:               [  OK  ]

[root@database ~]# /etc/init.d/oracleasm start

Initializing the Oracle ASMLib driver:                     [  OK  ]

Scanning the system for Oracle ASMLib disks:               [  OK  ]

4-8. ASM disk를 생성합니다.

root@database ~]# /etc/init.d/oracleasm createdisk asm1 /dev/asm/asm1

Marking disk "asm1" as an ASM disk:                        [  OK  ]

[root@database ~]# /etc/init.d/oracleasm createdisk fra1 /dev/asm/fra1

Marking disk "fra1" as an ASM disk:                        [  OK  ]

4-9. CSS데몬을 활성화합니다.

[root@database ~]# /home/oracle/product/10g/bin/localconfig add

/etc/oracle does not exist. Creating it now.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

Configuration for local CSS has been initialized

Adding to inittab

Startup will be queued to init within 30 seconds.

Checking the status of new Oracle init process...

Expecting the CRS daemons to be up within 600 seconds.

CSS is active on these nodes.

        database

CSS is active on all nodes.

Oracle CSS service is installed and running under init(1M)

4-10. DBCA로 asm인스턴스를 생성합니다.
(5단계에서 계속)


5. DBCA로 ASM인스턴스생성하기
$ dbca

완료!!