Home >Database >Mysql Tutorial >Oracle 11g新版本增加对原始数据文件验证过程

Oracle 11g新版本增加对原始数据文件验证过程

WBOY
WBOYOriginal
2016-06-07 17:36:15954browse

打算做一个Oracle索引的专题技术笔记,因为今天帮我一个深圳的朋友做过rman的测试,在 恢复我原始数据的时候,发现存在ORA-XXXXX

打算做一个Oracle索引的专题技术笔记,,因为今天帮我一个深圳的朋友做过rman的测试,在 恢复我原始数据的时候,发现存在ORA-XXXXX错误,测试结果如下:
 
 run {
 allocate channel ch1 type disk;
 allocate channel ch2 type disk;
 allocate channel ch3 type disk;
 allocate channel ch4 type disk;
 allocate channel ch5 type disk;
 allocate channel ch6 type disk;
 restore database;
 release channel ch1;
 release channel ch2;
 release channel ch3;
 release channel ch4;
 release channel ch5; 
release channel ch6;
 }
 备份过程:
 oracle@oracle-one ~]$ exit
 exit
 host command complete
 
RMAN> backup database plus archivelog delete input;
 

Starting backup at 13-JAN-14
 current log archived
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting archived log backup set
 channel ORA_DISK_1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=32 RECID=38 STAMP=835887568
 input archived log thread=1 sequence=33 RECID=43 STAMP=835983664
 input archived log thread=1 sequence=34 RECID=41 STAMP=835983651
 input archived log thread=1 sequence=35 RECID=42 STAMP=835983661
 channel ORA_DISK_1: starting piece 1 at 13-JAN-14
 channel ORA_DISK_1: finished piece 1 at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100050_0.302.836733655 tag=TAG20140113T100050 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
 channel ORA_DISK_1: deleting archived log(s)
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_03/thread_1_seq_32.312.835887567 RECID=38 STAMP=835887568
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_33.310.835983663 RECID=43 STAMP=835983664
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_34.282.835983651 RECID=41 STAMP=835983651
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_35.297.835983653 RECID=42 STAMP=835983661
 channel ORA_DISK_1: starting archived log backup set
 channel ORA_DISK_1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=1 RECID=44 STAMP=836132585
 input archived log thread=1 sequence=2 RECID=45 STAMP=836165566
 input archived log thread=1 sequence=3 RECID=46 STAMP=836176676
 input archived log thread=1 sequence=4 RECID=47 STAMP=836178950
 input archived log thread=1 sequence=5 RECID=48 STAMP=836232017
 input archived log thread=1 sequence=6 RECID=49 STAMP=836234531
 input archived log thread=1 sequence=7 RECID=50 STAMP=836237972
 input archived log thread=1 sequence=8 RECID=51 STAMP=836256318
 input archived log thread=1 sequence=9 RECID=52 STAMP=836299719
 input archived log thread=1 sequence=10 RECID=53 STAMP=836337512
 input archived log thread=1 sequence=11 RECID=54 STAMP=836494626
 input archived log thread=1 sequence=12 RECID=55 STAMP=836498150
 input archived log thread=1 sequence=13 RECID=56 STAMP=836731893
 input archived log thread=1 sequence=14 RECID=57 STAMP=836733316
 input archived log thread=1 sequence=15 RECID=58 STAMP=836733649
 channel ORA_DISK_1: starting piece 1 at 13-JAN-14
 channel ORA_DISK_1: finished piece 1 at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100050_0.297.836733683 tag=TAG20140113T100050 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
 channel ORA_DISK_1: deleting archived log(s)
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_1.313.836132583 RECID=44 STAMP=836132585
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_2.314.836165563 RECID=45 STAMP=836165566
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_3.315.836176677 RECID=46 STAMP=836176676
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_4.273.836178949 RECID=47 STAMP=836178950
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_5.280.836232005 RECID=48 STAMP=836232017
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_6.278.836234531 RECID=49 STAMP=836234531
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_7.277.836237959 RECID=50 STAMP=836237972
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_8.272.836256311 RECID=51 STAMP=836256318
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_08/thread_1_seq_9.271.836299715 RECID=52 STAMP=836299719
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_08/thread_1_seq_10.308.836337507 RECID=53 STAMP=836337512
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_10/thread_1_seq_11.307.836494623 RECID=54 STAMP=836494626
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_10/thread_1_seq_12.306.836498149 RECID=55 STAMP=836498150
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_13.304.836731889 RECID=56 STAMP=836731893
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_14.305.836733317 RECID=57 STAMP=836733316
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_15.303.836733649 RECID=58 STAMP=836733649
 Finished backup at 13-JAN-14
 
Starting backup at 13-JAN-14
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting full datafile backup set
 channel ORA_DISK_1: specifying datafile(s) in backup set
 input datafile file number=00001 name=+DATAGROUP1/rhys/datafile/system.257.833999503
 input datafile file number=00002 name=+DATAGROUP1/rhys/datafile/sysaux.256.833999647
 input datafile file number=00006 name=+DATAGROUP1/rhys/datafile/rhys.309.835132099
 input datafile file number=00004 name=+DATAGROUP1/rhys/datafile/users.261.833999767
 input datafile file number=00003 name=+DATAGROUP1/rhys/datafile/undotbs1.260.833999753
 input datafile file number=00005 name=+DATAGROUP1/rhys/datafile/test.dbf
 channel ORA_DISK_1: starting piece 1 at 13-JAN-14
 channel ORA_DISK_1: finished piece 1 at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737 tag=TAG20140113T100212 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:06:26
 Finished backup at 13-JAN-14
 
Starting backup at 13-JAN-14
 current log archived
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting archived log backup set
 channel ORA_DISK_1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=16 RECID=59 STAMP=836734121
 channel ORA_DISK_1: starting piece 1 at 13-JAN-14
 channel ORA_DISK_1: finished piece 1 at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100843_0.274.836734125 tag=TAG20140113T100843 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
 channel ORA_DISK_1: deleting archived log(s)
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_16.276.836734121 RECID=59 STAMP=836734121
 Finished backup at 13-JAN-14
 
Starting Control File and SPFILE Autobackup at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/autobackup/2014_01_13/s_836734128.276.836734133 comment=NONE
 Finished Control File and SPFILE Autobackup at 13-JAN-14
 
RMAN> exit
 

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn