The new version of Oracle11g adds the verification process for raw data files.

I'm going to take a technical note on the Oracle index topic, because today I helped a friend in Shenzhen to test rman and found there was a ORA-XXXXX when restoring my raw data.

I'm going to take a technical note on the Oracle index topic, because today I helped a friend in Shenzhen to test rman and found there was a ORA-XXXXX when restoring my raw data.

I plan to make a special technical note on Oracle index, because today I helped a friend in Shenzhen to do the rman test and found a ORA-XXXXX error while restoring my raw data. The test results are as follows:

Run {
Allocate channel category type disk;
Allocate channel ch2 type disk;
Allocate channel ch3 type disk;
Allocate channel methane type disk;
Allocate channel ch5 type disk;
Allocate channel ch6 type disk;
Restore database;
Release channel identifier;
Release channel ch2;
Release channel ch3;
Release channel 44;
Release channel ch5;
Release channel ch6;
}
Backup process:
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 = + maid/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 = + repeated roup1/rhys/archivelog/2014_01_03/thread_eclipseq_32.312.835887567 RECID = 38 STAMP = 835887568
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_04/thread_eclipseq_33.310.835983663 RECID = 43 STAMP = 835983664
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_04/thread_eclipseq_34.282.835983651 RECID = 41 STAMP = 835983651
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_04/thread_eclipseq_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 = + maid/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 = + repeated roup1/rhys/archivelog/2014_01_06/thread_eclipseq_1.313.836132583 RECID = 44 STAMP = 836132585
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_06/thread_eclipseq_2.314.836165563 RECID = 45 STAMP = 836165566
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_06/thread_eclipseq_3.315.836176677 RECID = 46 STAMP = 836176676
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_06/thread_eclipseq_4.273.836178949 RECID = 47 STAMP = 836178950
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_07/thread_eclipseq_5.280.836232005 RECID = 48 STAMP = 836232017
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_07/thread_eclipseq_6.278.836234531 RECID = 49 STAMP = 836234531
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_07/thread_eclipseq_7.277.836210459 RECID = 50 STAMP = 836237972
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_07/thread_eclipseq_8.272.836256311 RECID = 51 STAMP = 836256318
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_08/thread_eclipseq_9.271.836299715 RECID = 52 STAMP = 836299719
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_08/thread_eclipseq_10.308.836337507 RECID = 53 STAMP = 836337512
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_10/thread_eclipseq_11.307.836494623 RECID = 54 STAMP = 836494626
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_10/thread_eclipseq_12.306.836498149 RECID = 55 STAMP = 836498150
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_13.304.836731889 RECID = 56 STAMP = 836731893
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_14.305.81_33317 RECID = 57 STAMP = 836733316
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_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 = + repeated roup1/rhys/datafile/system.257.833999503
Input datafile file number = 00002 name = + repeated roup1/rhys/datafile/sysaux.256.833999647
Input datafile file number = 00006 name = + repeated roup1/rhys/datafile/rhys.309.835132099
Input datafile file number = 00004 name = + repeated roup1/rhys/datafile/users.261.833999767
Input datafile file number = 00003 name = + repeated roup1/rhys/datafile/undotbs1.260.833999753
Input datafile file number = 00005 name = + repeated roup1/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 = + maid/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 = + maid/rhys/backupset/2014_01_13/annnf0_tag20140113t100843_0.274.841734125 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 = + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_16.276.837934121 RECID = 59 STAMP = 836734121
Finished backup at 13-JAN-14

Starting Control File and SPFILE Autobackup at 13-JAN-14
Piece handle = + maid/rhys/autobackup/2014_01_13/s_812734128.276.8127341_comment = NONE
Finished Control File and SPFILE Autobackup at 13-JAN-14

RMAN> exit