NBU for Oracle 异机恢复Word文档下载推荐.docx
- 文档编号:22587943
- 上传时间:2023-02-04
- 格式:DOCX
- 页数:16
- 大小:727.19KB
NBU for Oracle 异机恢复Word文档下载推荐.docx
《NBU for Oracle 异机恢复Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《NBU for Oracle 异机恢复Word文档下载推荐.docx(16页珍藏版)》请在冰豆网上搜索。
点击编辑客户机列表;
添加目标和源客户机主机名
选择源客户机和目标客户机以及备份类型
点击SelectforRestore
选择最新的控制文件
点击Action>
Restore
选择恢复目标文件目录
查看恢复状态。
控制文件恢复到异机磁盘完毕后:
a.进入oracle用户
$rman
RMAN>
connecttarget/
Connectedtotargetdatabase:
DCTM(notmount)
setdbid=3248879935
setdbid=702089904
b.使用RMANrestore已经恢复到本地磁盘的控制文件
run{
2>
allocatechannelch00typedisk;
3>
restorecontrolfilefrom‘/usr/openv/script/control.ora’;
4>
releasechannelch00;
5>
}
c.将数据库置于mount状态:
Alterdatabasemount;
d.使用RMAN恢复数据文件;
8.异机恢复数据文件
run{
allocatechannelch00type'
sbt_tape'
;
send'
NB_ORA_CLIENT=eas02,NB_ORA_SERV=backup'
restoredatabase;
releasechannelch00;
6>
}
以上执行的是将数据文件基本恢复到oradata中,然后执行recover
NB_ORA_CLIENT=svc,NB_ORA_SERV=waanbu1'
recoverdatabase;
allocatedchannel:
ch00
channelch00:
sid=1639devtype=SBT_TAPE
VeritasNetBackupforOracle-Release7.0(2010010501)
sentcommandtochannel:
Startingrecoverat16-MAR-11
startingincrementaldatafilebackupsetrestore
specifyingdatafile(s)torestorefrombackupset
destinationforrestoreofdatafile00120:
/oraapp1/oradata/dctm/dm_CNPDC_PK_db.dbf
destinationforrestoreofdatafile00129:
/oraapp1/oradata/dctm/dm_CNPDC_XA_ind.dbf
destinationforrestoreofdatafile00131:
/oraapp1/oradata/dctm/dm_CNPDC_CQ_ind.dbf
destinationforrestoreofdatafile00133:
/oraapp1/oradata/dctm/dm_CNPDC_JA_ind.dbf
destinationforrestoreofdatafile00135:
/oraapp1/oradata/dctm/dm_CNPDC_LJ_ind.dbf
readingfrombackuppiecebk_789_1_745784966
restoredbackuppiece1
piecehandle=bk_789_1_745784966tag=HOT_DB_BK_LEVEL0
restorecomplete,elapsedtime:
00:
01:
05
destinationforrestoreofdatafile00009:
/oraapp1/oradata/dctm/dm_CNPDC_AC_db.dbf
destinationforrestoreofdatafile00023:
/oraapp1/oradata/dctm/dm_CNPDC_MX_ind.dbf
destinationforrestoreofdatafile00048:
/oraapp1/oradata/dctm/dm_CNPDC_BZ_db.dbf
destinationforrestoreofdatafile00089:
/oraapp1/oradata/dctm/dm_CNPDC_CK_ind.dbf
destinationforrestoreofdatafile00096:
/oraapp1/oradata/dctm/dm_CNPDC_HY_db.dbf
readingfrombackuppiecebk_798_1_745785550
piecehandle=bk_798_1_745785550tag=HOT_DB_BK_LEVEL0
destinationforrestoreofdatafile00058:
/oraapp1/oradata/dctm/dm_CNPDC_WA_db.dbf
destinationforrestoreofdatafile00082:
/oraapp1/oradata/dctm/dm_CNPDC_CG_db.dbf
destinationforrestoreofdatafile00109:
/oraapp1/oradata/dctm/dm_CNPDC_AZ_ind.dbf
destinationforrestoreofdatafile00116:
/oraapp1/oradata/dctm/dm_CNPDC_BN_db.dbf
destinationforrestoreofdatafile00128:
/oraapp1/oradata/dctm/dm_CNPDC_XA_db.dbf
readingfrombackuppiecebk_808_1_745786140
piecehandle=bk_808_1_745786140tag=HOT_DB_BK_LEVEL0
startingmediarecovery
startingarchivelogrestoretodefaultdestination
restoringarchivelog
archivelogthread=1sequence=14970
archivelogthread=1sequence=14971
archivelogthread=1sequence=14972
readingfrombackuppieceal_821_1_745786849
piecehandle=al_821_1_745786849tag=TAG20110314T185921
00:
55
archivelogfilename=/oraapp1/archivelog/1_14970_727030399.dbfthread=1sequence=14970
archivelogfilename=/oraapp1/archivelog/1_14971_727030399.dbfthread=1sequence=14971
archivelogfilename=/oraapp1/archivelog/1_14972_727030399.dbfthread=1sequence=14972
archivelogthread=1sequence=14982
archivelogthread=1sequence=14983
archivelogthread=1sequence=14984
archivelogthread=1sequence=14985
archivelogthread=1sequence=14986
archivelogthread=1sequence=14987
archivelogthread=1sequence=14988
archivelogthread=1sequence=14989
archivelogthread=1sequence=14990
readingfrombackuppieceal_824_1_745808362
piecehandle=al_824_1_745808362tag=TAG20110315T005922
15
archivelogthread=1sequence=14973
archivelogthread=1sequence=14974
archivelogthread=1sequence=14975
archivelogthread=1sequence=14976
archivelogthread=1sequence=14977
archivelogthread=1sequence=14978
archivelogthread=1sequence=14979
archivelogthread=1sequence=14980
archivelogthread=1sequence=14981
readingfrombackuppieceal_823_1_745808362
piecehandle=al_823_1_745808362tag=TAG20110315T005922
archivelogfilename=/oraapp1/archivelog/1_14973_727030399.dbfthread=1sequence=14973
archivelogfilename=/oraapp1/archivelog/1_14974_727030399.dbfthread=1sequence=14974
archivelogfilename=/oraapp1/archivelog/1_14975_727030399.dbfthread=1sequence=14975
archivelogfilename=/oraapp1/archivelog/1_14976_727030399.dbfthread=1sequence=14976
archivelogfilename=/oraapp1/archivelog/1_14977_727030399.dbfthread=1sequence=14977
archivelogfilename=/oraapp1/archivelog/1_14978_727030399.dbfthread=1sequence=14978
archivelogfilename=/oraapp1/archivelog/1_14979_727030399.dbfthread=1sequence=14979
archivelogfilename=/oraapp1/archivelog/1_14980_727030399.dbfthread=1sequence=14980
archivelogfilename=/oraapp1/archivelog/1_14981_727030399.dbfthread=1sequence=14981
archivelogfilename=/oraapp1/archivelog/1_14982_727030399.dbfthread=1sequence=14982
archivelogfilename=/oraapp1/archivelog/1_14983_727030399.dbfthread=1sequence=14983
archivelogfilename=/oraapp1/archivelog/1_14984_727030399.dbfthread=1sequence=14984
archivelogfilename=/oraapp1/archivelog/1_14985_727030399.dbfthread=1sequence=14985
archivelogfilename=/oraapp1/archivelog/1_14986_727030399.dbfthread=1sequence=14986
archivelogfilename=/oraapp1/archivelog/1_14987_727030399.dbfthread=1sequence=14987
archivelogfilename=/oraapp1/archivelog/1_14988_727030399.dbfthread=1sequence=14988
archivelogfilename=/oraapp1/archivelog/1_14989_727030399.dbfthread=1sequence=14989
archivelogfilename=/oraapp1/archivelog/1_14990_727030399.dbfthread=1sequence=14990
unabletofindarchivelog
archivelogthread=1sequence=14991
releasedchannel:
RMAN-00571:
===========================================================
RMAN-00569:
===============ERRORMESSAGESTACKFOLLOWS===============
RMAN-03002:
failureofrecovercommandat03/16/201112:
18:
06
RMAN-06054:
mediarecoveryrequestingunknownlog:
thread1seq14991lowscn403666149
以上报错是因为需要将数据库置于新的归档中
$sqlplus/nolog
SQL*Plus:
Release10.2.0.4.0-ProductiononWedMar1612:
23:
462011
Copyright(c)1982,2007,Oracle.AllRightsReserved.
SQL>
conn/assysdba;
Connected.
SQL>
shutdownimmediate
ORA-01109:
databasenotopen
Databasedismounted.
ORACLEinstanceshutdown.
startupmount
ORACLEinstancestarted.
TotalSystemGlobalArea2.3622E+10bytes
FixedSize2126584bytes
VariableSize1.4194E+10bytes
DatabaseBuffers9412018176bytes
RedoBuffers14647296bytes
Databasemounted.
recoverdatabaseusingbackupcontrolfileuntilcancel;
ORA-00279:
change403666149generatedat03/15/201100:
59:
22neededforthread
1
ORA-00289:
suggestion:
/oraapp1/archivelog/1_14991_727030399.dbf
ORA-00280:
change403666149forthread1isinsequence#14991
Specifylog:
{<
RET>
=suggested|filename|AUTO|CANCEL}
cancel
Mediarecoverycancelled.
alterdatabaseopenresetlogs;
Databasealtered.
select*status,instance_namefromV$instance;
STATUSINSTANCE_NAME
----------------------------
OPENdctm
确认数据库可正常启动并能使用
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- NBU for Oracle 异机恢复 恢复