duplicate複製資料庫(rac-rac)
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 之 Duplicate 複製資料庫Oracle資料庫
- DUPLICATE遠端複製資料庫資料庫
- 【RMAN】使用duplicate本地複製資料庫資料庫
- duplicate rman複製資料庫技術資料庫
- RMAN duplicate from active database 複製資料庫Database資料庫
- Duplicate 複製資料庫實驗過程資料庫
- Rman duplicate資料庫複製(單系統)資料庫
- 使用rman的命令duplicate複製資料庫資料庫
- RMAN高階應用之Duplicate複製資料庫(3)複製流程資料庫
- duplicate複製資料庫(rac-單例項)資料庫單例
- 【RMAN】使用RMAN duplicate複製同機資料庫資料庫
- 使用RMAN高階應用之Duplicate複製資料庫資料庫
- Oracle 11gR2 使用RMAN Duplicate複製資料庫Oracle資料庫
- Oracle11gR2使用RMAN duplicate複製資料庫Oracle資料庫
- RMAN實戰系列之一:用duplicate複製資料庫資料庫
- RMAN高階應用之Duplicate複製資料庫(1)概述資料庫
- oracle 11g duplicate from active database 複製資料庫(四)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(三)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(二)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(一)OracleDatabase資料庫
- RMAN高階應用之Duplicate複製資料庫(4)實戰資料庫
- RMAN高階應用之Duplicate複製資料庫(5)補充資料庫
- DG rman duplicate 複製庫錯誤
- 採用DUPLICATE 把asm資料庫複製到檔案系統ASM資料庫
- 實戰10g新特性之rman duplicate複製資料庫資料庫
- 【RMAN】使用RMAN duplicate複製同機資料庫遇到的問題資料庫
- 資料庫複製資料庫
- 複製資料庫資料庫
- Oracle 11gR2 使用 RMAN duplicate from active database 複製資料庫OracleDatabase資料庫
- Oracle備份與恢復系列(四)續 RMAN Duplicate複製資料庫Oracle資料庫
- oracle 11g duplicate database基於備份複製資料庫(六)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(五)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(四)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(三)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(二)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(一)OracleDatabase資料庫
- RMAN高階應用之Duplicate複製資料庫(2)輔助例項資料庫
- 續上_在同一節點上利用rman duplicate複製資料庫資料庫