Oracle DataBase单实例迁移到Oracle RAC

 

Oracle DataBase单实例迁移到Oracle RAC步骤：

迁移前单实例环境介绍：

数据库版本：Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

数据库物理结构：

RMAN> report schema;

using target database control file instead of recovery catalog
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    440      SYSTEM               ***     /u01/app/oracle/oradata/orcl/system01.dbf
2    25       UNDOTBS1             ***     /u01/app/oracle/oradata/orcl/undotbs01.dbf
3    250      SYSAUX               ***     /u01/app/oracle/oradata/orcl/sysaux01.dbf
4    5        USERS                ***     /u01/app/oracle/oradata/orcl/users01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/orcl/temp01.dbf

RMAN>

 

主机环境

[oracle@rac1 admin]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6

192.168.2.101  rac1.localdomain   rac1
192.168.2.102  rac2.localdomain   rac2
192.168.0.101  rac1-priv.localdomain rac1-priv
192.168.0.102  rac2-priv.localdomain rac2-priv
192.168.2.103  rac1-vip.localdomain   rac1-vip
192.168.2.104  rac2-vip.localdomain   rac2-vip

[oracle@rac1 admin]$

 

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

1. 单节点数据库备份

注：单节点数据库的备份已经传送到/u02目录下，直接执行下面的解压即可。

[oracle@rac1 u02]$ cd /u02
[oracle@rac1 u02]$ tar zxvf backup_db.orcl.tar.gz
backup_db/
backup_db/ORCL_24_798936483_1_full_arch.bus
backup_db/ORCL_25_798936484_1_full_ctl.bus
backup_db/ORCL_26_798936485_1_full_spfile.bus
backup_db/ORCL_22_798936465_1_full_db.bus
backup_db/initorcl.ora
backup_db/ORCL_20_798936465_1_full_db.bus
backup_db/ORCL_21_798936465_1_full_db.bus
backup_db/ORCL_23_798936466_1_full_db.bus
backup_db/ORCL_19_798936465_1_full_arch.bus
[oracle@rac1 u02]$

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

mkdir -p /u02/backup_db/
chown oracle:dba /u02/backup_db/
chmod 770 /u02/backup_db/

rman target /

run{
allocate channel d1 type disk maxpiecesize=10G;
allocate channel d2 type disk maxpiecesize=10G;
allocate channel d3 type disk maxpiecesize=10G;
backup tag 'full_db_bk' filesperset 10
as compressed backupset database force noexclude
format '/u02/backup_db/%d_%s_%t_%p_full_db.bus'
plus archivelog delete all input
format '/u02/backup_db/%d_%s_%t_%p_full_arch.bus';

backup  current controlfile tag 'full_db_cntl' format '/u02/backup_db/%d_%s_%t_%p_full_ctl.bus';
backup  spfile tag 'full_db_spfile' format '/u02/backup_db/%d_%s_%t_%p_full_spfile.bus';

release channel d1;
release channel d2;
release channel d3;
}

SQL> create pfile from spfile;

[oracle@ocm18 dbs]$ cat initorcl.ora
orcl.__db_cache_size=432013312
orcl.__java_pool_size=8388608
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=159383552
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=201326592
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=605028352
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
[oracle@ocm18 dbs]$

 

2. RAC环境建立

在两个节点操作：
cd $ORACLE_BASE/admin
mkdir orcl
cd orcl/
mkdir -p adump  bdump  cdump  dpdump  hdump  pfile  scripts  udump

在节点1 操作：
[oracle@rac1 ~]$ cd $ORACLE_HOME/dbs
[oracle@rac1 dbs]$ orapwd file=orapworcl1 password=oracle
[oracle@rac1 dbs]$

在节点2 操作：
[oracle@rac2 ~]$ cd $ORACLE_HOME/dbs
[oracle@rac2 dbs]$ orapwd file=orapworcl2 password=oracle
[oracle@rac2 dbs]$

3. 修改初始化参数文件

[oracle@rac1 ~]$ cp /u02/backup_db/initorcl.ora  $ORACLE_HOME/dbs/initorcl1.ora

[oracle@rac1 dbs]$ vi $ORACLE_HOME/dbs/initorcl1.ora

添加:

*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO
orcl1.undo_tablespace=UNDOTBS1
orcl1.instance_name=orcl1
orcl1.instance_number=1
orcl1.thread=1
orcl1.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.72.101)(PORT=1521))'
orcl2.instance_name=orcl2
orcl2.instance_number=2
orcl2.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.72.102)(PORT=1521))'
orcl2.thread=2
orcl2.undo_tablespace=UNDOTBS2
orcl2.cluster_database = TRUE
orcl2.cluster_database_instances = 2

 

添加的参数可以参照下面的文档：

*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO
.undo_tablespace=undotbs (undo tablespace which already exists)
.instance_name=
.instance_number=1
.thread=1
.local_listener=_
.instance_name=
.instance_number=2
.local_listener=_
.thread=2
.undo_tablespace=UNDOTBS2
.cluster_database = TRUE
.cluster_database_instances = 2

is equal to "1". is equal to "2", e.g. ORCL1, ORCL2.

 

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

 

4.  将数据库由文件系统迁移到ASM

(1) 添加和修改初始化参数

查看存在的ASM磁盘组：

[oracle@rac1 dbs]$ export ORACLE_SID=+ASM1
[oracle@rac1 dbs]$ sqlplus / as sysdba

SQL> select name from v$asm_diskgroup;

NAME
------------------------------
DATA
FRA

SQL>

修改和添加初始化参数：

[oracle@rac1 dbs]$ vi $ORACLE_HOME/dbs/initorcl1.ora

将
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
变为
*.db_recovery_file_dest='+FRA'

添加：
*.db_create_file_dest='+DATA'

 

(2) 创建SPFILE

从pfile中清除 *.control_files，然后创建spfile

[oracle@rac1 dbs]$ vi $ORACLE_HOME/dbs/initorcl1.ora

删除control_files这一行

*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl/control03.ctl'

 

[oracle@rac1 dbs]$ export ORACLE_SID=orcl1

[oracle@rac1 dbs]$ sqlplus "/as sysdba"

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup nomount
ORACLE instance started.

Total System Global Area  608174080 bytes
Fixed Size                  1275128 bytes
Variable Size             163580680 bytes
Database Buffers          440401920 bytes
Redo Buffers                2916352 bytes
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@rac1 dbs]$

(3) 恢复数据库

[oracle@rac1 dbs]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Wed Nov 14 14:52:12 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: orcl (not mounted)

RMAN> restore controlfile from '/u02/backup_db/ORCL_25_798936484_1_full_ctl.bus';

Starting restore at 14-NOV-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=150 instance=orcl1 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
output filename=+DATA/orcl/controlfile/current.395.799339993
output filename=+FRA/orcl/controlfile/current.289.799339995
Finished restore at 14-NOV-12

RMAN>

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> report schema;

Starting implicit crosscheck backup at 14-NOV-12
allocated channel: ORA_DISK_1
Crosschecked 6 objects
Finished implicit crosscheck backup at 14-NOV-12

Starting implicit crosscheck copy at 14-NOV-12
using channel ORA_DISK_1
Finished implicit crosscheck copy at 14-NOV-12

searching for all files in the recovery area
cataloging files...
no files cataloged

RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     /u01/app/oracle/oradata/orcl/system01.dbf
2    0        UNDOTBS1             ***     /u01/app/oracle/oradata/orcl/undotbs01.dbf
3    0        SYSAUX               ***     /u01/app/oracle/oradata/orcl/sysaux01.dbf
4    0        USERS                ***     /u01/app/oracle/oradata/orcl/users01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/orcl/temp01.dbf

RMAN>

根据上面的输出，我们可以看到单节点的数据库，以前的数据文件的存放路径；我们要对其进行修改，让其数据文件存放到磁盘组中，在RMAN中执行下面的语句。

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;

set newname for datafile 1 to '+DATA';
set newname for datafile 2 to '+DATA';
set newname for datafile 3 to '+DATA';
set newname for datafile 4 to '+DATA';
restore database;
}

RMAN> run {
2> allocate channel d1 type disk;
3> allocate channel d2 type disk;
4> allocate channel d3 type disk;
5>
6> set newname for datafile 1 to '+DATA';
7> set newname for datafile 2 to '+DATA';
8> set newname for datafile 3 to '+DATA';
9> set newname for datafile 4 to '+DATA';
10> restore database;
11> }

released channel: ORA_DISK_1
allocated channel: d1
channel d1: sid=150 instance=orcl1 devtype=DISK

allocated channel: d2
channel d2: sid=146 instance=orcl1 devtype=DISK

allocated channel: d3
channel d3: sid=145 instance=orcl1 devtype=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 14-NOV-12

channel d1: starting datafile backupset restore
channel d1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to +DATA
restoring datafile 00003 to +DATA
channel d1: reading from backup piece /u02/backup_db/ORCL_21_798936465_1_full_db.bus
channel d2: starting datafile backupset restore
channel d2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +DATA
restoring datafile 00004 to +DATA
channel d2: reading from backup piece /u02/backup_db/ORCL_20_798936465_1_full_db.bus
channel d1: restored backup piece 1
piece handle=/u02/backup_db/ORCL_21_798936465_1_full_db.bus tag=FULL_DB_BK
channel d1: restore complete, elapsed time: 00:00:26
channel d2: restored backup piece 1
piece handle=/u02/backup_db/ORCL_20_798936465_1_full_db.bus tag=FULL_DB_BK
channel d2: restore complete, elapsed time: 00:00:41
Finished restore at 14-NOV-12
released channel: d1
released channel: d2
released channel: d3

RMAN>

RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA/orcl/datafile/system.401.799340335"
datafile 2 switched to datafile copy "+DATA/orcl/datafile/undotbs1.330.799340335"
datafile 3 switched to datafile copy "+DATA/orcl/datafile/sysaux.416.799340333"
datafile 4 switched to datafile copy "+DATA/orcl/datafile/users.351.799340335"

RMAN> recover database;

Starting recover at 14-NOV-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=150 instance=orcl1 devtype=DISK

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=16
channel ORA_DISK_1: reading from backup piece /u02/backup_db/ORCL_24_798936483_1_full_arch.bus
channel ORA_DISK_1: restored backup piece 1
piece handle=/u02/backup_db/ORCL_24_798936483_1_full_arch.bus tag=FULL_DB_BK
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archive log filename=+FRA/orcl/archivelog/2012_11_14/thread_1_seq_16.290.799340411 thread=1 sequence=16
channel default: deleting archive log(s)
archive log filename=+FRA/orcl/archivelog/2012_11_14/thread_1_seq_16.290.799340411 recid=19 stamp=799340412
unable to find archive log
archive log thread=1 sequence=17
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/14/2012 15:00:19
RMAN-06054: media recovery requesting unknown log: thread 1 seq 17 lowscn 417407

RMAN> exit

Recovery Manager complete.
[oracle@rac1 dbs]$

##########################################################

5. 创建thread 2的日志和另一个节点的undo表空间

[oracle@rac1 dbs]$ export ORACLE_SID=orcl1
[oracle@rac1 dbs]$ sqlplus / as sysdba

查看节点1的日志，创建指定的目录：

SQL> set linesize 180
SQL> col member format a50
SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                             IS_
---------- ------- ------- -------------------------------------------------- ---
         3         ONLINE  /u01/app/oracle/oradata/orcl/redo03.log            NO
         2         ONLINE  /u01/app/oracle/oradata/orcl/redo02.log            NO
         1         ONLINE  /u01/app/oracle/oradata/orcl/redo01.log            NO

SQL> host mkdir -p /u01/app/oracle/oradata/orcl/

 

 

创建日志组和UNDO表空间，用于实例2的使用:

alter database  add logfile thread 2
group 5  size 100M,
group 6  size 100M,
group 7  size 100M;

SQL> alter database  add logfile thread 2
  2  group 5  size 100M,
  3  group 6  size 100M,
  4  group 7  size 100M;

Database altered.

SQL> alter database open resetlogs;

Database altered.

SQL> alter database enable public thread 2;

Database altered.

SQL> CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '+DATA';

Tablespace created.

SQL>

6. 将在文件系统存放的日志，迁移到+ASM

 

alter database  add logfile thread 1
group 8  size 100M,
group 9  size 100M;

alter database drop logfile group 2;
alter database drop logfile group 3;

alter system switch logfile;

alter system checkpoint;
alter database drop logfile group 1;
alter database add logfile group 1 size 100m, group 2 size 100m, group 3 size 100m;

 

SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                             IS_
---------- ------- ------- -------------------------------------------------- ---
         1         ONLINE  +DATA/orcl/onlinelog/group_1.412.799341123         NO
         1         ONLINE  +FRA/orcl/onlinelog/group_1.265.799341129          YES
         2         ONLINE  +DATA/orcl/onlinelog/group_2.408.799341137         NO
         5         ONLINE  +DATA/orcl/onlinelog/group_5.363.799340635         NO
         5         ONLINE  +FRA/orcl/onlinelog/group_5.290.799340641          YES
         6         ONLINE  +DATA/orcl/onlinelog/group_6.386.799340649         NO
         6         ONLINE  +FRA/orcl/onlinelog/group_6.291.799340655          YES
         7         ONLINE  +DATA/orcl/onlinelog/group_7.389.799340661         NO
         7         ONLINE  +FRA/orcl/onlinelog/group_7.275.799340667          YES
         8         ONLINE  +DATA/orcl/onlinelog/group_8.400.799341055         NO
         8         ONLINE  +FRA/orcl/onlinelog/group_8.264.799341061          YES

    GROUP# STATUS  TYPE    MEMBER                                             IS_
---------- ------- ------- -------------------------------------------------- ---
         9         ONLINE  +DATA/orcl/onlinelog/group_9.413.799341067         NO
         9         ONLINE  +FRA/orcl/onlinelog/group_9.292.799341073          YES
         2         ONLINE  +FRA/orcl/onlinelog/group_2.286.799341147          YES
         3         ONLINE  +DATA/orcl/onlinelog/group_3.394.799341153         NO
         3         ONLINE  +FRA/orcl/onlinelog/group_3.287.799341161          YES

16 rows selected.

SQL>

 

7. 创建cluster database的视图

create cluster database specific views within the existing instance

SQL> @$ORACLE_HOME/rdbms/admin/catclust.sql

 

8. 迁移临时文件

SQL> alter tablespace temp add tempfile '+DATA';

SQL> alter database tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' drop;

 

########################################################################

9. crs环境信息建立

在节点1操作：
[oracle@rac1 dbs]$ export ORACLE_SID=orcl1
[oracle@rac1 dbs]$ sqlplus / as sysdba

SQL> shutdown immediate

SQL> create pfile from spfile;
SQL> create spfile='+DATA/orcl/spfileorcl.ora' from pfile; 

SQL> exit

 

[oracle@rac1 dbs]$ cd /u01/app/oracle/oracle/product/10.2.0/db_1/dbs
[oracle@rac1 dbs]$ rm spfileorcl1.ora
[oracle@rac1 dbs]$ echo "spfile='+DATA/orcl/spfileorcl.ora'" > initorcl1.ora

在节点2操作:

[oracle@rac2 dbs]$ cd /u01/app/oracle/oracle/product/10.2.0/db_1/dbs
[oracle@rac2 dbs]$ rm spfileorcl2.ora
rm: cannot remove `spfileorcl2.ora': No such file or directory
[oracle@rac2 dbs]$ echo "spfile='+DATA/orcl/spfileorcl.ora'" > initorcl2.ora
[oracle@rac2 dbs]$

 

10. 配置并启动RAC数据库

 

[oracle@rac1 dbs]$ srvctl add database -d orcl -o /u01/app/oracle/oracle/product/10.2.0/db_1
[oracle@rac1 dbs]$ srvctl add instance -d orcl -i orcl1 -n rac1
[oracle@rac1 dbs]$ srvctl add instance -d orcl -i orcl2 -n rac2

[oracle@rac1 dbs]$ srvctl modify instance -d orcl -i orcl1 -s +ASM1
[oracle@rac1 dbs]$ srvctl modify instance -d orcl -i orcl2 -s +ASM2

 

[oracle@rac1 dbs]$ srvctl start database -d orcl
[oracle@rac1 dbs]$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.orcl.db    application    ONLINE    ONLINE    rac2       
ora....l1.inst application    ONLINE    ONLINE    rac1       
ora....l2.inst application    ONLINE    ONLINE    rac2       
ora....SM1.asm application    ONLINE    ONLINE    rac1       
ora....C1.lsnr application    ONLINE    ONLINE    rac1       
ora.rac1.gsd   application    ONLINE    ONLINE    rac1       
ora.rac1.ons   application    ONLINE    ONLINE    rac1       
ora.rac1.vip   application    ONLINE    ONLINE    rac1       
ora....SM2.asm application    ONLINE    ONLINE    rac2       
ora....C2.lsnr application    ONLINE    ONLINE    rac2       
ora.rac2.gsd   application    ONLINE    ONLINE    rac2       
ora.rac2.ons   application    ONLINE    ONLINE    rac2       
ora.rac2.vip   application    ONLINE    ONLINE    rac2       
ora....b.AP.cs application    OFFLINE   OFFLINE              
ora....db1.srv application    OFFLINE   OFFLINE              
ora....b.GL.cs application    OFFLINE   OFFLINE              
ora....db2.srv application    OFFLINE   OFFLINE              
ora.racdb.db   application    OFFLINE   OFFLINE              
ora....b1.inst application    OFFLINE   OFFLINE              
ora....b2.inst application    OFFLINE   OFFLINE              
[oracle@rac1 dbs]$

 

##############################################

11. tnsnames.ora 网络配置文件

在两个节点的tnsnames.ora文件中操作

[oracle@rac1 dbs]$ cd $ORACLE_HOME/network/admin
[oracle@rac1 admin]$ vi tnsnames.ora

添加：

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

ORCL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      (INSTANCE_NAME = orcl1)
    )
  )

ORCL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      (INSTANCE_NAME = orcl2)
    )
  )

LISTENERS_ORCL =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.localdomain)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.localdomain)(PORT = 1521))
  )

 

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

 

12. 验证

[oracle@rac1 admin]$ sqlplus system/oracle@orcl

SQL> col inst_name format a50
SQL> select * from v$active_instances;

INST_NUMBER INST_NAME
----------- --------------------------------------------------
          1 rac1.localdomain:orcl1

          2 rac2.localdomain:orcl2

 

SQL> col host_name format a20
SQL> select instance_name, host_name, archiver, thread#, status from gv$instance;

INSTANCE_NAME    HOST_NAME            ARCHIVE    THREAD# STATUS
---------------- -------------------- ------- ---------- ------------
orcl1            rac1.localdomain     STARTED          1 OPEN
orcl2            rac2.localdomain     STARTED          2 OPEN

SQL>

 

 

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

转载于:http://blog.itpub.net/27571661/viewspace-761316/