收藏
下载资源下载资源 加入VIP,免费下载

Oracle Ebs Clone DB Using Rman Hot Backup.docx

上传人：b****5 文档编号：12367836 上传时间：2023-04-18 格式：DOCX 页数：11 大小：17.65KB
下载 相关 举报
Oracle Ebs Clone DB Using Rman Hot Backup.docx_第1页
第1页 / 共11页
Oracle Ebs Clone DB Using Rman Hot Backup.docx_第2页
第2页 / 共11页
Oracle Ebs Clone DB Using Rman Hot Backup.docx_第3页
第3页 / 共11页
Oracle Ebs Clone DB Using Rman Hot Backup.docx_第4页
第4页 / 共11页
Oracle Ebs Clone DB Using Rman Hot Backup.docx_第5页
第5页 / 共11页
点击查看更多>>
下载资源
资源描述

Oracle Ebs Clone DB Using Rman Hot Backup.docx

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

Oracle Ebs Clone DB Using Rman Hot Backup.docx

OracleEbsCloneDBUsingRmanHotBackup

 

此文档接OracleEbsCloneDBUsingRmanHotBackup

（一）

示例如下（rmanrestore这一部分略）：

Step1,略

文档仅涉及Oracleebs系统在正式库不停机情况下，使用正式库的rman备份来克隆DB.大体步骤如下：

1，   利用rmanrestore备份文件到指定目录

2，   以OracleDB用户登入

a）        cd/appsutil/clone/bin

b）       perladcfgclone.pldbTechStack

3，   手动创建数据库控制文件，并恢复打开数据库

a）        Runningthelibraryupdatescript

cd/appsutil/install/

b）       sqlplus"/assysdba"@adupdlib.sql

whereis"sl"forHP-UX,"so"foranyotherUNIXplatformandnotrequiredforWindows.

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

a）        cd/appsutil/clone/bin

b）       perladcfgclone.pldbconfig

wheretargetcontextfileis:

/appsutil/.

此文档示例部分：

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

root@JNERP#su-oratest

SunMicrosystemsInc.  SunOS5.10     GenericJanuary2005

&VCPUB@**

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

Can'topenperlscript"adcfgclone.pl":

Nosuchfileordirectory

$cd$ORACLE_HOME/appsutil/clone/bin

$ls

CloneContext_10191031.logadchkutl.sh               adclonectx.pl

adcfgclone.pl             adclone.pl

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

EntertheAPPSpassword[APPS]:

apps

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=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:

37:

25

Uptime                   0days0hr.6min.39sec

TraceLevel              off

Security                 OFF

SNMP                     OFF

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"PLSExtProc",statusUNKNOWN,has1handler（s）forthisservice...

Service"TEST"has1instance（s）.

Instance"TEST",statusUNKNOWN,has1handler（s）forthisservice...

Thecommandcompletedsuccessfully

Step3,

$sqlplus'/assysdba'

SQL*Plus:

Release9.2.0.6.0-ProductiononSunOct1910:

44:

152008

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

Connectedtoanidleinstance.

SQL>startupnomount;

ORACLEinstancestarted.

TotalSystemGlobalArea598707096bytes

FixedSize                  732056bytes

VariableSize            419430400bytes

DatabaseBuffers         167772160bytes

RedoBuffers              10772480bytes

SQL>CREATECONTROLFILEREUSESETDATABASE"TEST"

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   ）SIZE100M,

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文件，可作为模板编辑。

SQL>selectinstance_name,statusfromv$instance;

INSTANCE_NAME   STATUS

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

TEST            MOUNTED

SQL>alterdatabaseopenresetlogs;

Databasealtered.

SQL>selectinstance_name,statusfromv$instance;

INSTANCE_NAME   STATUS

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

TEST            OPEN

SQL>altertablespaceTEMPaddtempfile'/t02/testdata/temp01.dbf'REUSE;

Tablespacealtered.

SQL>ALTERDATABASERENAMEGLOBAL_NAMETO"TEST.TT.COM.CN";

Databasealtered.

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

注：

whereis"sl"forHP-UX,"so"foranyotherUNIXplatformandnotrequiredforWindows.

PL/SQLproceduresuccessfullycompleted.

SQL>exit

DisconnectedfromOracle9iEnterpriseEditionRelease9.2.0.6.0-64bitProduction

WiththePartitioning,OLAPandOracleDataMiningoptions

JServerRelease9.2.0.6.0-Production

$pwd

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

$ls

CloneContext_10191031.logadchkutl.sh               adclonectx.pl

adcfgclone.pl             adclone.pl

Step4,

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

EntertheAPPSpassword[APPS]:

apps

RunningRapidClonewithcommand:

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

展开阅读全文
相关资源
猜你喜欢
相关搜索

当前位置：首页 >

copyright@ 2008-2022 冰豆网网站版权所有

经营许可证编号:鄂ICP备2022015515号-1