Oracle Ebs Clone DB Using Rman Hot Backup.docx

1、Oracle Ebs Clone DB Using Rman Hot Backup此文档接 Oracle Ebs Clone DB Using Rman Hot Backup （一）示例如下(rman restore这一部分略)：Step 1, 略文档仅涉及Oracle ebs 系统在正式库不停机情况下，使用正式库的rman备份来克隆DB.大体步骤如下： 1， 利用rman restore 备份文件到指定目录2， 以Oracle DB用户登入a) cd /appsutil/clone/bin b) perl adcfgclone.pl dbTechStack 3， 手动创建数据库控制文件，并恢

2、复打开数据库a) Running the library update scriptcd /appsutil/install/ b) sqlplus / as sysdba adupdlib.sql where is sl for HP-UX, so for any other UNIX platform and not required for Windows. 4， 最后配置数据库，DB Clone整个过程完成。a) cd /appsutil/clone/bin b) perl adcfgclone.pl dbconfig where target context file is:/app

3、sutil/.此文档示例部分：Oracle Ebs Clone DB Using Rman Hot Backup （二）Step 2,rootJNERP # su - oratestSun Microsystems Inc. SunOS 5.10 Generic January 2005&VCPUB*You have mail.$ cd $ORACLE_HOME/appsutil/clone/bin$ perl adcfgclone.pl dbTechStackEnter the APPS password APPS:appsFirst Creating a new context file

4、for the cloned system.The program is going to ask you for information about the new system:Provide the values required for creation of the new Database Context file.Do you want to use a virtual hostname for the target node (y/n) n ?:Target instance is a Real Application Cluster (RAC) instance (y/n)

5、n:Target System database name PROD:TESTOracle OS User oraprod:oratestTarget system RDBMS ORACLE_HOME directory /appprod/proddb/9.2.0:/t02/testdb/9.2.0Target system utl_file accessible directories list /usr/tmp:Number of DATA_TOPs on the target system 4:1Target system DATA_TOP 1:/t02/testdataDo you w

6、ant to preserve the Display set to jnerp:0.0 (y/n) y ?:Clone Context uses the same port pool mechanism as the Rapid InstallOnce you choose a port pool, Clone Context will validate the port availability.Enter the port pool number 0-99:3Checking the port pool 3done: Port Pool 3 is freeDatabase port is

7、 1524Creating the new Database Context file from :/appprod/proddb/9.2.0/appsutil/template/adxdbctx.tmpThe new database context file has been created :/t02/testdb/9.2.0/appsutil/TEST_jnerp.xmlLog file located at /t02/testdb/9.2.0/appsutil/clone/bin/CloneContext_10191031.logRunning Rapid Clone with co

8、mmand: perl /t02/testdb/9.2.0/appsutil/clone/bin/adclone.pl java=/t02/testdb/9.2.0/appsutil/clone/bin/./jre mode=apply stage=/t02/testdb/9.2.0/appsutil/clone/bin/. component=dbTechStack method=CUSTOM dbctxtg=/t02/testdb/9.2.0/appsutil/TEST_jnerp.xml showProgress contextValidated=trueNo write permiss

9、ions to the Inventory pointed by: /var/opt/oracle/oraInventoryRapid Clone needs to be able to write to the inventoryPlease run the script /tmp/orainstRoot.sh as rootRestart adclone.pl after performing required corrections.ERROR: Failed to execute /t02/testdb/9.2.0/appsutil/clone/bin/adclone.pl Pleas

10、e check logfile. $ su rootPassword: # /tmp/orainstRoot.shrootJNERP # su - oratestSun Microsystems Inc. SunOS 5.10 Generic January 2005&VCPUB*$ perl adcfgclone.pl dbTechStack /t02/testdb/9.2.0/appsutil/TEST_jnerp.xmlCant open perl script adcfgclone.pl: No such file or directory$ cd $ORACLE_HOME/appsu

11、til/clone/bin$ lsCloneContext_10191031.log adchkutl.sh adclonectx.pladcfgclone.pl adclone.pl$ perl adcfgclone.pl dbTechStack /t02/testdb/9.2.0/appsutil/TEST_jnerp.xmlEnter the APPS password APPS:appsRunning Rapid Clone with command: perl /t02/testdb/9.2.0/appsutil/clone/bin/adclone.pl java=/t02/test

12、db/9.2.0/appsutil/clone/bin/./jre mode=apply stage=/t02/testdb/9.2.0/appsutil/clone/bin/. component=dbTechStack method=CUSTOM dbctxtg=/t02/testdb/9.2.0/appsutil/TEST_jnerp.xml showProgress contextValidated=falseBeginning rdbms home Apply - Sun Oct 19 10:35:09 2008Log file located at /t02/testdb/9.2.

13、0/appsutil/log/TEST_jnerp/ApplyDBTechStack_10191035.log Completed Apply.Sun Oct 19 10:37:17 2008Beginning APPSDB_TEST registration to central inventory.ORACLE_HOME NAME : APPSDB_TESTORACLE_HOME PATH : /t02/testdb/9.2.0Using Inventory location in /var/opt/oracle/oraInst.locLog file located at /var/op

14、t/oracle/oraInventory/logs/OracleHomeCloner_10191037.logORACLE_HOME /t02/testdb/9.2.0 was registered successfully.Starting database listener for TEST:Running:/t02/testdb/9.2.0/appsutil/scripts/TEST_jnerp/addlnctl.sh start TESTYou are running addlnctl.sh version 115.6Logfile: /t02/testdb/9.2.0/appsut

15、il/log/TEST_jnerp/addlnctl.txtStarting listener process TEST .addlnctl.sh: exiting with status 0$ lsnrctl status testLSNRCTL for Solaris: Version 9.2.0.6.0 - Production on 19-OCT-2008 10:44:05Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=

16、EXTPROCTEST)STATUS of the LISTENER-Alias TESTVersion TNSLSNR for Solaris: Version 9.2.0.6.0 - ProductionStart Date 19-OCT-2008 10:37:25Uptime 0 days 0 hr. 6 min. 39 secTrace Level offSecurity OFFSNMP OFFListener Log File /t02/testdb/9.2.0/network/admin/test.logListening Endpoints Summary.(DESCRIPTIO

17、N=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCTEST)(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=JNERP)(PORT=1524)Services Summary.Service PLSExtProc has 1 instance(s).Instance PLSExtProc, status UNKNOWN, has 1 handler(s) for this service.Service TEST has 1 instance(s).Instance TEST, status UNKNOWN, has 1 handle

18、r(s) for this service.The command completed successfullyStep 3,$ sqlplus / as sysdbaSQL*Plus: Release 9.2.0.6.0 - Production on Sun Oct 19 10:44:15 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to an idle instance.SQL startup nomount;ORACLE instance started.Total Sy

19、stem Global Area 598707096 bytesFixed Size 732056 bytesVariable Size 419430400 bytesDatabase Buffers 167772160 bytesRedo Buffers 10772480 bytesSQL CREATE CONTROLFILE REUSE SET DATABASE TEST2 LOGFILE3 GROUP 1 (4 /t02/testdata/log01a.ora,5 /t02/testdata/log01b.ora6 ) SIZE 100M,7 GROUP 2 (8 /t02/testda

20、ta/log02a.ora,9 /t02/testdata/log02b.ora10 ) SIZE 100M,11 GROUP 3 (12 /t02/testdata/log03a.ora,13 /t02/testdata/log03b.ora14 ) SIZE 100M15 DATAFILE16 /t02/testdata/system01.dbf,17 /t02/testdata/system02.dbf,18 /t02/testdata/system03.dbf,19 /t02/testdata/system04.dbf,20 /t02/testdata/system05.dbf,21

21、/t02/testdata/system06.dbf,22 /t02/testdata/system07.dbf,23 /t02/testdata/system08.dbf,24 /t02/testdata/system09.dbf,25 /t02/testdata/system10.dbf,26 /t02/testdata/system11.dbf,27 /t02/testdata/undo01.dbf,28 /t02/testdata/a_archive01.dbf,29 /t02/testdata/a_int01.dbf,30 /t02/testdata/a_media01.dbf,31

22、 /t02/testdata/a_nolog01.dbf,32 /t02/testdata/a_queue01.dbf,33 /t02/testdata/a_queue02.dbf,34 /t02/testdata/a_ref01.dbf,35 /t02/testdata/a_ref02.dbf,36 /t02/testdata/a_summ01.dbf,37 /t02/testdata/a_txn_data01.dbf,38 /t02/testdata/a_txn_data02.dbf,39 /t02/testdata/a_txn_data03.dbf,40 /t02/testdata/a_

23、txn_ind01.dbf,41 /t02/testdata/a_txn_ind02.dbf,42 /t02/testdata/a_txn_ind03.dbf,43 /t02/testdata/a_txn_ind04.dbf,44 /t02/testdata/a_txn_ind05.dbf,45 /t02/testdata/ctxd01.dbf,46 /t02/testdata/odm.dbf,47 /t02/testdata/olap.dbf,48 /t02/testdata/owad01.dbf,49 /t02/testdata/portal01.dbf,50 /t02/testdata/

24、tvsn_data01.dbf,51 /t02/testdata/tvsn_data02.dbf,52 /t02/testdata/tvsn_idx01.dbf,53 /t02/testdata/tvsn_idx02.dbf,54 /t02/testdata/tvsn_data21.dbf,55 /t02/testdata/tvsn_data22.dbf,56 /t02/testdata/tvsn_idx21.dbf,57 /t02/testdata/tvsn_idx22.dbf,58 /t02/testdata/undo02.dbf,59 /t02/testdata/perfstat.dbf

25、60 RESETLOGS MAXDATAFILES 51261 MAXINSTANCES 862 MAXLOGFILES 3263 MAXLOGHISTORY 726064 MAXLOGMEMBERS 565 ;Control file created.注：创建控制文件可参考$ORACLE_HOME/appsutil/clone/data/stage/adcrdb.zip下的adcrdb.sh adcrdbclone.sql，dbfinfo.lst文件，可作为模板编辑。SQL select instance_name,status from v$instance;INSTANCE_NAME S

26、TATUS- -TEST MOUNTEDSQL alter database open resetlogs;Database altered.SQL select instance_name,status from v$instance;INSTANCE_NAME STATUS- -TEST OPENSQL alter tablespace TEMP add tempfile /t02/testdata/temp01.dbf REUSE;Tablespace altered.SQL ALTER DATABASE RENAME GLOBAL_NAME TO TEST.TT.COM.CN;Data

27、base altered.SQL $ORACLE_HOME/appsutil/install/TEST_jnerp/adupdlib.sql so注：where is sl for HP-UX, so for any other UNIX platform and not required for Windows.PL/SQL procedure successfully completed.SQL exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionWith the Par

28、titioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.6.0 - Production$ pwd/t02/testdb/9.2.0/appsutil/clone/bin$ lsCloneContext_10191031.log adchkutl.sh adclonectx.pladcfgclone.pl adclone.plStep 4,$ perl adcfgclone.pl dbconfig /t02/testdb/9.2.0/appsutil/TEST_jnerp.xmlEnter the APPS password APPS:appsRunning Rapid Clone with command: perl /t02/testdb/9.2.0/appsutil/clone/bin/adclone.pl