Oracle Ebs Clone DB Using Rman Hot BackupWord格式.docx

Oracle Ebs Clone DB Using Rman Hot BackupWord格式.docx

《Oracle Ebs Clone DB Using Rman Hot BackupWord格式.docx》由会员分享，可在线阅读，更多相关《Oracle Ebs Clone DB Using Rman Hot BackupWord格式.docx（11页珍藏版）》请在冰点文库上搜索。

最后配置数据库，DBClone整个过程完成。

perladcfgclone.pldbconfig<

targetcontextfile>

wheretargetcontextfileis:

<

/appsutil/<

TargetCONTEXT_NAME>

.

此文档示例部分：

OracleEbsCloneDBUsingRmanHotBackup

（二）

Step2,

root@JNERP#su-oratest

SunMicrosystemsInc. 

SunOS5.10 

GenericJanuary2005

&

VCPUB@**

Youhavemail.

$cd$ORACLE_HOME/appsutil/clone/bin

$perladcfgclone.pldbTechStack

EntertheAPPSpassword[APPS]:

apps

FirstCreatinganewcontextfilefortheclonedsystem.

Theprogramisgoingtoaskyouforinformationaboutthenewsystem:

ProvidethevaluesrequiredforcreationofthenewDatabaseContextfile.

Doyouwanttouseavirtualhostnameforthetargetnode（y/n）[n]?

:

TargetinstanceisaRealApplicationCluster（RAC）instance（y/n）[n]:

TargetSystemdatabasename[PROD]:

TEST

OracleOSUser[oraprod]:

oratest

TargetsystemRDBMSORACLE_HOMEdirectory[/appprod/proddb/9.2.0]:

/t02/testdb/9.2.0

Targetsystemutl_fileaccessibledirectorieslist[/usr/tmp]:

NumberofDATA_TOP'

sonthetargetsystem[4]:

1

TargetsystemDATA_TOP1:

/t02/testdata

DoyouwanttopreservetheDisplaysettojnerp:

0.0（y/n）[y]?

CloneContextusesthesameportpoolmechanismastheRapidInstall

Onceyouchooseaportpool,CloneContextwillvalidatetheportavailability.

Entertheportpoolnumber[0-99]:

3

Checkingtheportpool3

done:

PortPool3isfree

Databaseportis1524

CreatingthenewDatabaseContextfilefrom:

/appprod/proddb/9.2.0/appsutil/template/adxdbctx.tmp

Thenewdatabasecontextfilehasbeencreated:

/t02/testdb/9.2.0/appsutil/TEST_jnerp.xml

Logfilelocatedat/t02/testdb/9.2.0/appsutil/clone/bin/CloneContext_10191031.log

RunningRapidClonewithcommand:

perl/t02/testdb/9.2.0/appsutil/clone/bin/adclone.pljava=/t02/testdb/9.2.0/appsutil/clone/bin/../jremode=applystage=/t02/testdb/9.2.0/appsutil/clone/bin/..component=dbTechStackmethod=CUSTOMdbctxtg=/t02/testdb/9.2.0/appsutil/TEST_jnerp.xmlshowProgresscontextValidated=true

NowritepermissionstotheInventorypointedby:

/var/opt/oracle/oraInventory

RapidCloneneedstobeabletowritetotheinventory

Pleaserunthescript/tmp/orainstRoot.shasroot

Restartadclone.plafterperformingrequiredcorrections.

ERROR:

Failedtoexecute/t02/testdb/9.2.0/appsutil/clone/bin/adclone.pl

Pleasechecklogfile.

$suroot

Password:

#/tmp/orainstRoot.sh

$perladcfgclone.pldbTechStack/t02/testdb/9.2.0/appsutil/TEST_jnerp.xml

Can'

topenperlscript"

adcfgclone.pl"

Nosuchfileordirectory

$ls

CloneContext_10191031.logadchkutl.sh 

adclonectx.pl

adcfgclone.pl 

adclone.pl

perl/t02/testdb/9.2.0/appsutil/clone/bin/adclone.pljava=/t02/testdb/9.2.0/appsutil/clone/bin/../jremode=applystage=/t02/testdb/9.2.0/appsutil/clone/bin/..component=dbTechStackmethod=CUSTOMdbctxtg=/t02/testdb/9.2.0/appsutil/TEST_jnerp.xmlshowProgresscontextValidated=false

BeginningrdbmshomeApply-SunOct1910:

35:

092008

Logfilelocatedat/t02/testdb/9.2.0/appsutil/log/TEST_jnerp/ApplyDBTechStack_10191035.log

CompletedApply...

SunOct1910:

37:

172008

BeginningAPPSDB_TESTregistrationtocentralinventory...

ORACLE_HOMENAME 

:

APPSDB_TEST

ORACLE_HOMEPATH 

/t02/testdb/9.2.0

UsingInventorylocationin/var/opt/oracle/oraInst.loc

Logfilelocatedat/var/opt/oracle/oraInventory/logs/OracleHomeCloner_10191037.log

ORACLE_HOME/t02/testdb/9.2.0wasregisteredsuccessfully.

StartingdatabaselistenerforTEST:

Running:

/t02/testdb/9.2.0/appsutil/scripts/TEST_jnerp/addlnctl.shstartTEST

Youarerunningaddlnctl.shversion115.6

Logfile:

/t02/testdb/9.2.0/appsutil/log/TEST_jnerp/addlnctl.txt

StartinglistenerprocessTEST...

addlnctl.sh:

exitingwithstatus0

$lsnrctlstatustest

LSNRCTLforSolaris:

Version9.2.0.6.0-Productionon19-OCT-200810:

44:

05

Copyright（c）1991,2002,OracleCorporation.Allrightsreserved.

Connectingto（ADDRESS=（PROTOCOL=IPC）（KEY=EXTPROCTEST））

STATUSoftheLISTENER

------------------------

Alias 

TEST

Version 

TNSLSNRforSolaris:

Version9.2.0.6.0-Production

StartDate 

19-OCT-200810:

25

Uptime 

0days0hr.6min.39sec

TraceLevel 

off

Security 

OFF

SNMP 

ListenerLogFile 

/t02/testdb/9.2.0/network/admin/test.log

ListeningEndpointsSummary...

（DESCRIPTION=（ADDRESS=（PROTOCOL=ipc）（KEY=EXTPROCTEST）））

（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=JNERP）（PORT=1524）））

ServicesSummary...

Service"

PLSExtProc"

has1instance（s）.

Instance"

statusUNKNOWN,has1handler（s）forthisservice...

TEST"

Thecommandcompletedsuccessfully

Step3,

$sqlplus'

/assysdba'

SQL*Plus:

Release9.2.0.6.0-ProductiononSunOct1910:

152008

Copyright（c）1982,2002,OracleCorporation.Allrightsreserved.

Connectedtoanidleinstance.

SQL>

startupnomount;

ORACLEinstancestarted.

TotalSystemGlobalArea598707096bytes

FixedSize 

732056bytes

VariableSize 

419430400bytes

DatabaseBuffers 

167772160bytes

RedoBuffers 

10772480bytes

CREATECONTROLFILEREUSESETDATABASE"

2LOGFILE

3 

GROUP1（

4 

'

/t02/testdata/log01a.ora'

5 

/t02/testdata/log01b.ora'

6 

）SIZE100M,

7 

GROUP2（

8 

/t02/testdata/log02a.ora'

9 

/t02/testdata/log02b.ora'

10 

11 

GROUP3（

12 

/t02/testdata/log03a.ora'

13 

/t02/testdata/log03b.ora'

14 

）SIZE100M

15DATAFILE

16 

/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 

/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 

/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_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/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'

60RESETLOGSMAXDATAFILES512

61MAXINSTANCES8

62MAXLOGFILES32

63MAXLOGHISTORY7260

64MAXLOGMEMBERS5

65;

Controlfilecreated.

注：

创建控制文件可参考$ORACLE_HOME/appsutil/clone/data/stage/adcrdb.zip下的adcrdb.shadcrdbclone.sql，dbfinfo.lst文件，可作为模板编辑。

selectinstance_name,statusfromv$instance;

INSTANCE_NAME 

STATUS

----------------------------

TEST 

MOUNTED

alterdatabaseopenresetlogs;

Databasealtered.

OPEN

altertablespaceTEMPaddtempfile'

/t02/testdata/temp01.dbf'

REUSE;

Tablespacealtered.

ALTERDATABASERENAMEGLOBAL_NAMETO"

TEST.TT.COM.CN"

;

@$ORACLE_HOME/appsutil/install/TEST_jnerp/adupdlib.sqlso

foranyotherUNIXplatformandnotrequiredforWindows.

PL/SQLproceduresuccessfullycompleted.

exit

DisconnectedfromOracle9iEnterpriseEditionRelease9.2.0.6.0-64bitProduction

WiththePartitioning,OLAPandOracleDataMiningoptions

JServerRelease9.2.0.6.0-Production

$pwd

/t02/testdb/9.2.0/appsutil/clone/bin

Step4,

$perladcfgclone.pldbconfig/t02/testdb/9.2.0/appsutil/TEST_jnerp.xml

perl/t02/testdb/9.2.0/appsutil/clone/bin/adclone.pl