Oracle rac安裝過程詳解(九)
2024-08-29 13:36:22
供稿：網(wǎng)友
創(chuàng)建并啟動(dòng)多個(gè)instance
在啟動(dòng)多個(gè)instance前,需要為每個(gè)instance增加一個(gè)undo tablespace, 并增加一組 redo logfile.
SQL>CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u02/oradata/rac/rac/undotbs02.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE 1000M;
SQL>CREATE 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>
然后就可以啟動(dòng)多個(gè)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>
然后再啟動(dòng)rac3.
注重:
假如SGA配置太大,啟動(dòng)多個(gè)instance可能會(huì)死機(jī).
在出現(xiàn)Database mounted.后,到Database opened.可能會(huì)要一段時(shí)間,請(qǐng)耐心等待.
可以用以下語句查詢,確認(rèn)多個(gè)instance已經(jīng)啟動(dòng).
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;
