The new version of Oracle 11g adds the verification process for raw data files.

I plan to take a technical note on the Oracle index topic, because today I helped a friend in Shenzhen to perform 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
 

Recovery Manager complete.
Recovery Process:
[Oracle @ oracle-one ~] $ Rman target/
 
Recovery Manager: Release 11.2.0.4.0-Production on Mon Jan 13 20:41:18 2014
 
Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.
 
Connected to target database: RHYS (DBID = 2745484551, not open)
 
RMAN> run {
2> allocate channel category type disk;
Allocate channel ch2 type disk;
3> 4> allocate channel ch3 type disk;
5> allocate channel c4type disk;
6> allocate channel ch5 type disk;
7> allocate channel ch6 type disk;
8> restore database;
9> release channel restart;
10> release channel ch2;
11> release channel ch3;
12> release channel methane;
13> release channel ch5;
14> release channel ch6;
15>}
 
Using target database control file instead of recovery catalog
Allocated channel: allocated
Channel identifier: SID = 30 device type = DISK
 
Allocated channel: ch2
Channel ch2: SID = 29 device type = DISK
 
Allocated channel: ch3
Channel ch3: SID = 21 device type = DISK
 
Allocated channel: 44.
Channel Methane: SID = 28 device type = DISK
 
Allocated channel: ch5
Channel ch5: SID = 24 device type = DISK
 
Allocated channel: ch6
Channel ch6: SID = 23 device type = DISK
 
Starting restore at 13-JAN-14
 
Channel failed: restoring datafile 00001
Input datafile copy RECID = 9 STAMP = 836771958 file name = + repeated roup1/rhys/datafile/system.311.81_351 _
Destination for restore of datafile 00001: + repeated roup1/rhys/datafile/system.257.833999503
Channel ch2: starting datafile backup set restore
Channel ch2: specifying datafile (s) to restore from backup set
Channel ch2: restoring datafile 00004 to + repeated roup1/rhys/datafile/users.283.836771979
Channel ch2: restoring datafile 00005 to + repeated roup1/rhys/datafile/test. dbf
Channel ch2: restoring datafile 00006 to + repeated roup1/rhys/datafile/rhys.304.836771979
Channel ch2: reading from backup piece + primary roup1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737
Channel ch3: restoring datafile 00002
Input datafile copy RECID = 10 STAMP = 836771958 file name = + repeated roup1/rhys/datafile/sysaux.279.81_351 _
Destination for restore of datafile 00002: + repeated roup1/rhys/datafile/sysaux.256.833999647
Channel Methane: restoring datafile 00003
Input datafile copy RECID = 11 STAMP = 836771958 file name = + repeated roup1/rhys/datafile/undotbs1.257.81_351 _
Destination for restore of datafile 00003: + repeated roup1/rhys/datafile/undotbs1.308.836771963
ORA-19505: failed to identify file "+ repeated roup1/rhys/datafile/system.311.81_35133"
ORA-17503: ksfdopn: 2 Failed to open file + repeated roup1/rhys/datafile/system.311.81_351 _
ORA-15012: ASM file '+ repeated roup1/rhys/datafile/system.311.81_351_'does not exist
ORA-19600: input file is datafile-copy 9 (+ export roup1/rhys/datafile/system.311.81_351)
ORA-19601: output file is datafile 1 (+ export roup1)
 
ORA-19505: failed to identify file "+ repeated roup1/rhys/datafile/sysaux.279.81_351"
ORA-17503: ksfdopn: 2 Failed to open file + route roup1/rhys/datafile/sysaux.279.81_351 _
ORA-15012: ASM file '+ repeated roup1/rhys/datafile/sysaux.279.81_351_'does not exist
ORA-19600: input file is datafile-copy 10 (+ export roup1/rhys/datafile/sysaux.279.836735137)
ORA-19601: output file is datafile 2 (+ export roup1)
 
ORA-19505: failed to identify file "+ repeated roup1/rhys/datafile/undotbs1.257.81_351"
ORA-17503: ksfdopn: 2 Failed to open file + repeated roup1/rhys/datafile/undotbs1.257.81_351 _
ORA-15012: ASM file '+ repeated roup1/rhys/datafile/undotbs1.257.81_351_'does not exist
ORA-19600: input file is datafile-copy 11 (+ export roup1/rhys/datafile/undotbs1.257.81_351)
ORA-19601: output file is datafile 3 (+ export roup1)
 
 
 
 
 
Channel ch2: piece handle = + maid/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737 tag = TAG20140113T100212
Channel ch2: restored backup piece 1
Channel ch2: restore complete, elapsed time: 00:00:35
Failover to previous backup
 
Channel metadata: starting datafile backup set restore
Channel metadata: specifying datafile (s) to restore from backup set
Channel resume: restoring datafile 00001 to + than roup1/rhys/datafile/system.257.833999503
Channel resume: restoring datafile 00002 to + repeated roup1/rhys/datafile/sysaux.256.833999647
Channel resume: restoring datafile 00003 to + repeated roup1/rhys/datafile/undotbs1.308.836771963
Channel resume: reading from backup piece + primary roup1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737
Channel Layout: piece handle = + repeated roup1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737 tag = TAG20140113T100212
Channel priority: restored backup piece 1
Channel completed: restore complete, elapsed time: 00:03:25
Finished restore at 13-JAN-14
 
Released channel: released
 
Released channel: ch2
 
Released channel: ch3
 
Released channel: 44.
 
Released channel: ch5
 
Released channel: ch6
 
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> recover database;
 
Starting recover at 13-JAN-14
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID = 30 device type = DISK
 
Starting media recovery
 
Archived log for thread 1 with sequence 16 is already on disk as file + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_16.275.81_35655
Archived log for thread 1 with sequence 17 is already on disk as file + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_17.260.81_35657
Archived log for thread 1 with sequence 18 is already on disk as file + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_18.261.81_35659
Archived log for thread 1 with sequence 1 is already on disk as file + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_1.305.836751051
Archived log for thread 1 with sequence 2 is already on disk as file + repeated roup1/rhys/onlinelog/group_2.286.833999961
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_16.275.81_35655 thread = 1 sequence = 16
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_17.260.81_35657 thread = 1 sequence = 17
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_18.261.81_35659 thread = 1 sequence = 18
Archived log file name = + repeated roup1/rhys/archivelog/2014_01_13/thread_eclipseq_1.305.836751051 thread = 1 sequence = 1
Archived log file name = + repeated roup1/rhys/onlinelog/group_2.286.833999961 thread = 1 sequence = 2
Media recovery complete, elapsed time: 00:00:59
Finished recover at 13-JAN-14
 
RMAN> exit
 

Recovery Manager complete.
[Oracle @ oracle-one ~] $ Sqlplus/as sysdba
 
SQL * Plus: Release 11.2.0.4.0 Production on Mon Jan 13 20:48:36 2014
 
Copyright (c) 1982,201 3, Oracle. All rights reserved.
 

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
And Real Application Testing options
 
SQL> alter database open;
Alter database open
*
ERROR at line 1:
The ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
 

SQL> alter database open resetlogs;
 
Database altered.
 
SQL>
Conclusion: The verification process for raw data files is added in the new version of 11G.