認識Oracle控制檔案(10g) 3 - final
***************************************************************************
BACKUP DATAFILE RECORDS
***************************************************************************
(size = 116, compat size = 116, section max = 282, section in-use = 10,
last-recid= 10, old-recno = 1, last-recno = 10)
(extent = 1, blkno = 118, numrecs = 282)
Earliest record:
RECID #1 Recno 1 Record timestamp 05/18/11 11:17:54 File=1 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751461430, count=1
Creation checkpointed at scn: 0x0000.00000009 08/30/05 13:50:22
File header checkpointed at scn: 0x0000.0011da77 05/18/11 11:17:10
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 45497
File size at backup time 61440 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 61440
Latest record:
RECID #10 Recno 10 Record timestamp 05/18/11 11:40:20 File=0 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751462817, count=5
Creation checkpointed at scn: 0x0000.00000000 04/28/11 11:29:07
File header checkpointed at scn: 0x0000.0011dd98 05/18/11 11:40:16
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 450
File size at backup time 450 Block size 16384
Low Offline Range Recid 0
Number of blocks read during backup 450
RECID #9 Recno 9 Record timestamp 05/18/11 11:39:34 File=4 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751462772, count=4
Creation checkpointed at scn: 0x0000.00002629 08/30/05 13:51:05
File header checkpointed at scn: 0x0000.0011dd83 05/18/11 11:39:32
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 51
File size at backup time 640 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 640
RECID #8 Recno 8 Record timestamp 05/18/11 11:39:37 File=2 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751462772, count=4
Creation checkpointed at scn: 0x0000.00081f74 08/30/05 17:25:44
File header checkpointed at scn: 0x0000.0011dd83 05/18/11 11:39:32
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 2825
File size at backup time 3200 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 3200
RECID #7 Recno 7 Record timestamp 05/18/11 11:40:05 File=3 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751462772, count=4
Creation checkpointed at scn: 0x0000.000017d4 08/30/05 13:50:49
File header checkpointed at scn: 0x0000.0011dd83 05/18/11 11:39:32
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 23723
File size at backup time 35840 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 35840
RECID #6 Recno 6 Record timestamp 05/18/11 11:40:15 File=1 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751462772, count=4
Creation checkpointed at scn: 0x0000.00000009 08/30/05 13:50:22
File header checkpointed at scn: 0x0000.0011dd83 05/18/11 11:39:32
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 45497
File size at backup time 61440 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 61440
RECID #5 Recno 5 Record timestamp 05/18/11 11:17:58 File=0 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751461475, count=2
Creation checkpointed at scn: 0x0000.00000000 04/28/11 11:29:07
File header checkpointed at scn: 0x0000.0011da8b 05/18/11 11:17:54
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 450
File size at backup time 450 Block size 16384
Low Offline Range Recid 0
Number of blocks read during backup 450
RECID #4 Recno 4 Record timestamp 05/18/11 11:17:12 File=4 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751461430, count=1
Creation checkpointed at scn: 0x0000.00002629 08/30/05 13:51:05
File header checkpointed at scn: 0x0000.0011da77 05/18/11 11:17:10
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 51
File size at backup time 640 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 640
RECID #3 Recno 3 Record timestamp 05/18/11 11:17:15 File=2 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751461430, count=1
Creation checkpointed at scn: 0x0000.00081f74 08/30/05 17:25:44
File header checkpointed at scn: 0x0000.0011da77 05/18/11 11:17:10
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 2825
File size at backup time 3200 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 3200
RECID #2 Recno 2 Record timestamp 05/18/11 11:17:41 File=3 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751461430, count=1
Creation checkpointed at scn: 0x0000.000017d4 08/30/05 13:50:49
File header checkpointed at scn: 0x0000.0011da77 05/18/11 11:17:10
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 23723
File size at backup time 35840 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 35840
RECID #1 Recno 1 Record timestamp 05/18/11 11:17:54 File=1 Incremental backup level=0
File is NOT part of the incremental strategy
Backup set key: stamp=751461430, count=1
Creation checkpointed at scn: 0x0000.00000009 08/30/05 13:50:22
File header checkpointed at scn: 0x0000.0011da77 05/18/11 11:17:10
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Incremental Change scn: 0x0000.00000000
Absolute Fuzzy scn: 0x0000.00000000
Newly-marked media corrupt blocks 0 Total media corrupt blocks 0
Total logically corrupt blocks 0 Block images written to backup 45497
File size at backup time 61440 Block size 8192
Low Offline Range Recid 0
Number of blocks read during backup 61440
***************************************************************************
BACKUP LOG RECORDS
***************************************************************************
(size = 76, compat size = 76, section max = 215, section in-use = 11,
last-recid= 11, old-recno = 1, last-recno = 11)
(extent = 1, blkno = 120, numrecs = 215)
Earliest record:
RECID #1 Recno 1 Record timestamp 05/18/11 11:39:24 Thread=1 Seq#=7
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.000f340f 05/03/11 07:32:37 Next scn: 0x0000.000feccc 05/12/11 07:55:39
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=82666 Blocksize=512
Latest record:
RECID #11 Recno 11 Record timestamp 05/18/11 11:40:22 Thread=1 Seq#=12
Backup set key: stamp=751462820, count=6
Lowscn: 0x0000.0011dd78 05/18/11 11:39:12 Next scn: 0x0000.0011dd9c 05/18/11 11:40:20
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=28 Blocksize=512
RECID #10 Recno 10 Record timestamp 05/18/11 11:39:18 Thread=1 Seq#=6
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.000ee550 05/01/11 09:15:30 Next scn: 0x0000.000f340f 05/03/11 07:32:37
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=56 Blocksize=512
RECID #9 Recno 9 Record timestamp 05/18/11 11:39:18 Thread=1 Seq#=3
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.000e3fe8 04/28/11 11:22:34 Next scn: 0x0000.000e43da 04/28/11 11:27:15
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=201 Blocksize=512
RECID #8 Recno 8 Record timestamp 05/18/11 11:39:17 Thread=1 Seq#=4
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.000e43da 04/28/11 11:27:15 Next scn: 0x0000.000e4549 04/28/11 11:32:27
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=546 Blocksize=512
RECID #7 Recno 7 Record timestamp 05/18/11 11:39:20 Thread=1 Seq#=2
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.000dd213 04/27/11 13:34:57 Next scn: 0x0000.000e3fe8 04/28/11 11:22:34
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=10226 Blocksize=512
RECID #6 Recno 6 Record timestamp 05/18/11 11:39:20 Thread=1 Seq#=11
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.0011bafc 05/18/11 07:33:19 Next scn: 0x0000.0011dd78 05/18/11 11:39:12
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=10627 Blocksize=512
RECID #5 Recno 5 Record timestamp 05/18/11 11:39:21 Thread=1 Seq#=8
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.000feccc 05/12/11 07:55:39 Next scn: 0x0000.00107564 05/13/11 07:48:16
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=19136 Blocksize=512
RECID #4 Recno 4 Record timestamp 05/18/11 11:39:22 Thread=1 Seq#=9
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.00107564 05/13/11 07:48:16 Next scn: 0x0000.001115f2 05/16/11 07:37:21
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=26165 Blocksize=512
RECID #3 Recno 3 Record timestamp 05/18/11 11:39:22 Thread=1 Seq#=10
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.001115f2 05/16/11 07:37:21 Next scn: 0x0000.0011bafc 05/18/11 07:33:19
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=28360 Blocksize=512
RECID #2 Recno 2 Record timestamp 05/18/11 11:39:22 Thread=1 Seq#=5
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.000e4549 04/28/11 11:32:27 Next scn: 0x0000.000ee550 05/01/11 09:15:30
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=32901 Blocksize=512
RECID #1 Recno 1 Record timestamp 05/18/11 11:39:24 Thread=1 Seq#=7
Backup set key: stamp=751462755, count=3
Lowscn: 0x0000.000f340f 05/03/11 07:32:37 Next scn: 0x0000.000feccc 05/12/11 07:55:39
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Block count=82666 Blocksize=512
***************************************************************************
DATAFILE COPY RECORDS
***************************************************************************
(size = 660, compat size = 660, section max = 223, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 121, numrecs = 223)
***************************************************************************
BACKUP DATAFILE CORRUPTION RECORDS
***************************************************************************
(size = 44, compat size = 44, section max = 371, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 130, numrecs = 371)
***************************************************************************
DATAFILE COPY CORRUPTION RECORDS
***************************************************************************
(size = 40, compat size = 40, section max = 409, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 131, numrecs = 409)
***************************************************************************
DELETION RECORDS
***************************************************************************
(size = 20, compat size = 20, section max = 818, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 132, numrecs = 818)
***************************************************************************
PROXY COPY RECORDS
***************************************************************************
(size = 852, compat size = 852, section max = 249, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 133, numrecs = 249)
***************************************************************************
INCARNATION RECORDS
***************************************************************************
(size = 56, compat size = 56, section max = 292, section in-use = 1,
last-recid= 1, old-recno = 1, last-recno = 1)
(extent = 1, blkno = 148, numrecs = 292)
Earliest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Previous Resetlogs scn and time scn: 0x0000.000d18da 04/26/11 13:35:12
Incarnation (parent inc#, flag)=(0, 2)
Latest record:
RECID #1 Recno 1 Record timestamp
Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
Previous Resetlogs scn and time scn: 0x0000.000d18da 04/26/11 13:35:12
Incarnation (parent inc#, flag)=(0, 2)
***************************************************************************
RMAN STATUS RECORDS
***************************************************************************
(size = 116, compat size = 116, section max = 141, section in-use = 6,
last-recid= 6, old-recno = 1, last-recno = 6)
(extent = 1, blkno = 165, numrecs = 141)
Earliest record:
RECID #1 Recno 1
Internal Status: 34
External Status: 2
Command id: 2011-05-18T11:16:45
Operation: RMAN
Start and End time 05/18/11 11:16:46 05/18/11 11:24:52
Latest record:
RECID #6 Recno 6
Internal Status: 6
External Status: 2
Command id: 2011-05-18T11:38:59
Operation: backup
Start and End time 05/18/11 11:40:20 05/18/11 11:40:23
RECID #5 Recno 5
Internal Status: 6
External Status: 2
Command id: 2011-05-18T11:38:59
Operation: backup
Start and End time 05/18/11 11:39:31 05/18/11 11:40:20
RECID #4 Recno 4
Internal Status: 6
External Status: 2
Command id: 2011-05-18T11:38:59
Operation: backup
Start and End time 05/18/11 11:39:12 05/18/11 11:39:31
RECID #3 Recno 3
Internal Status: 34
External Status: 2
Command id: 2011-05-18T11:38:59
Operation: RMAN
Start and End time 05/18/11 11:39:00 05/18/11 11:40:29
RECID #2 Recno 2
Internal Status: 6
External Status: 2
Command id: 2011-05-18T11:16:45
Operation: backup
Start and End time 05/18/11 11:17:08 05/18/11 11:18:02
RECID #1 Recno 1
Internal Status: 34
External Status: 2
Command id: 2011-05-18T11:16:45
Operation: RMAN
Start and End time 05/18/11 11:16:46 05/18/11 11:24:52
***************************************************************************
DATAFILE HISTORY RECORDS
***************************************************************************
(size = 568, compat size = 568, section max = 57, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 168, numrecs = 57)
***************************************************************************
NORMAL RESTORE POINT RECORDS
***************************************************************************
(size = 212, compat size = 212, section max = 2083, section in-use = 0,
last-recid= 0, old-recno = 0, last-recno = 0)
(extent = 1, blkno = 198, numrecs = 2083)
*** END OF DUMP ***
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-695671/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 認識Oracle控制檔案(10g) - finalOracle
- 認識Oracle控制檔案(10g) 2 - finalOracle
- 【RAC】Oracle 10g RAC 重建控制檔案Oracle 10g
- 認識Oracle DBFS檔案系統Oracle
- oracle實驗記錄 (oracle 10G dataguard(3)檔案管理)Oracle
- Oracle 控制檔案Oracle
- 重新認識口令檔案
- Oracle重建控制檔案Oracle
- ORACLE 新增控制檔案Oracle
- ORACLE控制檔案管理Oracle
- oracle 重建控制檔案Oracle
- Final Cut Pro中文新手教程 (3) 預覽視窗的認識
- Oracle 控制檔案的重建Oracle
- Oracle控制檔案基礎Oracle
- oracle 關於--控制檔案Oracle
- 增加oracle的控制檔案Oracle
- oracle sqlldr控制檔案模板OracleSQL
- Oracle 控制檔案內容Oracle
- 【ORACLE CONCEPT】控制檔案Oracle
- Oracle OS 認證, 口令檔案Oracle
- 認識 Linux 檔案屬性及檔案配置(轉)Linux
- oracle 10g 以上 遍歷檔案Oracle 10g
- 使用Oracle 10g複製檔案Oracle 10g
- oracle實驗記錄 (恢復-關於控制檔案(3))Oracle
- Final Cut Pro中文新手教程 (1) 基礎認識Final Cut Pro
- oracle控制檔案及引數檔案問題Oracle
- Oracle 控制檔案(CONTROLFILE)Oracle
- 關於oracle的控制檔案Oracle
- ORACLE控制檔案的重建 (轉)Oracle
- 認識mysql(3)MySql
- 【控制檔案】映象控制檔案
- Oracle 10g大檔案表空間Oracle 10g
- oracle中移動控制檔案、資料檔案、日誌檔案Oracle
- VM配置檔案Setting,GridFTP認識FTP
- cloudflare認識1(上傳檔案到桶)Cloud
- Oracle OS認證與口令檔案認證詳解Oracle
- oracle 11g 新增控制檔案Oracle
- oracle控制檔案轉儲說明Oracle