如何使用rman克隆Oracle
这篇文章主要介绍如何使用rman克隆Oracle，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！
RMAN（Recovery Manager）是随Oracle服务器软件一同安装的工具软件，它可以用来备份和恢复数据库文件、归档日志和控制文件，用来执行完全或不完全的数据库恢复。
# 在主库查询对应的dump目录
selectname,valuefromv$parameterwherenamein('audit_file_dest','background_dump_dest','control_files','core_dump_dest','user_dump_dest','db_recovery_file_dest')ORDERBYnameASC;
# 备库用Oracle用户执行创建目录
mkdir-p$value三. 创建实例密钥文件
orapwdFILE=/u01/app/oracle/dbs/orapwora235password=li0924entries=5;
scp/u01/app/oracle/dbs/orapwora235oracle@192.168.1.221:/u01/app/oracle/dbs四. 创建参数文件
createpfilefromspfile;
scp/u01/app/oracle/dbs/initora235.oraoracle@192.168.1.221:/u01/app/oracle/dbs
[oracle@oracle221~]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononThuAug922:56:492018Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupnomountpfile='/u01/app/oracle/dbs/initora235.ora';ORACLEinstancestarted.TotalSystemGlobalArea780824576bytesFixedSize2257312bytesVariableSize511708768bytesDatabaseBuffers264241152bytesRedoBuffers2617344bytes五. 配置主备库的监听文件和网络文件
设置Primary库和Standby库的service_name
SQL>showparameterservice_name;NAMETYPEVALUE--------------------------------------------------------------service_namesstringlottuSQL>altersystemsetservice_names='db_primary'scope=both;Systemaltered.SQL>showparameterservice_name;NAMETYPEVALUE---------------------------------------------------------------service_namesstringdb_primary
备库的service_name设置为db_standby；需要到参数文件修改。
*.service_names='db_standby'
Primary库配置listener.ora
LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.235)(PORT=1521)(IP=FIRST)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=ora235)(GLOBAL_DBNAME=db_primary)(ORACLE_HOME=/u01/app/oracle)))
Standby库配置listener.ora
(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.221)(PORT=1521)(IP=FIRST)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=ora235)(GLOBAL_DBNAME=db_standby)(ORACLE_HOME=/u01/app/oracle)))
Primary库和Standby库设置tnsname.ora
tns_primary=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.235)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db_primary))(HS=OK))tns_standby=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.221)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=db_standby))(HS=OK))六. 克隆Oracle
在Standby库执行：DUPLICATE TARGET DATABASE TO ORA235 FROM ACTIVE DATABASE SPFILE NOFILENAMECHECK;
[oracle@oracle221~]$rlwraprmantargetsys/li0924@tns_primaryauxiliarysys/li0924@tns_standbyRecoveryManager:Release11.2.0.4.0-ProductiononThuAug1623:21:272018Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:ORA235(DBID=2047494122)connectedtoauxiliarydatabase:ORA235(notmounted)RMAN>DUPLICATETARGETDATABASETOORA235FROMACTIVEDATABASESPFILENOFILENAMECHECK;StartingDuplicateDbat16-AUG-18usingtargetdatabasecontrolfileinsteadofrecoverycatalogallocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=19devicetype=DISKcontentsofMemoryScript:{backupascopyreusetargetfile'/u01/app/oracle/dbs/spfileora235.ora'auxiliaryformat'/u01/app/oracle/dbs/spfileora235.ora';sqlclone"altersystemsetspfile=''/u01/app/oracle/dbs/spfileora235.ora''";}executingMemoryScriptStartingbackupat16-AUG-18allocatedchannel:ORA_DISK_1channelORA_DISK_1:SID=27devicetype=DISKFinishedbackupat16-AUG-18sqlstatement:altersystemsetspfile=''/u01/app/oracle/dbs/spfileora235.ora''contentsofMemoryScript:{sqlclone"altersystemsetdb_name=''ORA235''comment=''duplicate''scope=spfile";sqlclone"altersystemsetdb_unique_name=''ORA235''comment=''duplicate''scope=spfile";shutdowncloneimmediate;startupclonenomount;}executingMemoryScriptsqlstatement:altersystemsetdb_name=''ORA235''comment=''duplicate''scope=spfilesqlstatement:altersystemsetdb_unique_name=''ORA235''comment=''duplicate''scope=spfileOracleinstanceshutdownconnectedtoauxiliarydatabase(notstarted)OracleinstancestartedTotalSystemGlobalArea780824576bytesFixedSize2257312bytesVariableSize511708768bytesDatabaseBuffers264241152bytesRedoBuffers2617344bytescontentsofMemoryScript:{sqlclone"altersystemsetdb_name=''ORA235''comment=''ModifiedbyRMANduplicate''scope=spfile";sqlclone"altersystemsetdb_unique_name=''ORA235''comment=''ModifiedbyRMANduplicate''scope=spfile";shutdowncloneimmediate;startupcloneforcenomountbackupascopycurrentcontrolfileauxiliaryformat'/u01/app/oradata/ora235/control01.ctl';restoreclonecontrolfileto'/u01/app/oradata/ora235/control02.ctl'from'/u01/app/oradata/ora235/control01.ctl';alterclonedatabasemount;}executingMemoryScriptsqlstatement:altersystemsetdb_name=''ORA235''comment=''ModifiedbyRMANduplicate''scope=spfilesqlstatement:altersystemsetdb_unique_name=''ORA235''comment=''ModifiedbyRMANduplicate''scope=spfileOracleinstanceshutdownOracleinstancestartedTotalSystemGlobalArea780824576bytesFixedSize2257312bytesVariableSize511708768bytesDatabaseBuffers264241152bytesRedoBuffers2617344bytesStartingbackupat16-AUG-18usingchannelORA_DISK_1channelORA_DISK_1:startingdatafilecopycopyingcurrentcontrolfileoutputfilename=/u01/app/oracle/dbs/snapcf_ora235.ftag=TAG20180816T232148RECID=6STAMP=984352909channelORA_DISK_1:datafilecopycomplete,elapsedtime:00:00:03Finishedbackupat16-AUG-18Startingrestoreat16-AUG-18allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=18devicetype=DISKchannelORA_AUX_DISK_1:copiedcontrolfilecopyFinishedrestoreat16-AUG-18databasemountedRMAN-05538:WARNING:implicitlyusingDB_FILE_NAME_CONVERTcontentsofMemoryScript:{sqlclone'alterdatabaseflashbackoff';setnewnamefordatafile1to"/u01/app/oradata/ora235/system01.dbf";setnewnamefordatafile2to"/u01/app/oradata/ora235/sysaux01.dbf";setnewnamefordatafile3to"/u01/app/oradata/ora235/undotbs01.dbf";setnewnamefordatafile4to"/u01/app/oradata/ora235/users01.dbf";setnewnamefordatafile5to"/data/oracle/data/lottu01.dbf";backupascopyreusedatafile1auxiliaryformat"/u01/app/oradata/ora235/system01.dbf"datafile2auxiliaryformat"/u01/app/oradata/ora235/sysaux01.dbf"datafile3auxiliaryformat"/u01/app/oradata/ora235/undotbs01.dbf"datafile4auxiliaryformat"/u01/app/oradata/ora235/users01.dbf"datafile5auxiliaryformat"/data/oracle/data/lottu01.dbf";sql'altersystemarchivelogcurrent';}executingMemoryScriptsqlstatement:alterdatabaseflashbackoffexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEStartingbackupat16-AUG-18usingchannelORA_DISK_1channelORA_DISK_1:startingdatafilecopyinputdatafilefilenumber=00005name=/data/oracle/data/lottu01.dbfoutputfilename=/data/oracle/data/lottu01.dbftag=TAG20180816T232159channelORA_DISK_1:datafilecopycomplete,elapsedtime:00:01:45channelORA_DISK_1:startingdatafilecopyinputdatafilefilenumber=00001name=/u01/app/oradata/ora235/system01.dbfoutputfilename=/u01/app/oradata/ora235/system01.dbftag=TAG20180816T232159channelORA_DISK_1:datafilecopycomplete,elapsedtime:00:00:45channelORA_DISK_1:startingdatafilecopyinputdatafilefilenumber=00002name=/u01/app/oradata/ora235/sysaux01.dbfoutputfilename=/u01/app/oradata/ora235/sysaux01.dbftag=TAG20180816T232159channelORA_DISK_1:datafilecopycomplete,elapsedtime:00:00:35channelORA_DISK_1:startingdatafilecopyinputdatafilefilenumber=00003name=/u01/app/oradata/ora235/undotbs01.dbfoutputfilename=/u01/app/oradata/ora235/undotbs01.dbftag=TAG20180816T232159channelORA_DISK_1:datafilecopycomplete,elapsedtime:00:00:35channelORA_DISK_1:startingdatafilecopyinputdatafilefilenumber=00004name=/u01/app/oradata/ora235/users01.dbfoutputfilename=/u01/app/oradata/ora235/users01.dbftag=TAG20180816T232159channelORA_DISK_1:datafilecopycomplete,elapsedtime:00:00:01Finishedbackupat16-AUG-18sqlstatement:altersystemarchivelogcurrentcontentsofMemoryScript:{backupascopyreusearchiveloglike"/data/arch/1_7_984178575.dbf"auxiliaryformat"/data/arch/1_7_984178575.dbf";catalogclonearchivelog"/data/arch/1_7_984178575.dbf";switchclonedatafileall;}executingMemoryScriptStartingbackupat16-AUG-18usingchannelORA_DISK_1channelORA_DISK_1:startingarchivedlogcopyinputarchivedlogthread=1sequence=7RECID=45STAMP=984353140outputfilename=/data/arch/1_7_984178575.dbfRECID=0STAMP=0channelORA_DISK_1:archivedlogcopycomplete,elapsedtime:00:00:01Finishedbackupat16-AUG-18catalogedarchivedlogarchivedlogfilename=/data/arch/1_7_984178575.dbfRECID=45STAMP=984353142datafile1switchedtodatafilecopyinputdatafilecopyRECID=6STAMP=984353142filename=/u01/app/oradata/ora235/system01.dbfdatafile2switchedtodatafilecopyinputdatafilecopyRECID=7STAMP=984353142filename=/u01/app/oradata/ora235/sysaux01.dbfdatafile3switchedtodatafilecopyinputdatafilecopyRECID=8STAMP=984353142filename=/u01/app/oradata/ora235/undotbs01.dbfdatafile4switchedtodatafilecopyinputdatafilecopyRECID=9STAMP=984353142filename=/u01/app/oradata/ora235/users01.dbfdatafile5switchedtodatafilecopyinputdatafilecopyRECID=10STAMP=984353142filename=/data/oracle/data/lottu01.dbfcontentsofMemoryScript:{setuntilscn1190640;recoverclonedatabasedeletearchivelog;}executingMemoryScriptexecutingcommand:SETuntilclauseStartingrecoverat16-AUG-18usingchannelORA_AUX_DISK_1startingmediarecoveryarchivedlogforthread1withsequence7isalreadyondiskasfile/data/arch/1_7_984178575.dbfarchivedlogfilename=/data/arch/1_7_984178575.dbfthread=1sequence=7mediarecoverycomplete,elapsedtime:00:00:00Finishedrecoverat16-AUG-18OracleinstancestartedTotalSystemGlobalArea780824576bytesFixedSize2257312bytesVariableSize511708768bytesDatabaseBuffers264241152bytesRedoBuffers2617344bytescontentsofMemoryScript:{sqlclone"altersystemsetdb_name=''ORA235''comment=''ResettooriginalvaluebyRMAN''scope=spfile";sqlclone"altersystemresetdb_unique_namescope=spfile";shutdowncloneimmediate;startupclonenomount;}executingMemoryScriptsqlstatement:altersystemsetdb_name=''ORA235''comment=''ResettooriginalvaluebyRMAN''scope=spfilesqlstatement:altersystemresetdb_unique_namescope=spfileOracleinstanceshutdownconnectedtoauxiliarydatabase(notstarted)OracleinstancestartedTotalSystemGlobalArea780824576bytesFixedSize2257312bytesVariableSize511708768bytesDatabaseBuffers264241152bytesRedoBuffers2617344bytessqlstatement:CREATECONTROLFILEREUSESETDATABASE"ORA235"RESETLOGSARCHIVELOGMAXLOGFILES16MAXLOGMEMBERS3MAXDATAFILES100MAXINSTANCES8MAXLOGHISTORY292LOGFILEGROUP1('/u01/app/oradata/ora235/redo01.log')SIZE50MREUSE,GROUP2('/u01/app/oradata/ora235/redo02.log')SIZE50MREUSE,GROUP3('/u01/app/oradata/ora235/redo03.log')SIZE50MREUSEDATAFILE'/u01/app/oradata/ora235/system01.dbf'CHARACTERSETUTF8contentsofMemoryScript:{setnewnamefortempfile1to"/u01/app/oradata/ora235/temp01.dbf";switchclonetempfileall;catalogclonedatafilecopy"/u01/app/oradata/ora235/sysaux01.dbf","/u01/app/oradata/ora235/undotbs01.dbf","/u01/app/oradata/ora235/users01.dbf","/data/oracle/data/lottu01.dbf";switchclonedatafileall;}executingMemoryScriptexecutingcommand:SETNEWNAMErenamedtempfile1to/u01/app/oradata/ora235/temp01.dbfincontrolfilecatalogeddatafilecopydatafilecopyfilename=/u01/app/oradata/ora235/sysaux01.dbfRECID=1STAMP=984353151catalogeddatafilecopydatafilecopyfilename=/u01/app/oradata/ora235/undotbs01.dbfRECID=2STAMP=984353151catalogeddatafilecopydatafilecopyfilename=/u01/app/oradata/ora235/users01.dbfRECID=3STAMP=984353151catalogeddatafilecopydatafilecopyfilename=/data/oracle/data/lottu01.dbfRECID=4STAMP=984353151datafile2switchedtodatafilecopyinputdatafilecopyRECID=1STAMP=984353151filename=/u01/app/oradata/ora235/sysaux01.dbfdatafile3switchedtodatafilecopyinputdatafilecopyRECID=2STAMP=984353151filename=/u01/app/oradata/ora235/undotbs01.dbfdatafile4switchedtodatafilecopyinputdatafilecopyRECID=3STAMP=984353151filename=/u01/app/oradata/ora235/users01.dbfdatafile5switchedtodatafilecopyinputdatafilecopyRECID=4STAMP=984353151filename=/data/oracle/data/lottu01.dbfReenablingcontrolfileoptionsforauxiliarydatabaseExecuting:alterdatabaseforceloggingcontentsofMemoryScript:{Alterclonedatabaseopenresetlogs;}executingMemoryScriptdatabaseopenedExecuting:alterdatabaseflashbackonFinishedDuplicateDbat16-AUG-18
以上是“如何使用rman克隆Oracle”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
