Oracle rac安装过程详解(九)

王朝oracle·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

创建并启动多个instance

在启动多个instance前,需要为每个instance增加一个undo tablespace, 并增加一组 redo logfile.

SQLCREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u02/oradata/rac/rac/undotbs02.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE 1000M;

SQLCREATE UNDO TABLESPACE UNDOTBS3 DATAFILE '/u02/oradata/rac/rac/undotbs03.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE 1000M;

SQL ALTER DATABASE ADD LOGFILE THREAD 2 '/u02/oradata/rac/rac/redo2_1.log' SIZE 10M;

SQL ALTER DATABASE ADD LOGFILE THREAD 2 '/u02/oradata/rac/rac/redo2_2.log' SIZE 10M;

SQL ALTER DATABASE ADD LOGFILE THREAD 3 '/u02/oradata/rac/rac/redo3_1.log' SIZE 10M;

SQL ALTER DATABASE ADD LOGFILE THREAD 3 '/u02/oradata/rac/rac/redo3_1.log' SIZE 10M;

SQL

然后就可以启动多个instance了.

$ eXPort Oracle_SID=rac2

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - ProdUCtion on Fri Nov 21 15:11:16 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL conn / as sysdba;

Connected to an idle instance.

SQL startup pfile=/u01/app/oracle/product/9.2.0.4.0/dbs/initrac.ora

ORACLE instance started.

Total System Global Area 38867968 bytes

Fixed Size 451584 bytes

Variable Size 33554432 bytes

Database Buffers 4194304 bytes

Redo Buffers 667648 bytes

Database mounted.

Database opened.

SQL

然后再启动rac3.

注重:

假如SGA配置太大,启动多个instance可能会死机.

在出现Database mounted.后,到Database opened.可能会要一段时间,请耐心等待.

可以用以下语句查询,确认多个instance已经启动.

SQL select inst_id, instance_number inst_no, instance_name inst_name,

2 parallel, status, database_status db_stat, active_state stat, host_name

3 from gv$instance;

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航