oracle 9201的控制文件內容列表:
 
 
控制文件頭...
數據庫項... 
檢查點進度記錄(該項從oracle8開始引入)... 
擴展的數據庫項(該項從oracle9i開始引入)... 
重做線程項... 
日志文件項... 
數據文件項... 
臨時文件記錄項(該項從oracle9i開始引入)... 
表空間記錄項(該項從oracle8開始引入)... 
rman配置記錄項(該項從oracle9i開始引入)... 
日志文件歷史記錄項... 
脫機范圍記錄項(該項從oracle8開始引入)... 
歸檔日志記錄項(該項從oracle8開始引入)... 
使用rman備份數據庫的備份集記錄項(該項從oracle8開始引入)... 
使用rman備份數據庫的備份片記錄項(該項從oracle8開始引入)... 
使用rman備份數據庫的備份數據文件的記錄項(該項從oracle8開始引入)... 
使用rman備份數據庫的備份歸檔日志文件的記錄項(該項從oracle8開始引入)... 
使用rman備份數據庫時數據文件拷貝的記錄項(該項從oracle8開始引入)... 
使用rman備份數據庫的備份數據文件損壞記錄項(該項從oracle8開始引入)... 
使用rman備份數據庫的數據文件拷貝損壞記錄項(該項從oracle8開始引入)... 
使用rman備份數據庫的刪除記錄(該項從oracle8開始引入)... 
使用rman備份數據庫的代理拷貝記錄項(該項從oracle8i開始引入)... 
incarnation records(該項從oracle9i開始引入)... 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
第1行到第22行的內容為控制文件的頭信息,這部分內容的解釋參見《轉儲控制文件頭》。
控制文件頭
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
 
=======第17行到第22行為通用文件頭========
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
**************************控制文件頭信息結束****************************
 
 
數據庫項
23.**********************************************************************
24.database entry  
25.**********************************************************************
26.  (blkno = 0x1, size = 192, max = 1, in-use = 1, last-recid= 0)
blkno
size指出數據庫項的字節數,本例中為192byte;
max指出最大的塊
in-use當前正在使用的塊
last-recid
 
27.  df version: creation=0x9200000 compatible=0x8000000, date  07/13/2003 14:30:51
數據文件的版本是9.2.0,兼容版本是8.0
 
28.  db name "test1"
數據庫名為"test1"
 
29.  database flags = 0x00404001
 
 
30.  controlfile creation timestamp  07/13/2003 14:30:52
控制文件的創建時間
 
31.  incmplt recovery scn: 0x0000.00000000
如果數據庫進行過不完全回復,我們可以看出
 
32.  resetlogs scn: 0x0000.04ada796 resetlogs timestamp  07/13/2003 14:34:39
啟用resetlogs時的scn值和時戳,
 
33.  prior resetlogs scn: 0x0000.04a0b855 prior resetlogs timestamp  04/11/2003 09:59:18
啟用resetlogs之前的scn值和時戳
oracle不能夠應用resetlogs之前的重做日志(redo log file)。
 
34.  redo version: creation=0x9200000 compatable=0x9200000
重做日志文件的版本是9.2.0,兼容版本是8.0
 
35.  #data files = 12, #online files = 12
數據庫總共有12個數據文件,并且這12個文件全部處在聯機(online)狀態
 
36.  database checkpoint: thread=1 scn: 0x0000.04b9d858
 
 
37.  threads: #enabled=1, #open=1, head=1, tail=1
當前啟用了一個線程,當然,也僅僅打開了這一個線程
 
38.  enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
 
 
39.  max log members = 3, max data members = 1
數據庫允許每個日志組最多有3個log member;
oracle目前還不支持數據文件的多路復用,因此,max data members的值為1,這個條目是為以后的版本升級而預留的。
 
40.  arch list: head=3, tail=3, force scn: 0x0000.04b93016scn: 0x0000.04b9d857
請注意force scn,凡是開始scn小于force scn的重做都被歸檔。強制scn是所有重做都被歸檔的scn。
 
41.  controlfile checkpointed at scn:  0x0000.04b9d85a 05/14/2004 08:37:00
當前控制文件checkpointed時的scn為0x0000.04b9d85a???
 
42.  thread:0 rba:(0x0.0.0)
43.  enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
 
 
 
檢查點進度記錄(該項從oracle8開始引入)
44.**********************************************************************
45.checkpoint progress records
46.  **********************************************************************
檢查點進度記錄這個條目是從oracle 8開始出現在控制文件中的。該項目主要用來記錄緩沖區高速緩存的狀態,每個記錄占用控制文件的一個塊。
 
47.   (blkno = 0x4, size = 104, max = 1, in-use = 1, last-recid= 0)
48.  thread #1 - status:0x2 flags:0x0 dirty:15
線程信息,
 
49.  low cache rba:(0x20.1f0.0) on disk rba:(0x20.204.0)
低速緩存rba(recovery block address)指出了在實例回復或者崩潰恢復中,需要恢復的重做開始值(即,重做日志文件中的一個塊地址);
on disk rba是磁盤上的最高的重做值,在進行實力恢復應用重做的時候必須達到這個值。如果on disk rba
 
50.  on disk scn: 0x0000.04b9f6e2 05/14/2004 15:06:42
on disk scn是on disk rba處的scn值
 
51.  resetlogs scn: 0x0000.04ada796 07/13/2003 14:34:39
啟用resetlogs時的scn值和時戳,和數據庫項中的相應條目是一致的
 
 
52.  heartbeat: 526099342 mount id: 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 measured: 32758
57.  data block handling time: avg: 22934, times measured: 135
 
 
 
 
 
擴展的數據庫項(該項從oracle9i開始引入)
58.  ***********************************************************************
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 
 
 
重做線程項
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
這個條目說明數據庫中總共有4個日志文件組,第一個組為log #1(log group 1);最后一個組為log #4(log group 4),當前正在使用的是log #3(log group 3)
 
70.  enabled at scn: 0x0000.04ada796 07/13/2003 14:34:39
啟用線程1時的scn值
 
71.  disabled at scn: 0x0000.00000000 01/01/1988 00:00:00
禁用線程1時的scn值,因為該線程目前處于打開狀態,所以該值為無窮大
 
72.  opened at 05/14/2004 08:36:59 by instance test
打開線程的時戳,當前線程以及被哪個實例打開
 
73.  checkpointed at scn:  0x0000.04b9d858 05/14/2004 08:36:59
 
 
74.  thread:1 rba:(0x20.2.10)
75.  enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
76.  00000000 00000000
77.  log history: 31
 
 
 
日志文件項
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寫滿后,會切換到forward: 2,即切換到log file #2,這一點可以通過log file #1的next scn: 0x0000.04b9870a等于log file #2的low scn: 0x0000.04b9870a
 
85.  siz: 0xf000 seq: 0x0000001e hws: 0x6 bsz: 512 nab: 0x15b flg: 0x1 dup: 1
nab是日志文件中lgwr可用的下一個數據塊的地址,如果這個值是無窮大,說明這個日志文件是當前(lgwr正在寫入)的日志文件
 
86.  archive links: fwrd: 0 back: 0 prev scn: 0x0000.04b8b9ad
 
 
87.  low scn: 0x0000.04b93016 05/13/2004 16:31:24
日志發生切換時會分配一個低scn和一個高scn,低scn就是上一個日志的高scn的值,而高scn則設置為無窮大,直到切換到下一個日志文件時,再將當前日志的高scn設置為下一個日志文件的低scn,將下一個日志文件的高scn設置為無窮大。
 
88.  next scn: 0x0000.04b9870a 05/13/2004 19:43:45
日志發生切換后,高scn就從無窮大該為next scn(下一個scn)的值,該值將作為切換后的日志文件的低scn
 
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: 0xffffffff flg: 0x8 dup: 1
100.archive links: fwrd: 0 back: 0 prev scn: 0x0000.04b9870a
101.low scn: 0x0000.04b9d857 05/14/2004 08:36:59
102.next scn: 0xffff.ffffffff 01/01/1988 00:00:00
說明,log file #3是當前日志文件(lgwr正在寫入的日志文件)
 
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
 
 
 
數據文件項
111.            ******************************************************************
112.            data file records
113.            ******************************************************************
114.(blkno = 0x6, size = 180, max = 100, in-use = 14, last-recid= 41)
 
 
115.            data file #1: 
116.(name #17) e:/oracle/ora92/test ystem01.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
說明是系統表空間
 
119.unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
120.checkpoint cnt:701 scn: 0x0000.04b9d858 05/14/2004 08:36:59
對該文件執行檢查點的次數為701(文件處于熱備狀態時,如果發生了檢查點,檢查點計數器(checkpoint cnt)也還是加一);
 
121.stop scn: 0xffff.ffffffff 05/13/2004 20:18:03
結束scn(stop scn)是數據文件的最后一個scn(數據庫正常關閉時會設置這個值),數據庫正常打開的狀態,該值為無窮大。數據庫恢復時要求恢復到stop scn。
 
122.creation checkpointed at scn:  0x0000.00000014 01/13/2002 22:01:17
當時用“alter database create datafile”命令恢復數據文件時(該命令從oracle7開始引入),需要依據文件創建時的檢查點scn(creation checkpointed at scn)。
 
123.thread:0 rba:(0x0.0.0)
124.enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
 
 
125.  offline scn: 0x0000.04ada795 prev_range: 0
當文件脫機時,文件脫機時的scn作為脫機scn保存在控制文件中
 
126.online checkpointed at scn:  0x0000.04ada796 07/13/2003 14:34:39
當文件聯機時,文件聯機時的檢查點scn作為聯機scn保存在控制文件中
        由于系統表空間的數據文件永遠不能脫機,所以系統數據文件的脫機scn應該為0x0000.00000000
 
猜想,這里的offline scn表示數據庫上一次正常關閉時數據文件的檢查點scn;
這里的online checkpointed at scn表示數據庫本次打開時的數據文件的檢查點scn
 
 
 
127.thread:1 rba:(0x1.2.0)
128.enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000
129.hot backup end marker scn: 0x0000.00000000
熱備時的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.ffffffff 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:  00000000 00000000 00000000 00000000 00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
146.00000000 00000000
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:  00000000 00000000 00000000 00000000 00000000 00000000
159.00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
164.00000000 00000000
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.ffffffff 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:  00000000 00000000 00000000 00000000 00000000 00000000
177.00000000 00000000
178.offline scn: 0x0000.04ada795 prev_range: 0
179.online checkpointed at scn:  0x0000.04ada796 07/13/2003 14:34:39
180.thread:1 rba:(0x1.2.0)
181.enabled  threads:  01000000 00000000 00000000 00000000 00000000 00000000
182.00000000 00000000
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.ffffffff 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:  00000000 00000000 00000000 00000000 00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
200.00000000 00000000
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.ffffffff 05/13/2004 20:18:03
210.creation checkpointed at scn:  0x0000.000018b7 01/13/2002 22:03:09
211.thread:0 rba:(0x0.0.0)
212.enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000
213.00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
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.ffffffff 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:  00000000 00000000 00000000 00000000 00000000 00000000
231.00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
236.00000000 00000000
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/2004 08:36:59
245.stop scn: 0xffff.ffffffff 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:  00000000 00000000 00000000 00000000 00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
254.00000000 00000000
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 00000000 00000000 00000000 00000000 00000000
267.00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
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=0
279.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.ffffffff 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 00000000 00000000 00000000 00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
290.00000000 00000000
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.ffffffff 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 00000000 00000000 00000000 00000000 00000000
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:  01000000 00000000 00000000 00000000 00000000 00000000
308.00000000 00000000
309.hot backup end marker scn: 0x0000.00000000
310.aux_file is not defined 
 
 
311.            data file #12: <deleted>
312.creation size=1280 block size=8192 status=0x800 head=0 tail=0 dup=0
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:  01000000 00000000 00000000 00000000 00000000 00000000
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 00000000 00000000 00000000 00000000 00000000
325.00000000 00000000
326.hot backup end marker scn: 0x0000.00000000
327.aux_file is not defined 
 
 
328.            data file #13: <deleted>
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 00000000 00000000 00000000 00000000 00000000
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:  00000000 00000000 00000000 00000000 00000000 00000000
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.ffffffff 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 00000000 00000000 00000000 00000000 00000000
355.00000000 00000000
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 00000000 00000000 00000000 00000000 00000000
360.00000000 00000000
361.hot backup end marker scn: 0x0000.00000000
362.aux_file is not defined 
 
 
 
臨時文件記錄項(該項從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
 
 
 
表空間記錄項(該項從oracle8開始引入)
372.            ******************************************************************
373.            tablespace records
374.            ******************************************************************
375.(blkno = 0x11, size = 68, max = 100, in-use = 16, last-recid= 9)
376.tablespace #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.tablespace #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.tablespace #3 drsys: recno=3
385.first datafile link=3  tablespace flag=0
386.tablespace 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.tablespace #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.tablespace #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.tablespace #6 users: recno=6
397.first datafile link=6  tablespace flag=0
398.tablespace pitr mode 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.00000000 01/01/1988 00:00:00
403.tablespace pitr last completion scn: 0x0000.00000000 01/01/1988 00:00:00
404.tablespace #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.tablespace #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.tablespace #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.tablespace #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.tablespace #2147483647 undo_test: recno=14
429.first datafile link=0  tablespace flag=0
430.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.tablespace #2147483647 sort: recno=15
433.first datafile link=0  tablespace flag=1
434.tablespace pitr mode 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.tablespace #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配置記錄項(該項從oracle9i開始引入)
440.            ******************************************************************
441.            rman configuration records
442.            ******************************************************************
443.(blkno = 0x13, size = 1108, max = 50, in-use = 0, last-recid= 0)
 
 
 
日志文件歷史記錄項
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:45 next 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=20
473.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.04b27786
492.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.04ae05fb 07/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
 
 
 
脫機范圍記錄項(該項從oracle8開始引入)
514.            ******************************************************************
515.            offline range records
516.            ******************************************************************
517.(blkno = 0x1b, size = 56, max = 145, in-use = 0, last-recid= 0)
 
 
 
歸檔日志記錄項(該項從oracle8開始引入)
518.            ******************************************************************
519.            archived log records
520.            ******************************************************************
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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.04b9d857 05/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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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.04b854e4 05/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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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.04b3d745 04/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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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.04b225c5 04/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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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.04b0a354 02/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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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: <produced by archive operation> <created by the arch process>
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.04ae599c 07/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: <produced by archive operation> <created by the foreground process>
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: <produced by archive operation> <created by the arch process>
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
 
 
 
使用rman備份數據庫的備份集記錄項(該項從oracle8開始引入)
716.            ******************************************************************
717.            backup set records
718.            ******************************************************************
719.(blkno = 0x2d, size = 40, max = 204, in-use = 0, last-recid= 0)
 
 
 
使用rman備份數據庫的備份片記錄項(該項從oracle8開始引入)
720.            ******************************************************************
721.            backup piece records
722.            ******************************************************************
723.(blkno = 0x2e, size = 736, max = 210, in-use = 0, last-recid= 0)
 
 
 
使用rman備份數據庫的備份數據文件的記錄項(該項從oracle8開始引入)
724.            ******************************************************************
725.            backup datafile records
726.            ******************************************************************
727.(blkno = 0x41, size = 116, max = 211, in-use = 0, last-recid= 0)
 
 
 
使用rman備份數據庫的備份歸檔日志文件的記錄項(該項從oracle8開始引入)
728.            ******************************************************************
729.            backup log records
730.            ******************************************************************
731.(blkno = 0x44, size = 76, max = 107, in-use = 0, last-recid= 0)
 
 
 
使用rman備份數據庫時數據文件拷貝的記錄項(該項從oracle8開始引入)
732.            ******************************************************************
733.            datafile copy records
734.            ******************************************************************
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 not have keep options.
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.00000000 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.
 
 
 
使用rman備份數據庫的備份數據文件損壞記錄項(該項從oracle8開始引入)
766.            ******************************************************************
767.            backup datafile corruption records
768.            ******************************************************************
769.(blkno = 0x56, size = 44, max = 185, in-use = 0, last-recid= 0)
 
 
 
使用rman備份數據庫的數據文件拷貝損壞記錄項(該項從oracle8開始引入)
770.            ******************************************************************
771.            datafile copy corruption records
772.            ******************************************************************
773.(blkno = 0x57, size = 40, max = 204, in-use = 0, last-recid= 0)
 
 
 
使用rman備份數據庫的刪除記錄(該項從oracle8開始引入)
774.            ******************************************************************
775.            deletion records
776.            ******************************************************************
777.(blkno = 0x58, size = 20, max = 408, in-use = 0, last-recid= 0)
 
 
 
使用rman備份數據庫的代理拷貝記錄項(該項從oracle8i開始引入)
778.            ******************************************************************
779.            proxy copy records
780.            ******************************************************************
781.(blkno = 0x59, size = 852, max = 210, in-use = 0, last-recid= 0)
 
 
 
incarnation records(該項從oracle9i開始引入)
782.            ******************************************************************
783.            incarnation records
784.            ******************************************************************
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.previous resetlogs scn and time scn: 0x0000.04a0b855 04/11/03 09:59:18
 
 
 
794.            *** end of dump ***