rman duplicate
環(huán)境
oracle11g redhat6.5
主庫10.8.98.103 oratest001
從庫10.8.98.104 oratest002
主庫oracle_id test103
從庫只安裝了數據庫軟件，oracle_sid 為test104
主庫環(huán)境變量
[oracle@oratest001 ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH # Oracle Settings oracle TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR export ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME ORACLE_SID=test103; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM alias sqlplus='rlwrap sqlplus' alias rman='rlwrap rman' PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG if [ $USER = "oracle" ] || [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi [oracle@oratest001 ~]$
備庫環(huán)境變量
[oracle@oratest002 ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH # Oracle Settings oracle TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR export ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME ORACLE_SID=test104; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG if [ $USER = "oracle" ] || [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi [oracle@oratest002 ~]$
一、主庫修改為靜態(tài)監聽(tīng)，并配置tnsnames.ora
[oracle@oratest001 admin]$ cat listener.ora # listener.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = test103) (ORACLE_HOME = /oracle/app/oracle/product/11.2.0) (SID_NAME = test103)) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.103)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = /oracle/app/oracle [oracle@oratest001 admin]$ [oracle@oratest001 admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/network/admin/tnsnames.ora # Generated by Oracle configuration tools. TEST103 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.103)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test103) ) ) TEST104 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.104)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test103) ) ) [oracle@oratest001 admin]$
二、備庫修改為靜態(tài)監聽(tīng)，并配置tnsnames.ora
[oracle@oratest002 admin]$ cat listener.ora # listener.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = test103) (ORACLE_HOME = /oracle/app/oracle/product/11.2.0) (SID_NAME = test104)) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.104)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = /oracle/app/oracle [oracle@oratest002 admin]$ [oracle@oratest002 admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/network/admin/tnsnames.ora # Generated by Oracle configuration tools. TEST103 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.103)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test103) ) ) TEST104 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.98.104)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test103) ) ) [oracle@oratest002 admin]$
四、主庫往備庫copy參數文件和密碼文件，并在備庫上修改文件名稱(chēng)
[oracle@oratest001 dbs]$ pwd /oracle/app/oracle/product/11.2.0/dbs [oracle@oratest001 dbs]$ scp inittest103.ora orapwtest103 10.8.98.104:/oracle/app/oracle/product/11.2.0/dbs [oracle@oratest002 dbs]$ pwd /oracle/app/oracle/product/11.2.0/dbs [oracle@oratest002 dbs]$ mv inittest103.ora inittest104.ora [oracle@oratest002 dbs]$ mv orapwtest103 orapwtest104
備庫參數文件修改
[oracle@gacoratest002 dbs]$ cat inittest104.ora *.audit_file_dest='/oracle/app/oracle/admin/test104/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_files='/oracle/app/oracle/oradata/test103/control01.ctl','/oracle/app/oracle/oradata/test103/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='test103' *.diagnostic_dest='/oracle/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=test103XDB)' *.memory_target=4120903680 *.open_cursors=300 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.undo_tablespace='UNDOTBS1'
*.audit_file_dest='/oracle/app/oracle/admin/ test104/adump'
并在備庫上創(chuàng )建相應的目錄
mkdir -p /oracle/app/oracle/admin/test104/adump mkdir -p /oracle/app/oracle/oradata/test103/
五、備庫啟動(dòng)到nomount狀態(tài)，主庫open并且需要是歸檔模式
六、重啟監聽(tīng)，并在主備庫測試tnsping。
主庫
[oracle@oratest001 admin]$ lsnrctl stop [oracle@oratest001 admin]$ lsnrctl start [oracle@oratest001 admin]$ tnsping test103 [oracle@oratest001 admin]$ tnsping test104
備庫同樣的操作，確保tnsping正確
七、在主庫上操作rman duplicate
[oracle@gacoratest001 dbs]$ rman target sys/oracle@test103 auxiliary sys/oracle@test104 Recovery Manager: Release 11.2.0.4.0 - Production on Sat Aug 21 12:17:32 2021 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST103 (DBID=333915497) connected to auxiliary database: TEST103 (not mounted) RMAN> duplicate target database to test103 from active database nofilenamecheck;
此處備庫就會(huì )打開(kāi)了
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 2021-08-21 12:18:55
RMAN>
八、最后查看備機狀態(tài)
[oracle@oratest002 dbs]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-AUG-2021 12:44:05 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.8.98.104)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 22-AUG-2021 12:33:50 Uptime 0 days 0 hr. 10 min. 15 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/app/oracle/product/11.2.0/network/admin/listener.ora Listener Log File /oracle/app/oracle/diag/tnslsnr/gacoratest002/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.8.98.104)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "test103" has 2 instance(s). Instance "test104", status UNKNOWN, has 1 handler(s) for this service... Instance "test104", status READY, has 1 handler(s) for this service... Service "test103XDB" has 1 instance(s). Instance "test104", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@oratest002 dbs]$
即成功，實(shí)例名為test104，數據庫db_name依然為test103
免責聲明：本站發(fā)布的內容（圖片、視頻和文字）以原創(chuàng )、來(lái)自本網(wǎng)站內容采集于網(wǎng)絡(luò )互聯(lián)網(wǎng)轉載等其它媒體和分享為主，內容觀(guān)點(diǎn)不代表本網(wǎng)站立場(chǎng)，如侵犯了原作者的版權，請告知一經(jīng)查實(shí)，將立刻刪除涉嫌侵權內容，聯(lián)系我們QQ:712375056，同時(shí)歡迎投稿傳遞力量。
Copyright ? 2009-2022 56dr.com. All Rights Reserved. 特網(wǎng)科技 特網(wǎng)云 版權所有 特網(wǎng)科技 粵ICP備16109289號
域名注冊服務(wù)機構:阿里云計算有限公司（萬(wàn)網(wǎng)） 域名服務(wù)機構：煙臺帝思普網(wǎng)絡(luò )科技有限公司（DNSPod） CDN服務(wù)：阿里云計算有限公司 百度云 中國互聯(lián)網(wǎng)舉報中心 增值電信業(yè)務(wù)經(jīng)營(yíng)許可證B2
建議您使用Chrome、Firefox、Edge、IE10及以上版本和360等主流瀏覽器瀏覽本網(wǎng)站
