Oracle Ebs Clone DB Using Rman Hot Backup.docx
- 文档编号:12367836
- 上传时间:2023-04-18
- 格式:DOCX
- 页数:11
- 大小:17.65KB
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页珍藏版)》请在冰豆网上搜索。
OracleEbsCloneDBUsingRmanHotBackup
此文档接OracleEbsCloneDBUsingRmanHotBackup
(一)
示例如下(rmanrestore这一部分略):
Step1,略
文档仅涉及Oracleebs系统在正式库不停机情况下,使用正式库的rman备份来克隆DB.大体步骤如下:
1, 利用rmanrestore备份文件到指定目录
2, 以OracleDB用户登入
a) cd
b) perladcfgclone.pldbTechStack
3, 手动创建数据库控制文件,并恢复打开数据库
a) Runningthelibraryupdatescript
cd
b) sqlplus"/assysdba"@adupdlib.sql
where
4, 最后配置数据库,DBClone整个过程完成。
a) cd
b) perladcfgclone.pldbconfig
wheretargetcontextfileis:
此文档示例部分:
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
注:
where
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle Ebs Clone DB Using Rman Hot Backup