ホームページ > データベース > mysql チュートリアル > Oracle 11g新版本增加对原始数据文件验证过程

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

WBOY
リリース: 2016-06-07 17:36:15
オリジナル
951 人が閲覧しました

打算做一个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
 

ソース:php.cn
このウェブサイトの声明
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。
人気のチュートリアル
詳細>
最新のダウンロード
詳細>
ウェブエフェクト
公式サイト
サイト素材
フロントエンドテンプレート