rac-rac使用duplicate进行数据迁移
配置监听
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=dup1)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME=test)))
配置tns
dup1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.121)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)
创建pfile,传输密码口令文件
辅助库启动到nomount状态
主库进入rman执行duplicate
rman target / auxiliary sys/oracle@dup1 nocatalog
run
{
DUPLICATE TARGET DATABASE to 'test'
FROM ACTIVE DATABASE nofilenamecheck
spfile
set db_file_name_convert='+oradata', '+oradata'
set log_file_name_convert='+oradata', '+oradata', '+rcy', '+rcy'
set control_files='+oradata','+rcy'
set remote_listener='scanip:1521'
set cluster_database='false'
;
}
传输完成后
辅助库
修改参数
alter system set cluster_database=true scope=spfile sid='*';
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.123)(PORT=1521))' sid='test1';
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.122)(PORT=1521))' sid='test2';
关闭数据库
根据现有的spfile创建spfile到共享存储中
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create pfile='/tmp/init11.ora' from spfile;
File created.
SQL> create spfile='+oradata/test/spfiletest.ora' from pfile='/tmp/init11.ora';
File created.
SQL> quit
将原库两个节点的initsid1.ora、initsid2.ora分别传到备库的两个节点的相应目录上
将数据库加入集群并添加相应的实例,然后起库查看数据库状态
[oracle@ora6 dbs]$ srvctl add database -d test -o /u01/app/oracle/product/11.2.0/dbhome_1/
[oracle@ora6 dbs]$ srvctl add instance -d test -i test1 -n ora5
[oracle@ora6 dbs]$ srvctl add instance -d test -i test2 -n ora6
[grid@ora6 ~]$ srvctl start database -d test
[grid@ora6 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.OCR.dg
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.ORADATA.dg
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.RCY.dg
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.asm
ONLINE ONLINE ora5 Started
ONLINE ONLINE ora6 Started
ora.gsd
OFFLINE OFFLINE ora5
OFFLINE OFFLINE ora6
ora.net1.network
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.ons
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.registry.acfs
ONLINE ONLINE ora5
ONLINE ONLINE ora6
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora5
ora.ceshi.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.cvu
1 ONLINE ONLINE ora5
ora.oc4j
1 ONLINE ONLINE ora5
ora.ora5.vip
1 ONLINE ONLINE ora5
ora.ora6.vip
1 ONLINE ONLINE ora6
ora.scan1.vip
1 ONLINE ONLINE ora5
ora.test.db
1 ONLINE ONLINE ora5 Open
2 ONLINE ONLINE ora6 Open
[grid@ora6 ~]$
SQL> select instance_name,status from gv$instance;
INSTANCE_NAME STATUS
---------------- ------------
test2 OPEN
test1 OPEN
SQL>
配置监听
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=dup1)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME=test)))
配置tns
dup1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.162.121)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)
创建pfile,传输密码口令文件
辅助库启动到nomount状态
主库进入rman执行duplicate
rman target / auxiliary sys/oracle@dup1 nocatalog
run
{
DUPLICATE TARGET DATABASE to 'test'
FROM ACTIVE DATABASE nofilenamecheck
spfile
set db_file_name_convert='+oradata', '+oradata'
set log_file_name_convert='+oradata', '+oradata', '+rcy', '+rcy'
set control_files='+oradata','+rcy'
set remote_listener='scanip:1521'
set cluster_database='false'
;
}
传输完成后
辅助库
修改参数
alter system set cluster_database=true scope=spfile sid='*';
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.123)(PORT=1521))' sid='test1';
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.122)(PORT=1521))' sid='test2';
关闭数据库
根据现有的spfile创建spfile到共享存储中
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create pfile='/tmp/init11.ora' from spfile;
File created.
SQL> create spfile='+oradata/test/spfiletest.ora' from pfile='/tmp/init11.ora';
File created.
SQL> quit
将原库两个节点的initsid1.ora、initsid2.ora分别传到备库的两个节点的相应目录上
将数据库加入集群并添加相应的实例,然后起库查看数据库状态
[oracle@ora6 dbs]$ srvctl add database -d test -o /u01/app/oracle/product/11.2.0/dbhome_1/
[oracle@ora6 dbs]$ srvctl add instance -d test -i test1 -n ora5
[oracle@ora6 dbs]$ srvctl add instance -d test -i test2 -n ora6
[grid@ora6 ~]$ srvctl start database -d test
[grid@ora6 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.OCR.dg
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.ORADATA.dg
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.RCY.dg
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.asm
ONLINE ONLINE ora5 Started
ONLINE ONLINE ora6 Started
ora.gsd
OFFLINE OFFLINE ora5
OFFLINE OFFLINE ora6
ora.net1.network
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.ons
ONLINE ONLINE ora5
ONLINE ONLINE ora6
ora.registry.acfs
ONLINE ONLINE ora5
ONLINE ONLINE ora6
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ora5
ora.ceshi.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.cvu
1 ONLINE ONLINE ora5
ora.oc4j
1 ONLINE ONLINE ora5
ora.ora5.vip
1 ONLINE ONLINE ora5
ora.ora6.vip
1 ONLINE ONLINE ora6
ora.scan1.vip
1 ONLINE ONLINE ora5
ora.test.db
1 ONLINE ONLINE ora5 Open
2 ONLINE ONLINE ora6 Open
[grid@ora6 ~]$
SQL> select instance_name,status from gv$instance;
INSTANCE_NAME STATUS
---------------- ------------
test2 OPEN
test1 OPEN
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-2138016/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-2138016/