ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 认识Oracle控制文件(10g) 3 - final

认识Oracle控制文件(10g) 3 - final

原创 Linux操作系统 作者:tolywang 时间:2011-05-18 14:41:59 0 删除 编辑

***************************************************************************
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 , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13472922