网站导航栏特效,甲蛙网站建设,长沙网站建设哪个公司好,不付费免费网站导读 本文介绍如何将Oracle单实例数据库转换成Oracle RAC数据库 环境说明#xff1a; 数据库节点2上有个单实例数据库zlxdb2#xff0c;现在要将zlxdb2转换成RAC数据库#xff0c;RAC数据库的两个实例分别是lzydb1和lzydb2。 以下是详细的操作步骤#xff1a; 1、查看zlxdb… 导读 本文介绍如何将Oracle单实例数据库转换成Oracle RAC数据库 环境说明 数据库节点2上有个单实例数据库zlxdb2现在要将zlxdb2转换成RAC数据库RAC数据库的两个实例分别是lzydb1和lzydb2。 以下是详细的操作步骤 1、查看zlxdb2的默认undo表空间
SYSzlxdb2show parameter undoNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS12、给zlxdb2数据库创建新的UNDO表空间
SYSzlxdb2CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE DATA SIZE 100m AUTOEXTEND ON;SYSzlxdb2select tablespace_name from dba_tablespaces where contentsUNDO;TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2将UNDOTBS1表空间设置为数据库实例lzydb1的默认undo表空间 将UNDOTBS2表空间设置为数据库实例lzydb2的默认undo表空间。
alter system set undo_tablespaceUNDOTBS2 SCOPESPFILE SIDlzydb2;
alter system set undo_tablespaceUNDOTBS1 SCOPESPFILE SIDlzydb1;3、查看redo日志路径和redo大小
SYSzlxdb2select group#,member from v$logfile order by 1;GROUP# MEMBER
---------- --------------------------------------------------
1 DATA/lzydb/onlinelog/group_1.290.1120398077
2 DATA/lzydb/onlinelog/group_2.291.1120398077
3 DATA/lzydb/onlinelog/group_3.292.1120398077SYSzlxdb2select group#,thread#,bytes/1024/1024 from v$log;GROUP# THREAD# BYTES/1024/1024
---------- ---------- ---------------
1 1 50
2 1 50
3 1 50查看redo日志的thread号单实例只有一个thread1SYSzlxdb2select THREAD#, STATUS, ENABLED from v$thread;
THREAD# STATUS ENABLED
---------- ------ --------
1 OPEN PUBLIC4、添加新的redo日志组group4group5group6大小分别与group1group2group3一样50MB
alter database add logfile thread 2 group 4 (DATA) size 50m,group 5 (DATA) size 50m,group 6 (DATA) size 50m;SYSzlxdb2select group#,member from v$logfile order by 1;GROUP# MEMBER
---------- --------------------------------------------------
1 DATA/zlxdb/onlinelog/group_1.275.1120355965
2 DATA/zlxdb/onlinelog/group_2.276.1120355967
3 DATA/zlxdb/onlinelog/group_3.277.1120355967
4 DATA/zlxdb/onlinelog/group_4.280.1120358085
5 DATA/zlxdb/onlinelog/group_5.281.1120358085
6 DATA/zlxdb/onlinelog/group_6.282.1120358087SYSzlxdb2select group#,thread#,bytes/1024/1024 from v$log;GROUP# THREAD# BYTES/1024/1024
---------- ---------- ---------------
1 1 50
2 1 50
3 1 50
4 2 50
5 2 50
6 2 506 rows selected.启用thread2线程的日志组
SYSzlxdb2alter database enable public thread 2;SYSzlxdb2select THREAD#, STATUS, ENABLED from v$thread;
THREAD# STATUS ENABLED
---------- ------ --------
1 OPEN PUBLIC
2 CLOSED DISABLED5、开启集群
SYSzlxdb2alter system set cluster_databasetrue scopespfile sid*;
SYSzlxdb2alter system set cluster_database_instances2 scopespfile;6、设置新数据库lzydb的RAC参数
SYSzlxdb2alter system set remote_listenerscan-ip:1521;
SYSzlxdb2alter system set instance_number1 scopespfile sidlzydb1;
SYSzlxdb2alter system set instance_number2 scopespfile sidlzydb2;
SYSzlxdb2alter system set instance_namelzydb1 scopespfile sidlzydb1;
SYSzlxdb2alter system set instance_namelzydb2 scopespfile sidlzydb2;
SYSzlxdb2alter system set thread1 sidlzydb1;
SYSzlxdb2alter system set thread2 sidlzydb2;7、从zlxdb2的spfile创建pfile参数文件用于设置新数据库lzydb的参数
SYSzlxdb2create pfile/home/oracle/initzlxdb2.ora from spfile;参数文件信息如下
*.audit_file_dest/u01/app/oracle/admin/lzydb/adump
*.audit_traildb
*.cluster_databaseTRUE
*.cluster_database_instances2
*.compatible11.2.0.4.0
*.control_filesDATA/lzydb/controlfile/current.289.1120398075
*.db_block_size8192
*.db_create_file_destDATA
*.db_domain
*.db_namelzydb
*.diagnostic_dest/u01/app/oracle
*.dispatchers(PROTOCOLTCP) (SERVICElzydbXDB)
lzydb1.instance_namelzydb1
lzydb2.instance_namelzydb2
lzydb1.instance_number1
lzydb2.instance_number2
*.open_cursors300
*.pga_aggregate_target314572800
*.processes150
*.remote_listenerscan-ip:1521
*.remote_login_passwordfileEXCLUSIVE
*.sga_target943718400
lzydb1.thread1
lzydb2.thread2
lzydb1.undo_tablespaceUNDOTBS1
lzydb2.undo_tablespaceUNDOTBS2SYSzlxdb2show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string DATA/lzydb/spfilelzydb.ora8、关闭zlxdb2数据库
SYSzlxdb2shutdown immediate9、创建参数文件将initlzydb2.ora指向spfile路径
SPFILEDATA/lzydb/spfilelzydb.ora10、执行创建RAC数据库集群的脚本
SYSzlxdb2?/rdbms/admin/catclust.sql
PL/SQL procedure successfully completed.11、将新的initlzydb2.ora参数文件拷贝到节点1
[oraclenode2 ~]$ cd $ORACLE_HOME/dbs
scp initlzydb2.ora node1:$ORACLE_HOME/dbs12、节点1重命名参数文件为initlzydb1.ora
[oraclenode1 ~]$ cd $ORACLE_HOME/dbs
mv initlzydb2.ora initlzydb1.ora13、启动lzydb1和lzydb2两个数据库实例
[oraclenode1 ~]$ mkdir -p /u01/app/oracle/admin/lzydb/adump
export ORACLE_SIDlzydb1
sqlplus / as sysdba
startup[oraclenode2 ~]$ mkdir -p /u01/app/oracle/admin/lzydb/adump
export ORACLE_SIDlzydb2
sqlplus / as sysdba
startup13、数据库实例添加到CRS中
[oraclenode1 ~]$ crsctl stat res -t
[oraclenode1 ~]$ srvctl remove database -d lzydb -f
[oraclenode1 ~]$ srvctl add database -d lzydb -o $ORACLE_HOME -p DATA/lzydb/spfilelzydb.ora
[oraclenode1 ~]$ srvctl add instance -d lzydb -n node1 -i lzydb1
[oraclenode1 ~]$ srvctl add instance -d lzydb -n node2 -i lzydb214、分别关闭两个新的数据库实例lzydb1和lzydb2
shut immediate15、使用srvctl start database命令启动数据库lzydb
srvctl start database -d lzydb16、查看数据库状态
[rootnode1 ~]# crsctl stat res -t
