Oracle 9201's control file content list:
Control file head ...
Database item ...
Checkpoint progress record (this item is introduced from Oracle8) ...
Extended database item (this item starts from Oracle9i) ...
Redo the thread ...
Log file item ...
Data file item ...
Temporary document record (this item starts from Oracle9i) ...
Table space record (this item starts from Oracle8) ...
Rman Configuration Record (This item starts from Oracle9i) ...
Log file history item ...
Offline range record (this item starts from Oracle8) ...
Archive log record (this item is introduced from Oracle8) ...
Use the RMAN backup database of backup collection records (which begins from Oracle8) ...
Use the RMAN backup database of backup tablets (which is introduced from Oracle8) ...
Use the RMAN backup database of backup data files (this item is introduced from Oracle8) ...
Use the RMAN backup database's backup archive log file (which is introduced from Oracle8) ...
Use the RMAN backup database to copy the record item (which is introduced from Oracle8) ...
Use the RMAN backup database to damage record items (this item starts from Oracle8) ...
Use the RMAN backup database to copy damage record (this item starts from Oracle8) ...
Use the RMAN backup database to delete record (this item is introduced from Oracle8) ...
Use the RMAN backup database of proxy copy record (which is introduced from Oracle8i) ...
INCARNATION RECORDS (This item is introduced from Oracle9i) ...
The contents of the first line to the 22nd line are header information of the control file, and the explanation of this part is explained in "Dump Control File Head".
Control file header
1. Dump file e: /oracle/admin/test/udump/test_ora_376.trc
2. Fri May 14
15:09:52
2004
3. Oracle V9.2.0.1.0 - Production vsnsta = 0
4. VSNSQL = 12 vSNXTR = 3
5. Windows 2000 Version 5.0 Service Pack 4, CPU Type 586
6. Oracle9i
Enterprise
Edition Release 9.2.0.1.0 - Production
7. with the partitioning, OLAP AND ORACLE DATA MINING OPTIONS
8. JServer Release 9.2.0.1.0 - Production
9. Windows 2000 Version 5.0 Service Pack 4, CPU Type 586
10. Instance Name: Test
11. Redo thread mounted by this instance: 1
12. Oracle Process Number: 13
13. Windows Thread Id: 376, Image: Oracle.exe
14. *** 2004-05-14 15: 09: 52.000
15. *** Session ID: (10.21) 2004-05-14 15: 09: 52.000
16. Dump of control files, SEQ # 2929 = 0xB71 ======= 17th line to the 22nd behavior universal file head ========
17.file header:
18. Software vsn = 153092096 = 0x9200000, Compatibility VSN = 134217728 = 0x8000000
19. DB ID = 1750352942 = 0x6854442E, DB Name = 'TEST1'
20. Activation ID = 0 = 0x0
21. Control SEQ = 2929 = 0xB71, File Size = 228 = 0xE4
22. File Number = 0, BLKSIZ = 8192, File Type = 1 CONTROL
******************************************************************************************************************** **********
Database item
twenty three.************************************************ *********************
24.DATABASE Entry
25****************************************************** *********************
26. (BLKNO = 0x1, size = 192, max = 1, in-use = 1, last-recid = 0)
BLKNO
Size points out the number of bytes of the database item, in this case 192byte;
MAX points out the largest block
IN-USE is currently using blocks
Last-Recid
27. DF VERSION: CREATION = 0x9200000 Compatible = 0x8000000, Date
07/13/2003
14:30:51
The version of the data file is 9.2.0, and the compatible version is 8.0
28. DB Name "Test1"
Database name "TEST1"
29. Database flags = 0x00404001
30. ControlFile Creation TimeStamp
07/13/2003
14:30:52
Creation time of control file
31. Incmplt Recovery SCN: 0x0000.00000000
If the database is not fully reply, we can see
32. ResetLogs SCN: 0x0000.04ADA796 ResetLogs TimeStamp
07/13/2003
14:34:39
Enable the SCN value and timestamp when resetlogs,
33. PRIOR RESETLOGS SCN: 0x0000.04A0B855 Prior ResetLogs TimeStamp
04/11/2003
09:59:18
SCN value before resetlogs and timestamp
Oracle is not able to apply resetLogs's redo log file.
34. Redo Version: Creation = 0x9200000 compatable = 0x9200000
The version of the redo log file is 9.2.0, the compatible version is 8.0
35. #Data files = 12, #Online files = 12
There are 12 data files in the database, and these 12 files are all in the online state 36. Database CheckPoint: thread = 1 SCN: 0x0000.04B9D858
37. Threads: # enabled = 1, # Open = 1, Head = 1, tail = 1
A thread is currently enabled, of course, only open this thread
38. Enabled threads: 010000001000000000000000002 00000000 0000-00 0000.
39. max log members = 3, Max data members = 1
The database allows for each log group to have up to 3 log member;
Oracle currently does not support multiple reputation of data files, so the value of Max Data Members is 1, which is reserved for the later version upgrade.
40. Arch List: Head = 3, Tail = 3, Force SCN: 0x0000.04B93016SCN: 0x0000.04B9D857
Note that Force SCN, all SCNs are not less than the FORCE SCN is archived. Mandatory SCN is an SCN that is archived all heavy.
41. ControlFile Checkpointed AT SCN: 0x0000.04B9D85A
05/14/2004
08:37:00
The SCN when the current control file CheckPointed is 0x0000.04b9d85a? ? ?
42. Thread: 0 RBA: (0x0.0.0)
43. Enabled threads: 00000000 0000000000002
0000000010
Check points progress record (this item starts from Oracle8)
44. ****************************************************************** *********************
45.Checkpoint Progress Records
46.1 ***************************************************************** *********************
Checkpoint progress Record This entry is from Oracle 8 to appear in the control file. The project is primarily used to record the state of the buffer cache, each of which occupies a block of the control file.
47. (BLKNO = 0x4, size = 104, max = 1, in-use = 1, Last-Recid = 0)
48. Thread # 1 - Status: 0x2 Flags: 0x0 dirty: 15
Thread information,
49. Low Cache RBA: (0x20.1f0.0) On Disk RBA: (0x20.204.0)
The low speed cache RBA (Recovery Block Address) pointed out that in instance reply or crash recovery, you need to recover the restore start value (ie, a block address in the redo log file);
On Disk RBA is the highest redistribution on the disk, which must reach this when performing strength to restore the application. If on disk RBA
50. On Disk SCN: 0x0000.04B9F6E2
05/14/2004
15:06:42
On Disk SCN is an SCN value at on disk RBA
51. ResetLogs SCN: 0x0000.04ADA79607 / 13/2003
14:34:39
The SCN value and timestamp when resetlogs are enabled, and the corresponding entries in the database item are consistent.
52. Heartbeat: 526099342 Mount: 903127902
53. Mttr Statistics Status: 3
54. INIT TIME: AVG: 23012858, TIMES Measured: 3
55. File Open Time: AVG: 123550, Times Measured: 43
56. Log Block Read Time: AVG: 182, TIMES Measure: 32758
57. Data Block Handling Time: AVG: 22934, Times Measured: 135
Extended database item (this item is introduced from Oracle9i)
58.1 ********************************************************* **********************
59. Extended Database Entry
60. ******************************************************** **********************
61. (BLKNO = 0x71, size = 276, max = 1, in-use = 1, Last-Recid = 0)
62. Control AutoBackup Date (DD / MM / YYYY) = 13 / 7/2003
63. Next AutoBackup SEQUENCE = 0
Redo the thread
64. ******************************************************** *********************
65.Redo Thread Records
66. ******************************************************** *********************
67. (BLKNO = 0x4, size = 104, max = 1, in-use = 1, Last-Recid = 0)
68. Thread # 1 - status: 0xf thread links forward: 0 Back: 0
69. #logs: 4 First: 1 Last: 4 Current: 3 Last Used SEQ #: 0x20
This entry shows a total of 4 log file groups in the database, the first group is log # 1 (log group 1); the last group is log # 4 (log group 4), currently use LOG # 3 (log) GROUP 3)
70. Enabled AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
Enable the SCN value at thread 1
71. Disabled AT SCN: 0x0000.00000000
01/01/1988
00:00:00
Disable the SCN value at the thread 1, because the thread is currently open, so this value is infinite
72. OPENED AT
05/14/2004
08:36:59
INSTANCE TEST
Open the timestamp of the thread, the current thread, and which instance open
73. CheckPointed AT SCN: 0x0000.04B9D858
05/14/2004
08:36:59
74. Thread: 1 RBA: (0x20.2.10)
75. Enabled Threads: 01000000 00000000000000000000002 000000002 0000-00 0000-00 0000-00 0000-00 0000-00 0000-00-00 0000-00 0000
77. Log History: 31
Log file item
78. ****************************************************************** *********************
79.log file records
80. ******************************************************** *********************
81. (BLKNO = 0x5, size = 72, max = 5, in-use = 4, Last-Recid = 4)
82.log file # 1:
83. (Name # 5) E: /oracle/ora92/test/redo01.log
84. Thread 1 Redo Log Links: Forward: 2 Backward: 0
Log file # 1 After you are full, you will switch to Forward: 2, you can switch to log file # 2, this can pass the log file # 1 Next SCN: 0x0000.04b9870a equals log file # 2 LOW SCN: 0x0000.04b9870a
85. SIZ: 0xF000 SEQ: 0x0000001E HWS: 0x6 BSZ: 512 NAB: 0x15B FLG: 0x1 DUP: 1
NAB is the address of the next data block available in the log file, if this value is infinite, indicating that this log file is the log file of the current (LGWR is writing)
86. Archive Links: fwrd: 0 Back: 0 Prev SCN: 0x0000.04B8B9AD
87. Low SCN: 0x0000.04B93016
05/13/2004
16:31:24
When the log is switched, a low SCN and a high SCN are allocated, and the low SCN is the value of the high SCN of the last log, and the high SCN is set to infinity until the current log is high, the current SCN Set to the lower SCN of the next log file, set the high SCN of the next log file to infinity.
88. NEXT SCN: 0x0000.04B9870A
05/13/2004
19:43:45
After the log is switched, the high SCN is from infinite value to the value of NEXT SCN (next SCN), which will be a low SCN of the switching log file.
89.log file # 2:
90. (Name # 4) E: /oracle/ora92/test/redo02.log
91. Thread 1 Redo Log Links: Forward: 3 Backward: 1
92. SIZ: 0xF000 SEQ: 0x0000001F HWS: 0x5 BSZ: 512 NAB: 0x133 FLG: 0x1 DUP: 1
93. Archive Links: fwrd: 0 Back: 0 prev scn: 0x0000.04b93016
94. Low SCN: 0x0000.04B9870A
05/13/2004
19:43:45
95. NEXT SCN: 0x0000.04B9D857
05/14/2004
08:36:59
96.log file # 3:
97. (Name # 3) E: /oracle/ora92/test/redo03.log
98. Thread 1 Redo Log Links: Forward: 4 Backward: 2
99. SIZ: 0xF000 SEQ: 0x00000020 hws: 0x2 BSZ: 512 NAB: 0xfffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff.
101.LOW SCN: 0x0000.04B9D857
05/14/2004
08:36:59
102.next SCN: 0xffff.fffffffff
01/01/1988
00:00:00
Note, log file # 3 is the current log file (LGWR is being written log file)
103. Log file # 4:
104. (Name # 1) E: /oracle/ora92/test/redo04a.log
105. (Name # 2) E: /oracle/ora92/test/redo04b.log
106.Thread 1 Redo Log Links: Forward: 0 Backward: 3
107.Siz: 0x800 SEQ: 0x0000001D HWS: 0xA BSZ: 512 NAB: 0X427 FLG: 0x1 DUP: 2
108.archive Links: fwrd: 0 Back: 0 prev scn: 0x0000.04b854e4
109.LOW SCN: 0x0000.04B8B9AD
05/11/2004
14:27:28
110.Next SCN: 0x0000.04B93016
05/13/2004
16:31:24
Data file item
111.1 ******************************************************* ******************
112. Data File Records
113.1 ******************************************************* ******************
114. (BLKNO = 0x6, size = 180, max = 100, in-use = 14, last-reCID = 41)
115. Data File # 1:
116. (Name # 17) E: /oracle/ora92/test/system01.dbf
117.creation size = 0 block size = 8192 status = 0xe head = 17 tail = 17 dup = 1
118.Tablespace 0, INDEX = 1 kRfil = 1 prev_file = 0
Description is the system table space
119.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
120.Checkpoint CNT: 701 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
The number of times the checkpoint is performed on the file is 701 (when the file is in the hot standby state, if the checkpoint is taken, checkpoint counters or add one);
121.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
End SCN (STOP SCN) is the last SCN of the data file (this value is set when the database is turned off, and the status is open, the value is infinite. Restore to the STOP SCN when the database is recovered.
122.Creation Checkpointed AT SCN: 0x0000.0000001401 / 13/2002
22:01:17
When the "Alter Database Create DataFile" command recovered data file (this command started from ORACLE7), it needs to be created in accordance with the checkpoint SCN (Creation CheckPointed AT SCN).
123.Thread: 0 RBA: (0x0.0.0)
124.enabled threads: 000000001000000000002
0000000010
125. Offline SCN: 0x0000.04ADA795 prev_Range: 0
When the file is offline, the SCN when the file is offline is saved in the control file.
126.online Checkpointed At SCN: 0x0000.04ADA796
07/13/2003
14:34:39
When the file is online, the checkpoint SCN when the file is online is saved in the control file.
Since the data file in the system table space can never go offline, the offline SCN of the system data file should be 0x0000.00000000
Congicity, the OFFLINE SCN here indicates the checkpoint SCN of the data file when the database is properly closed;
The online checkpointed at scn here is the checkpoint of the data file when the database is opened.
127.Thread: 1 RBA: (0x1.2.0)
128.enabled threads: 010000001000000000000010 000000000000000000000000 0000000000
0000000010
129.Hot Backup End Marker SCN: 0x0000.00000000
Hot standing SCN
130.aux_file is not defined
131. Data File # 2:
132. (Name # 16) E: /oracle/ora92/test/undotbs01.dbf
133.creation size = 0 block size = 8192 status = 0xe head = 16 tail = 16 dup = 1
134.TablesPace 1, INDEX = 2 Krfil = 2 prev_file = 0
135.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
136.Checkpoint CNT: 640 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
137.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
138.Creation CheckPointed AT SCN: 0x0000.0002F401
01/14/2002
22:24:49
139.Thread: 0 RBA: (0x0.0.0)
140.enabled threads: 0000000000000000002
141.00000000 00000000
142.offline SCN: 0x0000.04ADA795 prev_Range: 0
143.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
144.Thread: 1 RBA: (0x1.2.0)
145.enabled threads: 01000000100000000000000000000000000000000000000000146.000000000000000000
147.Hot Backup End Marker SCN: 0x0000.00000000
148.aux_file is not defined
149. Data File # 3:
150. (Name # 15) E: /oracle/ora92/test/drsys01.dbf
151.Creation size = 0 block size = 8192 status = 0xe head = 15 tail = 15 dup = 1
152.Tablespace 3, INDEX = 3 kRfil = 3 prev_file = 0
153.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
154.Checkpoint CNT: 699 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
155.Stop SCN: 0xffff.ffffffff
05/13/2004
20:18:03
156.Creation Checkpointed AT SCN: 0x0000.00001882
01/13/2002
22:02:52
157.Thread: 0 RBA: (0x0.0.0)
158.enabled threads: 0000000000000000002
159.00000000 000,00000
160.offline SCN: 0x0000.04ADA795 prev_Range: 0
161.online Checkpointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
162.Thread: 1 RBA: (0x1.2.0)
163.enabled threads: 010000001000000000000000002
164.00000000 000,00000
165.Hot Backup End Marker SCN: 0x0000.00000000
166.aux_file is not defined
167. Data File # 4:
168. (Name # 14) E: /oracle/ora92/test/indx01.dbf
169.Creation Size = 0 block size = 8192 status = 0xe head = 14 tail = 14 dup = 1
170.Tablespace 4, INDEX = 4 kRfil = 4 prev_file = 0
171.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
172.Checkpoint CNT: 699 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
173.STOP SCN: 0xffff.fffffffff
05/13/2004
20:18:03
174.Creation Checkpointed AT SCN: 0x0000.00001895
01/13/2002
22:02:58
175.Thread: 0 RBA: (0x0.0.0)
176.enabled threads: 000000001000000000002
177.0000000000000000002
178.Offline SCN: 0x0000.04ADA795 prev_Range: 0179.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
180.Thread: 1 RBA: (0x1.2.0)
181.enabled threads: 0100000010000000000000000000 00000000 0000
182.00000000 000,00000
183.Hot Backup End Marker SCN: 0x0000.00000000
184.aux_file is not defined
185. Data File # 5:
186. (Name # 13) E: /oracle/ora92/test/tools01.dbf
187.creation size = 0 block size = 8192 status = 0xe head = 13 tail = 13 dup = 1
188.Tablespace 5, INDEX = 5 kRfil = 5 prev_file = 0
189.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
190.Checkpoint CNT: 699 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
191.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
192.Creation Checkpointed AT SCN: 0x0000.000018A6
01/13/2002
22:03:03
193.Thread: 0 RBA: (0x0.0.0)
194.enabled threads: 0000000000000000002
195.00000000 00000000
196.offline scn: 0x0000.04ada795 prev_Range: 0
197.online CheckPointed At SCN: 0x0000.04ADA796
07/13/2003
14:34:39
198.Thread: 1 RBA: (0x1.2.0)
199.enabled Threads: 010000001000000000000000002
20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
201.Hot Backup End Marker SCN: 0x0000.00000000
202.aux_file is not defined
203. Data File # 6:
204. (Name # 12) E: /oracle/ora92/test/USERS01.DBF
205.creation size = 0 block size = 8192 status = 0xe head = 12 tail = 12 dup = 1
206.Tablespace 6, INDEX = 6 Krfil = 6 prev_file = 0
207.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
208.Checkpoint CNT: 702 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
209.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
210.Creation CheckPointed AT SCN: 0x0000.000018B7
01/13/2002
22: 03: 09211.Thread: 0 RBA: (0x0.0.0)
212.enabled threads: 00000000 0000000010 000000002
21-3.00000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
214.offline SCN: 0x0000.04ADA795 prev_Range: 0
215.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
216.Thread: 1 RBA: (0x1.2.0)
217.enabled threads: 0100000010000000000000002
218.00000000 00000000
219.Hot Backup End Marker SCN: 0x0000.00000000
220.aux_file is not defined
221. Data File # 7:
222. (Name # 11) E: /oracle/ora92/test/xdb01.dbf
223.Creation Size = 0 block size = 8192 status = 0xe head = 11 tail = 11 dup = 1
224.Tablespace 7, INDEX = 7 Krfil = 7 prev_file = 0
225.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
226.Checkpoint CNT: 698 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
227.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
228.Creation CheckPointed AT SCN: 0x0000.000018CC
01/13/2002
22:03:18
229.Thread: 0 RBA: (0x0.0.0)
230.enabled threads: 000000001000000000002
231.0000000000000000
232.offline SCN: 0x0000.04ADA795 prev_Range: 0
233.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
234.Thread: 1 RBA: (0x1.2.0)
235.enabled threads: 010000001000000000000000002
236.00000000 0000000000
237.Hot Backup End Marker SCN: 0x0000.00000000
238.aux_file is not defined
239. Data File # 8:
240. (Name # 10) E: /oracle/ora92/test/test01.dbf
241.Creation size = 0 block size = 8192 status = 0xe head = 10 tail = 10 dup = 1
242.Tablespace 11, INDEX = 8 kRfil = 8 prev_file = 0
243.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
244.Checkpoint CNT: 356 SCN: 0x0000.04B9D858
05/14/200408: 36: 59
245.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
246.Creation CheckPointed AT SCN: 0x0000.0011A40E
02/06/2003
16:25:09
247.Thread: 0 RBA: (0x0.0.0)
248.enabled threads: 000000001000000000002
249.00000000 00000000
250.Offline SCN: 0x0000.04ADA795 prev_Range: 0
251.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
252.Thread: 1 RBA: (0x1.2.0)
253.enabled threads: 01000000100000000000000010 000000000000 00000000
254.0000000000000000
255.Hot Backup End Marker SCN: 0x0000.00000000
256.aux_file is not defined
257. Data File # 9:
258. (Name # 9) E: /oracle/ora92/test/rman01.dbf
259.Creation size = 0 block size = 8192 status = 0xe head = 9 tail = 9 dup = 1
260.Tablespace 9, INDEX = 9 kRfil = 9 prev_file = 0
261.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
262.Checkpoint CNT: 576 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
263.STOP SCN: 0xffff.ffffffff
05/13/2004
20:18:03
264.Creation CheckPointed AT SCN: 0x0000.0009F9CE
01/24/2002
17:23:42
265.Thread: 0 RBA: (0x0.0.0)
266.enabled threads: 00000000 000000000010 000000002
267.00000000 000,00000
268.offline SCN: 0x0000.04ADA795 prev_Range: 0
269.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
270.Thread: 1 RBA: (0x1.2.0)
271.enabled threads: 01000000100000000000000000 0000.
272.00000000 00000000
273.Hot Backup End Marker SCN: 0x0000.00000000
274.aux_file is not defined
275. Data File # 10:
276. (Name # 8) E: /oracle/ora92/test/perfstat01.dbf
277.Creation size = 0 block size = 8192 status = 0xe head = 8 tail = 8 dup = 1
278.TablesPace 12, INDEX = 10 krfil = 10 prev_file = 0279.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
280.Checkpoint CNT: 253 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
281.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
282.Creation Checkpointed AT SCN: 0x0000.00199CAF
03/03/2003
19:55:07
283.Thread: 0 RBA: (0x0.0.0)
284.enabled threads: 00000000 000000000010 0000000000 00000000 0000
285.00000000 00000000
286.offline SCN: 0x0000.04ADA795 prev_Range: 0
287.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
288.Thread: 1 RBA: (0x1.2.0)
289.enabled threads: 010000001000000000000000002
290.000000000000000000
291.Hot Backup End Marker SCN: 0x0000.00000000
292.aux_file is not defined
293. Data File # 11:
294. (Name # 7) E: /oracle/ora92/test/undotbs02.dbf
295.Creation size = 0 block size = 8192 status = 0xe head = 7 tail = 7 dup = 1
296.Tablespace 8, Index = 11 Krfil = 11 prev_file = 0
297.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
298.Checkpoint CNT: 237 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
299.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
300.Creation Checkpointed AT SCN: 0x0000.049F6BF8
03/27/2003
09:48:22
301.Thread: 0 RBA: (0x0.0.0)
302.enabled threads: 00000000 000000000010 0000000000 00000000 0000
303.00000000 00000000
304.Offline SCN: 0x0000.04ADA795 Prev_Range: 0
305.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
306.Thread: 1 RBA: (0x1.2.0)
307.enabled threads: 0100000010000000000000002
308.00000000 00000000
309.Hot Backup End Marker SCN: 0x0000.00000000
310.aux_file is not defined
311. Data file # 12:
313.TablesPace 18, INDEX = 14 kRfil = 12 prev_file = 0
314.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
315.Checkpoint CNT: 3 SCN: 0x0000.04B7E874
05/10/2004
16:45:12
316.Stop SCN: 0x0000.04B7E874
05/10/2004
16:45:12
317.Creation Checkpointed AT SCN: 0x0000.04B7E496
05/10/2004
16:04:32
318.Thread: 1 RBA: (0x1a.17d.10)
319.enabled threads: 0100000010000000000000000000 00000000 0000
320.00000000 00000000
321.offline SCN: 0x0000.00000000 Prev_Range: 0
322.online Checkpointed AT SCN: 0x0000.00000000
323.Thread: 0 RBA: (0x0.0.0)
324.enabled threads: 00000000 000000000010 000000002
325.00000000 00000000
326.Hot Backup End Marker SCN: 0x0000.00000000
327.aux_file is not defined
328. Data file # 13:
329.creation size = 0 block size = 0 status = 0x0 head = 0 tail = 0 dup = 0
330.Tablespace 0, INDEX = 0 krfil = 0 prev_file = 0
331.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
332.Checkpoint CNT: 0 SCN: 0x0000.00000000
01/01/1988
00:00:00
333.STOP SCN: 0x0000.00000000
01/01/1988
00:00:00
334.Creation Checkpointed AT SCN: 0x0000.00000000
335.Thread: 0 RBA: (0x0.0.0)
336.enabled threads: 00000000 0000000000002
337.00000000 00000000
338.offline SCN: 0x0000.00000000 Prev_Range: 0
339.online Checkpointed AT SCN: 0x0000.00000000
340.Thread: 0 RBA: (0x0.0.0)
341.enabled threads: 000000001000000000002
342.00000000 00000000
343.Hot Backup End Marker SCN: 0x0000.00000000
344.aux_file = 0
345. Data File # 14: 346. (Name # 6) E: /oracle/ora92/test/xprt01.dbf
347.Creation size = 0 block size = 8192 status = 0xe head = 6 tail = 6 dup = 1
348.TablesPace 16, Index = 12 kRfil = 14 prev_file = 0
349.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
350.Checkpoint CNT: 187 SCN: 0x0000.04B9D858
05/14/2004
08:36:59
351.Stop SCN: 0xffff.fffffffff
05/13/2004
20:18:03
352.Creation CheckPointed AT SCN: 0x0000.04A3FD9C
05/28/2003
15:06:11
353.Thread: 0 RBA: (0x0.0.0)
354.enabled threads: 00000000 00000000000010 000000000000 00000000 0000
355.00000000 000,00000
356.Offline SCN: 0x0000.04ADA795 prev_Range: 0
357.online CheckPointed AT SCN: 0x0000.04ADA796
07/13/2003
14:34:39
358.Thread: 1 RBA: (0x1.2.0)
359.enabled threads: 01000000 00000000000010 00000000 00000000 0000
360.00000000 000,00000
361.Hot Backup End Marker SCN: 0x0000.00000000
362.aux_file is not defined
Temporary document record (this item is introduced from Oracle9i)
363. ********************************************************* ******************
364. Temp File Records
365. ********************************************************** ******************
366. (BLKNO = 0x12, size = 56, max = 100, in-use = 1, Last-Recid = 1)
367.Temp File # 1: External File # 201
368. (Name # 18) E: /oracle/ora92/test/temp.dbf
369.creation size = 2560 block size = 8192 status = 0xe head = 18 tail = 18 dup = 1
370.Tablespace 2, INDEX = 13 kRfil = 1 prev_file = 0
371.unRecoverable SCN: 0x0000.00000000
01/01/1988
00:00:00
Table space record (this item is introduced from Oracle8)
372. ***************************************************************** ******************
373. TableSpace Records
374.1 ****************************************************************** ****************** 375. (BLKNO = 0x11, size = 68, max = 100, in-us = 16, last-recid = 9)
376.Tablespa # 0 system: recno = 1
377.First DataFile Link = 1 TableSpace Flag = 0
378.TablesPace PiTR Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
379.TablesPace Pitr Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
380.Tablespa # 1 undotbs1: recno = 2
381.First DataFile Link = 2 TableSpace Flag = 0
382.TablesPace Pitr Mode START SCN: 0x0000.00000000
01/01/1988
00:00:00
383.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
384.Tablespa # 3 DRSYS: Recno = 3
385.First DataFile Link = 3 TableSpace Flag = 0
386.Tables PiTR Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
387.TablesPace Pitr Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
388.Tablespa # 4 INDX: Recno = 4
389.First DataFile Link = 4 TableSpace Flag = 0
390.TablesPace Pitr Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
391.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
392.Tablespa # 5 Tools: recno = 5
393.First DataFile Link = 5 TableSpace Flag = 0
394.TablesPace PiTR Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
395.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
396.Tablespa # 6 users: recno = 6
397.First DataFile Link = 6 TableSpace Flag = 0
398.TablesPace Pitr Modral START SCN: 0x0000.00000000
01/01/1988
00:00:00
399.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
400.TablesPace # 7 xdb: recno = 7
401.First DataFile Link = 7 TableSpace Flag = 0
402.Tablespace Pitr Mode Start SCN: 0x0000.0000000001 / 01/1988
00:00:00
403.TablesPace Pitr Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
404.Tablespa # 11 Test: Recno = 8
405.First DataFile Link = 8 TableSpace Flag = 0
406.Tablespace Pitr Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
407.Tablespace Pitr Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
408.Tablespa # 9 rman: recno = 9
409.First DataFile Link = 9 TableSpace Flag = 0
410.TablesPace PiTR Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
411.TablesPace Pitr Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
412.TablesPace # 12 perfstat: recno = 10
413.First DataFile Link = 10 TableSpace Flag = 0
414.TablesPace Pitr Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
415.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
416.Tablespa # 8 undotbs2: Recno = 11
417.First DataFile Link = 11 TableSpace Flag = 0
418.TablesPace Pitr Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
419.TablesPace Pitr Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
420.Tablespace # 16 xprt: recno = 12
421.First DataFile Link = 14 TableSpace Flag = 0
422.TablesPACE PITR Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
423.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
424.Tablespa # 2 Temp: Recno = 13
425.First DataFile Link = 1 TableSpace Flag = 1
426.TablesPace PiTR Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
427.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
428.Tablespa # 2147483647 UNDO_TEST: Recno = 14
429.first DataFile Link = 0 TableSpace Flag = 0430.Tablespace Pitr Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
431.TablesPace Pitr Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
432.Tablespa # 2147483647 SORT: Recno = 15
433.First DataFile Link = 0 TABLESPACE FLAG = 1
434.TablesPace Pitr Mod START SCN: 0x0000.00000000
01/01/1988
00:00:00
435.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
436.Tablespa # 2147483647 Lunartemp: recno = 16
437.First DataFile Link = 0 TABLESPACE FLAG = 1
438.TablesPace PiTR Mode Start SCN: 0x0000.00000000
01/01/1988
00:00:00
439.TablesPACE PITR Last Completion SCN: 0x0000.00000000
01/01/1988
00:00:00
RMAN configuration record (this item is introduced from Oracle9i)
440.1 ********************************************************* ******************
441. Rman Configuration Records
442. ***************************************************************** ******************
443. (BLKNO = 0x13, size = 1108, max = 50, in-use = 0, Last-Recid = 0)
Log file history item
444. ********************************************************** ******************
445. Log file history records
446. ******************************************************** ******************
447. (BLKNO = 0x1a, size = 36, max = 226, in-use = 31, last-recid = 31)
448.Earliest Record:
449.Recid # 1 Recno 1 record timestamp
07/20/03
09:30:37
Thread = 1 SEQ # = 1 link-recid = 0
450.Low SCN: 0x0000.04ADA796
07/13/03
14:34:39
Next SCN: 0x0000.04AE05FB
451.latest Record:
452.Recid # 31 Recno 31 Record TimeStamp
05/14/04
08:36:59
Thread = 1 SEQ # = 31 link-recid = 30
453.LOW SCN: 0x0000.04B9870A
05/13/04
19: 43: 45Next SCN: 0x0000.04B9D857
454.Recid # 30 Recno 30 Record TimeStamp
05/13/04
19:43:45
Thread = 1 SEQ # = 30 link-recid = 29
455.Low SCN: 0x0000.04B93016
05/13/04
16:31:24
Next SCN: 0x0000.04B9870A
456.Recid # 29 Recno 29 Record TimeStamp
05/13/04
16:31:24
Thread = 1 SEQ # = 29 link-recid = 28
457.Low SCN: 0x0000.04B8B9AD
05/11/04
14:27:28
Next SCN: 0x0000.04B93016
458.Recid # 28 Recno 28 record timestamp
05/11/04
14:27:29
Thread = 1 seq # = 28 link-recid = 27
459.Low SCN: 0x0000.04B854E4
05/11/04
08:14:52
Next SCN: 0x0000.04B8B9AD
460.Recid # 27 Recno 27 Record TimeStamp
05/11/04
08:14:52
Thread = 1 SEQ # = 27 link-recid = 26
461.LOW SCN: 0x0000.04B7EFC3
05/10/04
18:00:17
Next SCN: 0x0000.04B854E4
462.Recid # 26 Recno 26 Record TimeStamp
05/10/04
18:00:17
Thread = 1 SEQ # = 26 link-recid = 25
463.Low SCN: 0x0000.04B7D716
05/10/04
13:16:04
Next SCN: 0x0000.04B7EFC3
464.Recid # 25 Recno 25 Record TimeStamp
05/10/04
13:16:05
Thread = 1 SEQ # = 25 link-recid = 24
465.Low SCN: 0x0000.04B759E6
05/09/04
08:41:38
Next SCN: 0x0000.04B7D716
466.Recid # 24 Recno 24 Record TimeStamp
05/09/04
08:41:38
Thread = 1 seq # = 24 link-recid = 23
467.Low SCN: 0x0000.04B6D74D
05/08/04
09:45:10
Next SCN: 0x0000.04B759E6
468.Recid # 23 Recno 23 Record TimeStamp
05/08/04
09:45:10
Thread = 1 SEQ # = 23 link-recid = 22
469.LOW SCN: 0x0000.04B67D98
05/02/04
15:36:17
Next SCN: 0x0000.04B6D74D
470.Recid # 22 Recno 22 Record TimeStamp
05/02/04
15:36:18
Thread = 1 SEQ # = 22 link-recid = 21
471.LOW SCN: 0x0000.04B62189
05/02/04
08:19:22
Next SCN: 0x0000.04B67D98
472.Recid # 21 Recno 21 Record TimeStamp
05/02/04
08:19:22
Thread = 1 SEQ # = 21 link-recid = 20473.low scn: 0x0000.04b5a5f0
04/30/04
07:32:34
Next SCN: 0x0000.04B62189
474.Recid # 20 Recno 20 Record TimeStamp
04/30/04
07:32:34
Thread = 1 SEQ # = 20 link-recid = 19
475.Low SCN: 0x0000.04B551B5
04/29/04
17:10:52
Next SCN: 0x0000.04B5A5F0
476.Recid # 19 Recno 19 Record TimeStamp
04/29/04
17:10:52
Thread = 1 seq # = 19 link-recid = 18
477.LOW SCN: 0x0000.04B4DFCD
04/29/04
08:47:27
Next SCN: 0x0000.04B551B5
478.Recid # 18 Recno 18 Record TimeStamp
04/29/04
08:47:27
Thread = 1 SEQ # = 18 link-recid = 17
479.LOW SCN: 0x0000.04B47AFE
04/28/04
15:47:36
Next SCN: 0x0000.04B4DFCD
480.Recid # 17 Recno 17 Record TimeStamp
04/28/04
15:47:36
Thread = 1 SEQ # = 17 link-recid = 16
481.LOW SCN: 0x0000.04B426A9
04/28/04
10:46:54
Next SCN: 0x0000.04B47AFE
482.Recid # 16 Recno 16 Record TimeStamp
04/28/04
10:46:54
Thread = 1 SEQ # = 16 link-recid = 15
483.LOW SCN: 0x0000.04B3D745
04/28/04
10:24:23
Next SCN: 0x0000.04B426A9
484.Recid # 15 Recno 15 Record TimeStamp
04/28/04
10:24:24
Thread = 1 SEQ # = 15 link-recid = 14
485.LOW SCN: 0x0000.04B34C54
04/27/04
09:25:18
Next SCN: 0x0000.04B3D745
486.Recid # 14 Recno 14 Record TimeStamp
04/27/04
09:25:18
Thread = 1 SEQ # = 14 link-recid = 13
487.LOW SCN: 0x0000.04B2DB02
04/17/04
11:54:17
Next SCN: 0x0000.04B34C54
488.Recid # 13 Recno 13 Record TimeStamp
04/17/04
11:54:17
Thread = 1 SEQ # = 13 link-recid = 12
489.Low SCN: 0x0000.04B27786
04/16/04
19:06:32
Next SCN: 0x0000.04B2DB02
490.Recid # 12 Recno 12 Record TimeStamp
04/16/04
19:06:32
Thread = 1 SEQ # = 12 link-recid = 11
491.LOW SCN: 0x0000.04B225C5
04/03/04
13:17:32
Next SCN: 0x0000.04B27786492.Recid # 11 Recno 11 Record TimeStamp
04/03/04
13:17:32
Thread = 1 SEQ # = 11 link-recid = 10
493.LOW SCN: 0x0000.04B1CAEC
04/02/04
13:37:07
Next SCN: 0x0000.04B225C5
494.Recid # 10 Recno 10 Record TimeStamp
04/02/04
13:37:08
Thread = 1 seq # = 10 link-recid = 9
495.Low SCN: 0x0000.04B1759E
02/27/04
13:42:16
Next SCN: 0x0000.04B1CAEC
496.Recid # 9 Recno 9 Record TimeStamp
02/27/04
13:42:16
Thread = 1 SEQ # = 9 link-recid = 8
497.LOW SCN: 0x0000.04B10A6B
02/14/04
10:34:55
Next SCN: 0x0000.04B1759E
498.Recid # 8 Recno 8 record timestamp
02/14/04
10:34:55
Thread = 1 SEQ # = 8 link-recid = 7
499.Low SCN: 0x0000.04B0A354
02/13/04
11:24:29
Next SCN: 0x0000.04B10A6B
500.Recid # 7 Recno 7 Record TimeStamp
02/13/04
11:24:29
Thread = 1 SEQ # = 7 link-recid = 6
501.LOW SCN: 0x0000.04B046F0
02/11/04
13:19:35
Next SCN: 0x0000.04B0A354
502.Recid # 6 Recno 6 Record TimeStamp
02/11/04
13:19:35
Thread = 1 SEQ # = 6 link-recid = 5
503.LOW SCN: 0x0000.04AF02F4
10/08/03
08:53:42
Next SCN: 0x0000.04B046F0
504.Recid # 5 Recno 5 Record TimeStamp
10/08/03
08:53:42
Thread = 1 SEQ # = 5 link-recid = 4
505.LOW SCN: 0x0000.04AEADBB
08/08/03
15:15:38
Next SCN: 0x0000.04AF02F4
506.Recid # 4 Recno 4 record timestamp
08/08/03
15:15:38
Thread = 1 SEQ # = 4 link-recid = 3
507.LOW SCN: 0x0000.04AE599C
07/20/03
10:47:36
Next SCN: 0x0000.04AEADBB
508.Recid # 3 Recno 3 Record TimeStamp
07/20/03
10:47:36
Thread = 1 SEQ # = 3 link-recid = 2
509.LOW SCN: 0x0000.04AE07A9
07/20/03
09:43:05
Next SCN: 0x0000.04AE599C
510.Recid # 2 Recno 2 Record TimeStamp
07/20/03
09:43:05
Thread = 1 SEQ # = 2 link-recid = 1
511.LOW SCN: 0x0000.04AE05FB07 / 20/03
09:30:37
Next SCN: 0x0000.04AE07A9
512.Recid # 1 Recno 1 record timestamp
07/20/03
09:30:37
Thread = 1 SEQ # = 1 link-recid = 0
513.LOW SCN: 0x0000.04ADA796
07/13/03
14:34:39
Next SCN: 0x0000.04AE05FB
Offline range record (this item starts from Oracle8)
514.1 **************************************************************** ******************
515. OFFLINE RANGE RECORDS
516. ******************************************************** ******************
517. (BLKNO = 0x1b, size = 56, max = 145, in-use = 0, Last-Recid = 0)
Archive log record (this item is introduced from Oracle8)
518. ****************************************************************** ******************
519. Archived log records
520.1 ******************************************************************* ******************
521. (BLKNO = 0x1c, size = 584, max = 237, in-use = 31, Last-Recid = 31)
522.earliest Record:
523.Recid # 1 Recno 1 record timestamp
07/20/03
09:30:39
Thread = 1 SEQ # = 1
524.flags:
525.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
526.FileName E: /oracle/oradata/test/archive/1_1.arc
527.Low SCN: 0x0000.04ADA796
07/13/03
14:34:39
Next SCN: 0x0000.04AE05FB
07/20/03
09:30:37
528.block count = 608 blocksize = 512
529.latest record:
530.Recid # 31 Recno 31 Record TimeStamp
05/14/04
08:37:00
Thread = 1 SEQ # = 31
531.Flags:
532.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
533.FileName E: /oracle/oradata/test/archive/1_31.arc
534.Low SCN: 0x0000.04B9870A
05/13/04
19:43:45
Next SCN: 0x0000.04B9D85705 / 14/04
08:36:59
535.block count = 306 blocksize = 512
536.Recid # 30 Recno 30 Record TimeStamp
05/13/04
19:43:47
Thread = 1 SEQ # = 30
537.Flags:
538.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
539.FileName E: /oracle/oradata/test/archive/1_30.arc
540.Low SCN: 0x0000.04B93016
05/13/04
16:31:24
Next SCN: 0x0000.04B9870A
05/13/04
19:43:45
541.block count = 346 blocksize = 512
542.Recid # 29 Recno 29 Record TimeStamp
05/13/04
16:31:26
Thread = 1 SEQ # = 29
543.Flags:
544.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
545.FileName E: /oracle/oradata/test/archive/1_29.arc
546.Low SCN: 0x0000.04B8B9AD
05/11/04
14:27:28
Next SCN: 0x0000.04B93016
05/13/04
16:31:24
547.block count = 1062 blocksize = 512
548.Recid # 28 Recno 28 record timestamp
05/11/04
14:27:33
Thread = 1 SEQ # = 28
549.flags:
550.Resetlogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
551.FileName E: /oracle/oradata/test/archive/1_28.arc
552.Low SCN: 0x0000.04B854E4
05/11/04
08:14:52
Next SCN: 0x0000.04B8B9AD
05/11/04
14:27:28
553.block count = 785 blocksize = 512
554.Recid # 27 Recno 27 Record TimeStamp
05/11/04
08:15:01
Thread = 1 SEQ # = 27
555.Flags:
556.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
557.FileName E: /oracle/oradata/test/archive/1_27.arc
558.Low SCN: 0x0000.04B7EFC3
05/10/04
18:00:17
Next SCN: 0x0000.04B854E405 / 11/04
08:14:52
559.block count = 38044 blocksize = 512
560.Recid # 26 Recno 26 Record TimeStamp
05/10/04
18:00:30
Thread = 1 SEQ # = 26
561.flags:
562.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
563.FileName E: /oracle/oradata/test/archive/1_26.arc
564.Low SCN: 0x0000.04B7D716
05/10/04
13:16:04
Next SCN: 0x0000.04B7EFC3
05/10/04
18:00:17
565.block count = 61433 blocksize = 512
566.Recid # 25 Recno 25 Record TimeStamp
05/10/04
13:16:07
Thread = 1 SEQ # = 25
567.Flags:
568.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
569.FileName E: /oracle/oradata/test/archive/1_25.arc
570.Low SCN: 0x0000.04B759E6
05/09/04
08:41:38
Next SCN: 0x0000.04B7D716
05/10/04
13:16:04
571.block count = 909 blocksize = 512
572.Recid # 24 Recno 24 Record TimeStamp
05/09/04
08:41:43
Thread = 1 SEQ # = 24
573.Flags:
574.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
575.FileName E: /oracle/oradata/test/archive/1_24.arc
576.LOW SCN: 0x0000.04B6D74D
05/08/04
09:45:10
Next SCN: 0x0000.04B759E6
05/09/04
08:41:38
577.block count = 21946 blocksize = 512
578.Recid # 23 Recno 23 record timestamp
05/08/04
09:45:14
Thread = 1 SEQ # = 23
579.flags:
580.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
581.FileName E: /oracle/oradata/test/archive/1_23.arc
582.Low SCN: 0x0000.04B67D98
05/02/04
15:36:17
Next SCN: 0x0000.04B6D74D
05/08/04
09:45:10
583.block count = 11872 blocksize = 512
584.Recid # 22 Recno 22 Record TimeStamp
05/02/04
15:36:19
Thread = 1 SEQ # = 22
585.flags:
586.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
587.FileName E: /oracle/oradata/test/archive/1_22.arc
588.Low SCN: 0x0000.04B62189
05/02/04
08:19:22
Next SCN: 0x0000.04B67D98
05/02/04
15:36:17
589.block count = 373 blocksize = 512
590.Recid # 21 Recno 21 Record TimeStamp
05/02/04
08:19:24
Thread = 1 SEQ # = 21
591.Flags:
592.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
593.FileName E: /oracle/oradata/test/archive/1_21.arc
594.LOW SCN: 0x0000.04B5A5F0
04/30/04
07:32:34
Next SCN: 0x0000.04B62189
05/02/04
08:19:22
595.block count = 645 blocksize = 512
596.Recid # 20 Recno 20 Record TimeStamp
04/30/04
07:32:37
Thread = 1 SEQ # = 20
597.Flags:
598.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
599.FileName E: /oracle/oradata/test/archive/1_20.arc
600.LOW SCN: 0x0000.04B551B5
04/29/04
17:10:52
Next SCN: 0x0000.04B5A5F0
04/30/04
07:32:34
601.block count = 378 blocksize = 512
602.Recid # 19 Recno 19 Record TimeStamp
04/29/04
17:10:54
Thread = 1 SEQ # = 19
603.Flags:
604.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
605.FileName E: /oracle/oradata/test/archive/1_19.arc
606.Low SCN: 0x0000.04B4DFCD
04/29/04
08:47:27
Next SCN: 0x0000.04B551B5
04/29/04
17:10:52
607.block count = 711 blocksize = 512
608.Recid # 18 Recno 18 Record TimeStamp
04/29/04
08:47:31
Thread = 1 SEQ # = 18
609.Flags:
610.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
611.FileName E: /oracle/oradata/test/archive/1_18.arc
612.LOW SCN: 0x0000.04B47AFE
04/28/04
15:47:36
Next SCN: 0x0000.04B4DFCD
04/29/04
08:47:27
613.block count = 471 blocksize = 512
614.Recid # 17 Recno 17 Record TimeStamp
04/28/04
15:47:38
Thread = 1 SEQ # = 17
615.Flags:
616.Resetlogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
617.FileName E: /oracle/oradata/test/archive/1_17.arc
618.LOW SCN: 0x0000.04B426A9
04/28/04
10:46:54
Next SCN: 0x0000.04B47AFE
04/28/04
15:47:36
619.block count = 336 blocksize = 512
620.Recid # 16 Recno 16 Record TimeStamp
04/28/04
10:46:56
Thread = 1 SEQ # = 16
621.flags:
622.Resetlogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
623.FileName E: /oracle/oradata/test/archive/1_16.arc
624.Low SCN: 0x0000.04B3D745
04/28/04
10:24:23
Next SCN: 0x0000.04B426A9
04/28/04
10:46:54
625.block count = 272 blocksize = 512
626.Recid # 15 Recno 15 Record TimeStamp
04/28/04
10:24:26
Thread = 1 SEQ # = 15
627.Flags:
628.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
629.FileName E: /oracle/oradata/test/archive/1_15.arc
630.LOW SCN: 0x0000.04B34C54
04/27/04
09:25:18
Next SCN: 0x0000.04B3D74504 / 28/04
10:24:23
631.block count = 755 blocksize = 512
632.Recid # 14 Recno 14 Record TimeStamp
04/27/04
09:25:22
Thread = 1 SEQ # = 14
633.Flags:
634.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
635.FileName E: /oracle/oradata/test/archive/1_14.arc
636.LOW SCN: 0x0000.04B2DB02
04/17/04
11:54:17
Next SCN: 0x0000.04B34C54
04/27/04
09:25:18
637.block count = 7292 blocksize = 512
638.Recid # 13 Recno 13 Record TimeStamp
04/17/04
11:54:19
Thread = 1 SEQ # = 13
639.Flags:
640.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
641.FileName E: /oracle/oradata/test/archive/1_13.arc
642.Low SCN: 0x0000.04B27786
04/16/04
19:06:32
Next SCN: 0x0000.04B2DB02
04/17/04
11:54:17
643.block count = 414 blocksize = 512
644.Recid # 12 Recno 12 record timestamp
04/16/04
19:06:34
Thread = 1 SEQ # = 12
645.flags:
646.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
647.FileName E: /oracle/oradata/test/archive/1_12.arc
648.Low SCN: 0x0000.04B225C5
04/03/04
13:17:32
Next SCN: 0x0000.04B27786
04/16/04
19:06:32
649.block count = 285 blocksize = 512
650.Recid # 11 Recno 11 Record TimeStamp
04/03/04
13:17:33
Thread = 1 SEQ # = 11
651.flags:
652.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
653.FileName E: /oracle/oradata/test/archive/1_11.arc
654.LOW SCN: 0x0000.04B1CAEC
04/02/04
13:37:07
Next SCN: 0x0000.04B225C504 / 03/04
13:17:32
655.block count = 350 blocksize = 512
656.Recid # 10 Recno 10 record timestamp
04/02/04
13:37:09
Thread = 1 SEQ # = 10
657.Flags:
658.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
659.FileName E: /oracle/oradata/test/archive/1_10.arc
660.Low SCN: 0x0000.04B1759E
02/27/04
13:42:16
Next SCN: 0x0000.04B1CAEC
04/02/04
13:37:07
661.block count = 305 blocksize = 512
662.Recid # 9 Recno 9 Record TimeStamp
02/27/04
13:42:18
Thread = 1 SEQ # = 9
663.Flags:
664.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
665.FileName E: /oracle/oradata/test/archive/1_9.arc
666.LOW SCN: 0x0000.04B10A6B
02/14/04
10:34:55
Next SCN: 0x0000.04B1759E
02/27/04
13:42:16
667.block count = 683 blocksize = 512
668.Recid # 8 Recno 8 record timestamp
02/14/04
10:34:57
Thread = 1 SEQ # = 8
669.Flags:
670.Resetlogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
671.FileName E: /oracle/oradata/test/archive/1_8.arc
672.Low SCN: 0x0000.04B0A354
02/13/04
11:24:29
Next SCN: 0x0000.04B10A6B
02/14/04
10:34:55
673.block count = 466 blocksize = 512
674.Recid # 7 Recno 7 Record TimeStamp
02/13/04
11:24:31
Thread = 1 SEQ # = 7
675.Flags:
676.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
677.FileName E: /oracle/oradata/test/archive/1_7.arc
678.Low SCN: 0x0000.04B046F0
02/11/04
13:19:35
Next SCN: 0x0000.04B0A35402 / 13/04
11:24:29
679.block count = 363 blocksize = 512
680.Recid # 6 Recno 6 Record TimeStamp
02/11/04
13:19:37
Thread = 1 SEQ # = 6
681.Flags:
682.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
683.FileName E: /oracle/oradata/test/archive/1_6.arc
684.LOW SCN: 0x0000.04AF02F4
10/08/03
08:53:42
Next SCN: 0x0000.04B046F0
02/11/04
13:19:35
685.block count = 2464 blocksize = 512
686.Recid # 5 Recno 5 record timestamp
10/08/03
08:53:44
Thread = 1 SEQ # = 5
687.Flags:
688.Resetlogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
689.FileName E: /oracle/oradata/test/archive/1_5.arc
690.Low SCN: 0x0000.04AEADBB
08/08/03
15:15:38
Next SCN: 0x0000.04AF02F4
10/08/03
08:53:42
691.block count = 384 blocksize = 512
692.Recid # 4 Recno 4 record timestamp
08/08/03
15:15:41
Thread = 1 SEQ # = 4
693.Flags:
694.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
695.FileName E: /oracle/oradata/test/archive/1_4.arc
696.LOW SCN: 0x0000.04AE599C
07/20/03
10:47:36
Next SCN: 0x0000.04AEADBB
08/08/03
15:15:38
697.block count = 302 blocksize = 512
698.Recid # 3 Recno 3 record timestamp
07/20/03
10:47:37
Thread = 1 SEQ # = 3
699.Flags:
700.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
701.FileName E: /oracle/oradata/test/archive/1_3.arc
702.Low SCN: 0x0000.04AE07A9
07/20/03
09:43:05
Next SCN: 0x0000.04AE599C07 / 20/03
10:47:36
703.block count = 41 blocksize = 512
704.Recid # 2 Recno 2 record timestamp
07/20/03
09:43:05
Thread = 1 SEQ # = 2
705.Flags:
706.Resetlogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
707.FileName E: /oracle/oradata/test/archive/1_2.arc
708.Low SCN: 0x0000.04AE05FB
07/20/03
09:30:37
Next SCN: 0x0000.04AE07A9
07/20/03
09:43:05
709.block count = 385 blocksize = 512
710.Recid # 1 Recno 1 Record TimeStamp
07/20/03
09:30:39
Thread = 1 SEQ # = 1
711.Flags:
712.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
713.FileName E: /oracle/oradata/test/archive/1_1.arc
714.LOW SCN: 0x0000.04ADA796
07/13/03
14:34:39
Next SCN: 0x0000.04AE05FB
07/20/03
09:30:37
715.block count = 608 blocksize = 512
Use the RMAN backup database for backup collection records (which starts from Oracle8)
716. ****************************************************************** ******************
717. Backup Set Records
718. ******************************************************* ******************
719. (BLKNO = 0x2d, size = 40, max = 204, in-use = 0, Last-Recid = 0)
Use the RMAN backup database of backup tablets (which is introduced from Oracle8)
720.1 ****************************************************************** ******************
721. BACKUP PIECE RECORDS
722.1 ******************************************************** ******************
723. (BLKNO = 0x2e, size = 736, max = 210, in-use = 0, Last-Recid = 0)
Use the RMAN backup record of the backup data file of the database (this item starts from Oracle8)
724.1 ***************************************************************** ****************** 725. Backup DataFile Records
726.1 ***************************************************************** ******************
727. (BLKNO = 0x41, size = 116, max = 211, in-use = 0, Last-Recid = 0)
Use the RMAN backup database to back up the record item of the archive log file (this item is introduced from ORACLE8)
728. ********************************************************** ******************
729. Backup Log Records
730. ********************************************************* ******************
731. (BLKNO = 0x44, size = 76, max = 107, in-use = 0, Last-Recid = 0)
Use the RMAN backup database record item (this item starts from Oracle8)
732. ********************************************************* ******************
733. DataFile Copy Records
734.1 ******************************************************* ******************
735. (BLKNO = 0x45, size = 660, max = 210, in-use = 1, Last-Recid = 1)
736.earliest Record:
737.Recid # 1 Recno 1 record timestamp
07/20/03
09:43:04
738.file = 0 (0) Database ID = 1750352942 block size = 8192
739.Flags:
740.FileName: D: /hot_backup/control02.ctl
741.Creation Checkpointed AT SCN: 0x0000.00000000
07/13/03
14:30:52
742.file header checkpointed at scN: 0x0000.04ae079e
07/20/03
09:43:02
743.Resetlogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
744.Recovery Fuzzy SCN AND TIME SCN: 0x0000.00000000
01/01/88
00:00:00
745.absolute Fuzzy SCN: 0x0000.00000000
746.Newly-marked Media Corrupt Blocks 0 Total Media Corrupt Blocks 0
747. Total Logically Corrupt Blocks 0 Block images Written to backup 228
748.
Low
OFFLINE
Range
Recid 0
749.tag:
750.copy does.751.latest Record:
752.Recid # 1 recno 1 record timestamp
07/20/03
09:43:04
753.File = 0 (0) Database ID = 1750352942 block size = 8192
754.Flags:
755.FileName: D: /hot_backup/control02.ctl
756.Creation Checkpointed AT SCN: 0x0000.0000000000
07/13/03
14:30:52
757.file header checkpointed at scN: 0x0000.04ae079e
07/20/03
09:43:02
758.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
759.Recovery Fuzzy SCN AND TIME SCN: 0x0000.00000000
01/01/88
00:00:00
760.Absolute Fuzzy SCN: 0x0000.00000000
761.Newly-marked Media Corrupt Blocks 0 Total Media Corrupt Blocks 0
762.Total Logically Corrupt Blocks 0 Block images Written to backup 228
763.
Low
OFFLINE
Range
Recid 0
764.tag:
765.copy Does Not Have Keep Options.
The backup data file of the RMAN backup database is damaged (which is introduced from ORACLE8)
766. ******************************************************************** ******************
767. Backup DataFile Corruption Records
768. ***************************************************************** ******************
769. (BLKNO = 0x56, size = 44, max = 185, in-use = 0, Last-Recid = 0)
Copy damage record using the RMAN backup database (this item is introduced from Oracle8)
770. ********************************************************** ******************
771. DataFile Copy Corruption Records
772.1 ********************************************************** ******************
773. (BLKNO = 0x57, size = 40, max = 204, in-use = 0, last-recid = 0)
Use the RMAN backup database to delete record (this item is introduced from Oracle8)
774. ******************************************************** ******************
775. Deletion Records
776. ***************************************************************** ****************** 777. (BLKNO = 0x58, size = 20, max = 408, in-use = 0, Last-Recid = 0)
Use the RMAN backup database of proxy copy record (this item is introduced from Oracle8i)
778. ****************************************************************** ******************
779. Proxy Copy Records
780. ******************************************************** ******************
781. (BLKNO = 0x59, size = 852, max = 210, in-use = 0, Last-Recid = 0)
INCARNATION RECORDS (This item is introduced from Oracle9i)
782. ***************************************************************** ******************
783. INCARNATION RECORDS
784.1 ***************************************************************** ******************
785. (BLKNO = 0x72, size = 56, max = 145, in-use = 1, Last-Recid = 1)
786.earliest Record:
787.Recid # 1 recno 1 record timestamp
788.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
789.Previous Resetlogs SCN AND TIME SCN: 0x0000.04A0B855
04/11/03
09:59:18
790.latest record:
791.Recid # 1 Recno 1 record timestamp
792.ResetLogs SCN AND TIME SCN: 0x0000.04ADA796
07/13/03
14:34:39
793.PREVIOS RESETLOGS SCN AND TIME SCN: 0x0000.04A0B855
04/11/03
09:59:18
794. *** End of dump ***
