ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 创建ASM数据库

创建ASM数据库

原创 Linux操作系统 作者:keeptrying 时间:2012-04-24 13:38:57 0 删除 编辑

一、配置ASM

1、使用ASMTOOL创建磁盘

C:\Users\Administrator>asmtool 

ASM-00200: Invalid command option

ASM-00208: asmtool -add [-force] \Device\Harddisk1\Partition1 ORCLDISKasm0 ...

ASM-00209: asmtool -addprefix asm [-force] \Device\Harddisk1\Partition1 ...

ASM-00210: asmtool -create \\server\share\file

ASM-00211: asmtool -delete ORCLDISKasm0 [ORCLDISKasm1 ...]

ASM-00212: asmtool -list [ORCLDISKasm0 ORCLDISKasm1 ...]

=======================================================================

 

C:\Users\Administrator>asmtool -create E:\asmdisk\DISK1 1024   --使用asmtool创建disk1

 

使用操作系统复制disk1,重命名为disk2disk3(使用操作系统复制比使用asmtool直接创建要快),这样现在有三块磁盘disk1disk2disk3

 

2、配置oracle集群同步服务(CSS

C:\Users\Administrator>localconfig

usage:  crssetup

                         | ladd | shutdown | upgrade | help>

                  config   - configure and startup the cluster on nodes

                  add      - add specified nodes to the cluster

                  del      - delete the specified nodes from the cluster

                  deconfig - wipe out all cluster configuration information

                  ldel     - local css delete from oracle home

                  lres     - local css home reset to new oracle home

                  ladd     - local css add to oracle home

                  shutdown - shutdown the selected nodes

                  upgrade  - upgrade the specified nodes

                  help     - print out this information

=================================================================

 

C:\Users\Administrator>localconfig add

Step 1:  creating new OCR repository

Successfully accumulated necessary OCR keys.

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

Operation successful.

Step 2:  creating new CSS service

successfully created local CSS service

successfully added CSS to home

 

3、  使用DBCA配置自动存储管理(ASM

1)、DBCA步骤1

asm参数:asm_diskstringE:\asmdisk\*

完成步骤一,+ASM实例已经创建完成。此时使用sqlplus连接实例。

C:\Users\Administrator>set oracle_sid=+asm

 

C:\Users\Administrator>sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Apr 24 11:59:52 2012

 

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options

 

SYS@ +asm > select path from v$asm_disk;          --查询结果为空。必须完成下面的步骤

 

no rows selected

2)、要使用文件代替磁盘,此处必须修改一个参数_asm_allow_only_raw_disks

SYS@ +asm > alter system set "_asm_allow_only_raw_disks"=false scope=spfile;

 

System altered.

SYS@ +asm > shutdown immediate

ORA-15100: invalid or missing diskgroup name

 

 

ASM instance shutdown

SYS@ +asm > startup

ASM instance started

 

Total System Global Area   83886080 bytes

Fixed Size                  1289028 bytes

Variable Size              57431228 bytes

ASM Cache                  25165824 bytes

ORA-15110: no diskgroups mounted

 

SYS@ +asm > select path from v$asm_disk;     --现在可以查看到创建的三块磁盘!

 

PATH

----------------------------------------

E:\ASMDISK\DISK1

E:\ASMDISK\DISK3

E:\ASMDISK\DISK2

3)、DBCA步骤2,创建磁盘组

dg1:常规(normal)冗余,disk1disk2,存放数据库

dg2:外部(external)冗余,disk3,存放闪回恢复区

 

二、创建数据库

使用DBCA创建数据库,数据库使用dg1,闪回恢复区使用dg2

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25744374/viewspace-722105/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-04-25

  • 博文量
    130
  • 访问量
    908659