oracle11G新版本增加对原始数据文件验证过程.docx
- 文档编号:25769052
- 上传时间:2023-06-13
- 格式:DOCX
- 页数:13
- 大小:16.75KB
oracle11G新版本增加对原始数据文件验证过程.docx
《oracle11G新版本增加对原始数据文件验证过程.docx》由会员分享,可在线阅读,更多相关《oracle11G新版本增加对原始数据文件验证过程.docx(13页珍藏版)》请在冰豆网上搜索。
oracle11G新版本增加对原始数据文件验证过程
oracle11G新版本增加对原始数据文件验证过程
打算做一个oracle索引的专题技术笔记,因为今天帮我一个深圳的朋友做过rman的测试,在恢复我原始数据的时候,发现存在ORA-XXXXX错误,测试结果如下:
run{
allocatechannelch1typedisk;
allocatechannelch2typedisk;
allocatechannelch3typedisk;
allocatechannelch4typedisk;
allocatechannelch5typedisk;
allocatechannelch6typedisk;
restoredatabase;
releasechannelch1;
releasechannelch2;
releasechannelch3;
releasechannelch4;
releasechannelch5;
releasechannelch6;
}
备份过程:
oracle@oracle-one~]$exit
exit
hostcommandcomplete
RMAN>backupdatabaseplusarchivelogdeleteinput;
Startingbackupat13-JAN-14
currentlogarchived
usingchannelORA_DISK_1
channelORA_DISK_1:
startingarchivedlogbackupset
channelORA_DISK_1:
specifyingarchivedlog(s)inbackupset
inputarchivedlogthread=1sequence=32RECID=38STAMP=835887568
inputarchivedlogthread=1sequence=33RECID=43STAMP=835983664
inputarchivedlogthread=1sequence=34RECID=41STAMP=835983651
inputarchivedlogthread=1sequence=35RECID=42STAMP=835983661
channelORA_DISK_1:
startingpiece1at13-JAN-14
channelORA_DISK_1:
finishedpiece1at13-JAN-14
piecehandle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100050_0.302.836733655tag=TAG20140113T100050comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
25
channelORA_DISK_1:
deletingarchivedlog(s)
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_03/thread_1_seq_32.312.835887567RECID=38STAMP=835887568
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_33.310.835983663RECID=43STAMP=835983664
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_34.282.835983651RECID=41STAMP=835983651
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_35.297.835983653RECID=42STAMP=835983661
channelORA_DISK_1:
startingarchivedlogbackupset
channelORA_DISK_1:
specifyingarchivedlog(s)inbackupset
inputarchivedlogthread=1sequence=1RECID=44STAMP=836132585
inputarchivedlogthread=1sequence=2RECID=45STAMP=836165566
inputarchivedlogthread=1sequence=3RECID=46STAMP=836176676
inputarchivedlogthread=1sequence=4RECID=47STAMP=836178950
inputarchivedlogthread=1sequence=5RECID=48STAMP=836232017
inputarchivedlogthread=1sequence=6RECID=49STAMP=836234531
inputarchivedlogthread=1sequence=7RECID=50STAMP=836237972
inputarchivedlogthread=1sequence=8RECID=51STAMP=836256318
inputarchivedlogthread=1sequence=9RECID=52STAMP=836299719
inputarchivedlogthread=1sequence=10RECID=53STAMP=836337512
inputarchivedlogthread=1sequence=11RECID=54STAMP=836494626
inputarchivedlogthread=1sequence=12RECID=55STAMP=836498150
inputarchivedlogthread=1sequence=13RECID=56STAMP=836731893
inputarchivedlogthread=1sequence=14RECID=57STAMP=836733316
inputarchivedlogthread=1sequence=15RECID=58STAMP=836733649
channelORA_DISK_1:
startingpiece1at13-JAN-14
channelORA_DISK_1:
finishedpiece1at13-JAN-14
piecehandle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100050_0.297.836733683tag=TAG20140113T100050comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
35
channelORA_DISK_1:
deletingarchivedlog(s)
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_1.313.836132583RECID=44STAMP=836132585
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_2.314.836165563RECID=45STAMP=836165566
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_3.315.836176677RECID=46STAMP=836176676
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_4.273.836178949RECID=47STAMP=836178950
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_5.280.836232005RECID=48STAMP=836232017
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_6.278.836234531RECID=49STAMP=836234531
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_7.277.836237959RECID=50STAMP=836237972
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_8.272.836256311RECID=51STAMP=836256318
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_08/thread_1_seq_9.271.836299715RECID=52STAMP=836299719
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_08/thread_1_seq_10.308.836337507RECID=53STAMP=836337512
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_10/thread_1_seq_11.307.836494623RECID=54STAMP=836494626
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_10/thread_1_seq_12.306.836498149RECID=55STAMP=836498150
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_13.304.836731889RECID=56STAMP=836731893
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_14.305.836733317RECID=57STAMP=836733316
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_15.303.836733649RECID=58STAMP=836733649
Finishedbackupat13-JAN-14
Startingbackupat13-JAN-14
usingchannelORA_DISK_1
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
specifyingdatafile(s)inbackupset
inputdatafilefilenumber=00001name=+DATAGROUP1/rhys/datafile/system.257.833999503
inputdatafilefilenumber=00002name=+DATAGROUP1/rhys/datafile/sysaux.256.833999647
inputdatafilefilenumber=00006name=+DATAGROUP1/rhys/datafile/rhys.309.835132099
inputdatafilefilenumber=00004name=+DATAGROUP1/rhys/datafile/users.261.833999767
inputdatafilefilenumber=00003name=+DATAGROUP1/rhys/datafile/undotbs1.260.833999753
inputdatafilefilenumber=00005name=+DATAGROUP1/rhys/datafile/test.dbf
channelORA_DISK_1:
startingpiece1at13-JAN-14
channelORA_DISK_1:
finishedpiece1at13-JAN-14
piecehandle=+DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737tag=TAG20140113T100212comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
06:
26
Finishedbackupat13-JAN-14
Startingbackupat13-JAN-14
currentlogarchived
usingchannelORA_DISK_1
channelORA_DISK_1:
startingarchivedlogbackupset
channelORA_DISK_1:
specifyingarchivedlog(s)inbackupset
inputarchivedlogthread=1sequence=16RECID=59STAMP=836734121
channelORA_DISK_1:
startingpiece1at13-JAN-14
channelORA_DISK_1:
finishedpiece1at13-JAN-14
piecehandle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100843_0.274.836734125tag=TAG20140113T100843comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
03
channelORA_DISK_1:
deletingarchivedlog(s)
archivedlogfilename=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_16.276.836734121RECID=59STAMP=836734121
Finishedbackupat13-JAN-14
StartingControlFileandSPFILEAutobackupat13-JAN-14
piecehandle=+DATAGROUP1/rhys/autobackup/2014_01_13/s_836734128.276.836734133comment=NONE
FinishedControlFileandSPFILEAutobackupat13-JAN-14
RMAN>exit
RecoveryManagercomplete.
恢复过程:
[oracle@oracle-one~]$rmantarget/
RecoveryManager:
Release11.2.0.4.0-ProductiononMonJan1320:
41:
182014
Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved.
connectedtotargetdatabase:
RHYS(DBID=2745484551,notopen)
RMAN>run{
2>allocatechannelch1typedisk;
allocatechannelch2typedisk;
3>4>allocatechannelch3typedisk;
5>allocatechannelch4typedisk;
6>allocatechannelch5typedisk;
7>allocatechannelch6typedisk;
8>restoredatabase;
9>releasechannelch1;
10>releasechannelch2;
11>releasechannelch3;
12>releasechannelch4;
13>releasechannelch5;
14>releasechannelch6;
15>}
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ch1
channelch1:
SID=30devicetype=DISK
allocatedchannel:
ch2
channelch2:
SID=29devicetype=DISK
allocatedchannel:
ch3
channelch3:
SID=21devicetype=DISK
allocatedchannel:
ch4
channelch4:
SID=28devicetype=DISK
allocatedchannel:
ch5
channelch5:
SID=24devicetype=DISK
allocatedchannel:
ch6
channelch6:
SID=23devicetype=DISK
Startingrestoreat13-JAN-14
channelch1:
restoringdatafile00001
inputdatafilecopyRECID=9STAMP=836771958filename=+DATAGROUP1/rhys/datafile/system.311.836735137
destinationforrestoreofdatafile00001:
+DATAGROUP1/rhys/datafile/system.257.833999503
channelch2:
startingdatafilebackupsetrestore
channelch2:
specifyingdatafile(s)torestorefrombackupset
channelch2:
restoringdatafile00004to+DATAGROUP1/rhys/datafile/users.283.836771979
channelch2:
restoringdatafile00005to+DATAGROUP1/rhys/datafile/test.dbf
channelch2:
restoringdatafile00006to+DATAGROUP1/rhys/datafile/rhys.304.836771979
channelch2:
readingfrombackuppiece+DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737
channelch3:
restoringdatafile00002
inputdatafilecopyRECID=10STAMP=836771958filename=+DATAGROUP1/rhys/datafile/sysaux.279.836735137
destinationforrestoreofdatafile00002:
+DATAGROUP1/rhys/datafile/sysaux.256.833999647
channelch4:
restoringdatafile00003
inputdatafilecopyRECID=11STAMP=836771958filename=+DATAGROUP1/rhys/datafile/undotbs1.257.836735137
destinationforrestoreofdatafile00003:
+DATAGROUP1/rhys/datafile/undotbs1.308.836771963
ORA-19505:
failedtoidentifyfile"+DATAGROUP1/rhys/datafile/system.311.836735137"
ORA-17503:
ksfdopn:
2Failedtoopenfile+DATAGROUP1/rhys/datafile/system.311.836735137
ORA-15012:
ASMfile'+DATAGROUP1/rhys/datafile/system.311
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle11G 新版本 增加 原始数据 文件 验证 过程