查看oracle rac主从_如何将 Oracle 单实例数据库转换为RAC数据库？

安装一套RAC环境，并把单实例数据库通过通过rman还原到这个环境(通常如果是生产环境，我们会搭建从RAC到单实例数据库的ADG，以减少停机时间)

单实例数据库转换为RAC数据库，Oracle 11.2.0.4

首先，安装一套RAC环境，并把单实例数据库通过通过rman还原到这个环境(通常如果是生产环境，我们会搭建从RAC到单实例数据库的ADG，以减少停机时间)。 然后生成一个源库(单实例数据库)spfile：

startup pfile=/home/oracle/orcld/spfile.orclddb.tmp08:07:25 sys@orclddb>show parameter spfileNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               string

注意检查tnsnames.ora中用于local_listener参数的两个配置条目是否正确：

LISTENER_RAC1=(ADDRESS = (PROTOCOL = TCP)(HOST = dm0101-vip.orcld.com)(PORT = 1521))        LISTENER_RAC2=(ADDRESS = (PROTOCOL = TCP)(HOST = dm0102-vip.orcld.com)(PORT = 1521))

修改刚才备份的pfile文件(/home/oracle/orcld/spfile.orclddb.tmp)，添加RAC相关配置：

*.audit_file_dest='/u01/app/oracle/admin/orclddb/adump'*.audit_trail='NONE'*.compatible='11.2.0.3.0'*.control_files='+DATADG/orclddb/control01.ctl','+DATADG/orclddb/control02.ctl'*.db_block_size=8192                    *.db_domain=''*.db_files=2000*.db_name='orclddb'*.db_recovery_file_dest='+RECODG'*.db_recovery_file_dest_size=336870912000*.db_unique_name='orclddb'*.deferred_segment_creation=FALSE*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclddbXDB)'*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orclddb'*.log_archive_dest_state_1='ENABLE'*.open_cursors=500*.pga_aggregate_target=1059552256*.processes=500*.remote_login_passwordfile='EXCLUSIVE'*.resource_manager_plan=''*.session_cached_cursors=2000*.sga_target=0*.standby_file_management='AUTO'*.undo_tablespace='UNDOTBS1'#*.use_large_pages='ONLY'*.db_cache_size=3g *.shared_pool_size=3g*.streams_pool_size=28m*.java_pool_size=200m*.log_buffer=37108864*.job_queue_processes=20*.cluster_database=true*.cluster_database_instances=2*.undo_management=AUTO*.db_create_file_dest='+DATADG'*.db_create_online_log_dest_1='+RECODG'orclddb1.undo_tablespace='UNDOTBS1'orclddb2.undo_tablespace='UNDOTBS2'orclddb1.instance_number=1orclddb2.instance_number=2orclddb1.instance_name=orclddb1orclddb2.instance_name=orclddb2orclddb1.thread=1orclddb2.thread=2orclddb1.local_listener=LISTENER_RAC1orclddb2.local_listener=LISTENER_RAC2

使用这个pfile启动数据库：

08:26:59 @>startup pfile=/home/oracle/orcld/spfile.orclddb.tmpORACLE instance started. Total System Global Area       6881869824 bytesFixed Size                        2266064 bytesVariable Size                  3573550128 bytesDatabase Buffers               3221225472 bytesRedo Buffers                     84828160 bytesDatabase mounted.Database opened.

添加thread2：

08:27:30 @>alter database add logfile thread 208:28:16   2    group 17  ('+RECODG') size 1024m,08:28:16   3    group 18  ('+RECODG') size 1024m,08:28:16   4    group 19  ('+RECODG') size 1024m,        group 20  ('+RECODG') size 1024m,08:28:16   5  08:28:16   6      group 21  ('+RECODG') size 1024m,08:28:16   7    group 22  ('+RECODG') size 1024m,        group 23  ('+RECODG') size 1024m,08:28:16   8  08:28:16   9      group 24  ('+RECODG') size 1024m,        group 25  ('+RECODG') size 1024m,08:28:16  10  08:28:16  11      group 26  ('+RECODG') size 1024m,08:28:16  12    group 27  ('+RECODG') size 1024m,        group 28  ('+RECODG') size 1024m,08:28:16  13  08:28:16  14      group 29  ('+RECODG') size 1024m,08:28:16  15    group 30  ('+RECODG') size 1024m,08:28:16  16    group 31  ('+RECODG') size 1024m,08:28:16  17    group 32  ('+RECODG') size 1024m;08:28:16  18   Database altered. Elapsed: 00:00:28.51

添加实例2的undo表空间：

08:28:46 @>CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '+DATADG' SIZE 10480m ;         Tablespace created. Elapsed: 00:00:09.87

启用实例2(thread2)：

08:29:11 @>alter database enable public thread 2;  Database altered. Elapsed: 00:00:00.59

创建spfile：

create spfile='+DATADG' from pfile='/home/oracle/orcld/spfile.orclddb.tmp'; File created. Elapsed: 00:00:00.21

使用grid用户查看：

ASMCMD> lsspfile.3296.878718931ASMCMD> pwd+datadg/orclddb/PARAMETERFILEASMCMD> 

修改initorclddb1.ora 文件：

[oracle@dm01db01 dbs]$ cat initorclddb1.ora SPFILE='+datadg/orclddb/PARAMETERFILE/spfile.3296.878718931'[oracle@dm01db01 dbs]$ 

检查数据库：

✨ 接下来内容请访问原文(https://www.modb.pro/db/27697?YYF)进行查看~

更多数据库相关内容，可访问墨天轮(https://www.modb.pro/?YYF)进行浏览。