使用duplication创建auxiliaryinstance的基本步骤

《使用duplication创建auxiliaryinstance的基本步骤》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、使用Duplication创建AuxiliaryInstance的基本步骤PreparingtheAuxiliaryInstanceforDuplication:BasicStepsPerformthesetasksbeforeperformingRMANduplication:Task1:CreateanOraclePasswordFilefortheAuxiliaryInstanceTask2:EnsureOracleNetConnectivitytotheAuxiliaryInstanceTask3:CreateanInitial

2、izationParameterFilefortheAuxiliaryInstanceTask4:StarttheAuxiliaryInstanceTask5:MountorOpentheTargetDatabaseTask6:MakeSureYouHavetheNecessaryBackupsandArchivedRedoLogsTask7:AllocateAuxiliaryChannelsifAutomaticChannelsAreNotConfigured下面是具体的执行过程：1、CreateanOraclePasswordFil

3、efortheAuxiliaryInstance[oracle@localhostdbs]$pwd/opt/oracle/product/10.2.0/dbs[oracle@localhostdbs]$orapwdFILE=/opt/oracle/product/10.2.0/dbs/orapwdupgePASSWORD=testENTRIES=30[oracle@localhost~]$cd/opt/oracle/product/10.2.0/dbs[oracle@localhostdbs]$ls-lorapwdupge-rw-r--

4、---1oracleoinstall5120Dec720:43orapwdupge2、EnsureOracleNetConnectivitytotheAuxiliaryInstance[oracle@localhostdbs]$cd/opt/oracle/product/10.2.0/network/admin[oracle@localhostadmin]$catlistener.ora#listener.oraNetworkConfigurationFile:/opt/oracle/product/10.2.0/network/adm

5、in/listener.ora#GeneratedbyOracleconfigurationtools.SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=/opt/oracle/product/10.2.0)(PROGRAM=extproc))(SID_DESC=(GLOBAL_DBNAME=ge02)(ORACLE_HOME=/opt/oracle/product/10.2.0)(SID_NAME=ge02))(SID_DESC=(GLOBA

6、L_DBNAME=cata)(ORACLE_HOME=/opt/oracle/product/10.2.0)(SID_NAME=cata))(SID_DESC=(GLOBAL_DBNAME=ge)(ORACLE_HOME=/opt/oracle/product/10.2.0)(SID_NAME=ge))(SID_DESC=(GLOBAL_DBNAME=dupge)(ORACLE_HOME=/opt/oracle/product/10.2.0)(SID_NAME=dupge))--此处是新增加的部分)LISTENER=(DESCRIPTI

7、ON_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))))EXTPROC_CONNECTION_DATA=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))(CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION=RO)))重新启动下监听：[

8、oracle@localhostadmin]$lsnrctlstopLSNRCTLforLinux:Version10.2.0.1.0-Productionon07-DEC-200820:57:24Copy