Archive for April 12th, 2008

RAC安装之数据库创建

Saturday, April 12th, 2008

手工创建RAC数据库其实和普通数据库没有太大区别,需要注意几点:
1.需要为各个接点额外创建undo tablespace,redo group
2.需要为各个接点激活日志thread
3.create database的时候cluster_database参数设置为false,创建成功后在改为true,让各个接点mount
–创建数据库
SQL> CREATE DATABASE asmrac
  2     USER SYS IDENTIFIED BY a35baba
  3     USER SYSTEM IDENTIFIED BY a35baba
  4     controlfile reuse
  5     LOGFILE
  6     GROUP 1 (’+DATATOMB/redo_1_1_1.log’,’+DATATOMB/redo_1_2_1.log’) SIZE 512M REUSE,
  7     GROUP 2 (’+DATATOMB/redo_2_1_1.log’,’+DATATOMB/redo_2_2_1.log’) SIZE 512M REUSE,
  8     GROUP 3 (’+DATATOMB/redo_3_1_1.log’,’+DATATOMB/redo_3_2_1.log’) SIZE 512M REUSE,
  9     GROUP 4 (’+DATATOMB/redo_4_1_1.log’,’+DATATOMB/redo_4_2_1.log’) SIZE 512M REUSE
 10     MAXLOGFILES 64
 11     MAXLOGMEMBERS [...]

Posted in 大话技术 | 3 Comments »

RAC安装之创建ASM

Saturday, April 12th, 2008

–编辑ASM的init.ora
myasm1.instance_number=1
myasm2.instance_number=2
myasm3.instance_number=3
myasm4.instance_number=4
myasm1.instance_name=myasm1
myasm2.instance_name=myasm2
myasm3.instance_name=myasm3
myasm4.instance_name=myasm4
instance_type=asm
cluster_database=true
asm_diskgroups=’datatomb’
asm_diskstring=’/opt/oracle/oradata/asmrac/disk*’
processes=200
large_pool_size=12M
remote_login_passwordfile=exclusive
core_dump_dest=/opt/oracle/admin/myasm/cdump
user_dump_dest=/opt/oracle/admin/myasm/udump
background_dump_dest=/opt/oracle/admin/myasm/bdump
export ORACLE_SID=myasm3
SQL> startup nomount;
ASM instance started
Total System Global Area  130023424 bytes
Fixed Size                  2019032 bytes
Variable Size             102838568 bytes
ASM Cache                  25165824 bytes
–ASM已经discover了指定的磁盘,状态为CANDIDATE
SQL> select header_status, path from v$asm_disk;
HEADER_ST PATH
——— ————————————————–
CANDIDATE    /opt/oracle/oradata/asmrac/disk2
CANDIDATE    /opt/oracle/oradata/asmrac/disk1
–创建磁盘组datatomb,不使用镜像
SQL> create diskgroup datatomb
  2  external redundancy disk
  3  ‘/opt/oracle/oradata/asmrac/disk1′,
  4  ‘/opt/oracle/oradata/asmrac/disk2′;
Diskgroup created.
–disk状态已经是member
SQL> select header_status, path from v$asm_disk;
HEADER_ST PATH
——— ————————————————–
MEMBER    /opt/oracle/oradata/asmrac/disk2
MEMBER    /opt/oracle/oradata/asmrac/disk1
–1T的空间
SQL> select TOTAL_MB,free_mb from v$asm_diskgroup;
  TOTAL_MB    [...]

Posted in 大话技术 | No Comments »

阿里巴巴DBA出品