ITPub博客

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

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

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


***************************************************************************
TEMP FILE RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 100, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 89, numrecs = 100)
 
 
 
***************************************************************************
TABLESPACE RECORDS
***************************************************************************
 (size = 68, compat size = 68, section max = 100, section in-use = 5,
  last-recid= 1, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 88, numrecs = 100)
TABLESPACE #0 SYSTEM: recno=1
 First datafile link=1  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #1 UNDOTBS1: recno=2
 First datafile link=2  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #2 SYSAUX: recno=3
 First datafile link=3  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #4 USERS: recno=4
 First datafile link=4  Tablespace Flag=0
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
TABLESPACE #3 TEMP: recno=5
 First datafile link=0  Tablespace Flag=1
 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00
 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00
 
 
 
***************************************************************************
RMAN CONFIGURATION RECORDS    RMAN 配置记录 
***************************************************************************
 (size = 1108, compat size = 1108, section max = 50, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 90, numrecs = 50)
 
 
 
***************************************************************************
FLASHBACK LOGFILE RECORDS      闪回日志记录 
***************************************************************************
 (size = 84, compat size = 84, section max = 2048, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 149, numrecs = 2048)
 
 
 
***************************************************************************
THREAD INSTANCE MAPPING RECORDS
***************************************************************************
 (size = 80, compat size = 80, section max = 8, section in-use = 8,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 166, numrecs = 8)
test01 recno=1
UNNAMED_INSTANCE_2 recno=2
UNNAMED_INSTANCE_3 recno=3
UNNAMED_INSTANCE_4 recno=4
UNNAMED_INSTANCE_5 recno=5
UNNAMED_INSTANCE_6 recno=6
UNNAMED_INSTANCE_7 recno=7
UNNAMED_INSTANCE_8 recno=8
 
 
 
 
***************************************************************************
MTTR RECORDS
***************************************************************************
 (size = 100, compat size = 100, section max = 8, section in-use = 1,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 167, numrecs = 8)
MTTR record for thread 1
MTTR statistics status: 1
Init time: Avg: 61418885 us, Times measured: 4
File open time: Avg: 157673 us, Times measured: 13
Log block read time: Avg: 20 us, Times measured: 65536
Data block read/claim time: Avg: 170 us, Times measured: 1000
Data block write time: Avg: 390 us
1000 change vector apply time: Avg: 0 us, Times measured: 1
Ratio Information:
# of log blocks measured: 156064
# of data blocks measured: 8289
# of change vectors measured: 529360
 
 
 
 
***************************************************************************
STANDBY DATABASE MAP RECORDS
***************************************************************************
 (size = 400, compat size = 400, section max = 10, section in-use = 10,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 170, numrecs = 10)
 
 
 
 
***************************************************************************
RESTORE POINT RECORDS
***************************************************************************
 (size = 212, compat size = 212, section max = 2048, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 171, numrecs = 2048)
 
 
 
 
***************************************************************************
LOG FILE HISTORY RECORDS
***************************************************************************
 (size = 56, compat size = 56, section max = 292, section in-use = 6,
  last-recid= 6, old-recno = 1, last-recno = 6)
 (extent = 1, blkno = 94, numrecs = 292)
Earliest record:
 RECID #1 Recno 1 Record timestamp  04/28/11 11:32:27 Thread=1 Seq#=4 Link-Recid=0 kccic-Recid=1
  Low scn: 0x0000.000e43da 04/28/11 11:27:15 Next scn: 0x0000.000e4549
Latest record:
 RECID #6 Recno 6 Record timestamp  05/16/11 07:37:22 Thread=1 Seq#=9 Link-Recid=5 kccic-Recid=1
  Low scn: 0x0000.00107564 05/13/11 07:48:16 Next scn: 0x0000.001115f2
 RECID #5 Recno 5 Record timestamp  05/13/11 07:48:16 Thread=1 Seq#=8 Link-Recid=4 kccic-Recid=1
  Low scn: 0x0000.000feccc 05/12/11 07:55:39 Next scn: 0x0000.00107564
 RECID #4 Recno 4 Record timestamp  05/12/11 07:55:39 Thread=1 Seq#=7 Link-Recid=3 kccic-Recid=1
  Low scn: 0x0000.000f340f 05/03/11 07:32:37 Next scn: 0x0000.000feccc
 RECID #3 Recno 3 Record timestamp  05/03/11 07:32:37 Thread=1 Seq#=6 Link-Recid=2 kccic-Recid=1
  Low scn: 0x0000.000ee550 05/01/11 09:15:30 Next scn: 0x0000.000f340f
 RECID #2 Recno 2 Record timestamp  05/01/11 09:15:30 Thread=1 Seq#=5 Link-Recid=1 kccic-Recid=1
  Low scn: 0x0000.000e4549 04/28/11 11:32:27 Next scn: 0x0000.000ee550
 RECID #1 Recno 1 Record timestamp  04/28/11 11:32:27 Thread=1 Seq#=4 Link-Recid=0 kccic-Recid=1
  Low scn: 0x0000.000e43da 04/28/11 11:27:15 Next scn: 0x0000.000e4549
 
 
 
 
***************************************************************************
OFFLINE RANGE RECORDS    offline范围记录 
***************************************************************************
 (size = 200, compat size = 200, section max = 163, section in-use = 0,
  last-recid= 0, old-recno = 0, last-recno = 0)
 (extent = 1, blkno = 95, numrecs = 163)
 
 
 
 
***************************************************************************
ARCHIVED LOG RECORDS     归档日志记录 
***************************************************************************
 (size = 584, compat size = 584, section max = 308, section in-use = 8,
  last-recid= 8, old-recno = 1, last-recno = 8)
 (extent = 1, blkno = 97, numrecs = 308)
Earliest record:
 RECID #1 Recno 1 Record timestamp  04/28/11 11:32:27 Thread=1 Seq#=2
  Flags:
  Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
  filename D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\ARCH\ARC00002_0749566275.001
  Low scn: 0x0000.000dd213 04/27/11 13:34:57 Next scn: 0x0000.000e3fe8 04/28/11 11:22:34
  Block count=10226  Blocksize=512
Latest record:
 RECID #8 Recno 8 Record timestamp  05/16/11 07:37:32 Thread=1 Seq#=9
  Flags:
  Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
  filename D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\ARCH\ARC00009_0749566275.001
  Low scn: 0x0000.00107564 05/13/11 07:48:16 Next scn: 0x0000.001115f2 05/16/11 07:37:21
  Block count=26165  Blocksize=512
 RECID #7 Recno 7 Record timestamp  05/13/11 07:48:20 Thread=1 Seq#=8
  Flags:
  Resetlogs scn and time scn: 0x0000.000dc98f 04/27/11 12:51:15
  filename D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\ARCH\ARC00008_0749566275.001
  Low scn: 0x0000.000feccc 05/12/11 07:55:39 Next scn: 0x0000.00107564 05/13/11 07:48:16
  Block count=19136  Blocksize=512
........ 
 
 
 
 

 


备注: 以下内容是在做RMAN备份后重新dump出的控制文件的下半部分。请注意。

 

***************************************************************************
BACKUP SET RECORDS
***************************************************************************
 (size = 40, compat size = 40, section max = 409, section in-use = 6,
  last-recid= 6, old-recno = 1, last-recno = 6)
 (extent = 1, blkno = 108, numrecs = 409)
Earliest record:
 RECID #1 Recno 1 Record timestamp  05/18/11 11:17:54
  Backup set key: stamp=751461430, count=1
  Backup status:
  Backup contains:
  Backup set is NOT part of the incremental strategy
  Blocksize=8192 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
Latest record:
 RECID #6 Recno 6 Record timestamp  05/18/11 11:40:22
  Backup set key: stamp=751462820, count=6
  Backup status:
  Backup contains:
  Backup set is NOT part of the incremental strategy
  Blocksize=512 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
 RECID #5 Recno 5 Record timestamp  05/18/11 11:40:20
  Backup set key: stamp=751462817, count=5
  Backup status:
  Backup contains:
  Backup set is NOT part of the incremental strategy
  Blocksize=16384 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
 RECID #4 Recno 4 Record timestamp  05/18/11 11:40:15
  Backup set key: stamp=751462772, count=4
  Backup status:
  Backup contains:
  Backup set is NOT part of the incremental strategy
  Blocksize=8192 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
 RECID #3 Recno 3 Record timestamp  05/18/11 11:39:24
  Backup set key: stamp=751462755, count=3
  Backup status:
  Backup contains:
  Backup set is NOT part of the incremental strategy
  Blocksize=512 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
 RECID #2 Recno 2 Record timestamp  05/18/11 11:17:58
  Backup set key: stamp=751461475, count=2
  Backup status:
  Backup contains:
  Backup set is NOT part of the incremental strategy
  Blocksize=16384 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
 RECID #1 Recno 1 Record timestamp  05/18/11 11:17:54
  Backup set key: stamp=751461430, count=1
  Backup status:
  Backup contains:
  Backup set is NOT part of the incremental strategy
  Blocksize=8192 Piece-Count=1 Level=0 Time:
  Backup does not have keep options.
 
 
 
 
***************************************************************************
BACKUP PIECE RECORDS
***************************************************************************
 (size = 736, compat size = 736, section max = 200, section in-use = 6,
  last-recid= 6, old-recno = 1, last-recno = 6)
 (extent = 1, blkno = 109, numrecs = 200)
Earliest record:
 RECID #1 Recno 1 Record timestamp  05/18/11 11:17:10 piece #1  copy #1 pool 0
  Backup set key: stamp=751461430, count=1
  V$RMAN_STATUS: recid=137870616, stamp=137870612
  Flags:
  Device: DISK
  Handle: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST01\BACKUPSET\2011_05_18

\O1_MF_NNNDF_TAG20110518T111709_6X6GKPK2_.BKP
  Media-Handle:
  Comment:
  Tag: TAG20110518T111709
  Completion time  05/18/11 11:17:54
Latest record:
 RECID #6 Recno 6 Record timestamp  05/18/11 11:40:21 piece #1  copy #1 pool 0
  Backup set key: stamp=751462820, count=6
  V$RMAN_STATUS: recid=137870616, stamp=137870612
  Flags:
  Device: DISK
  Handle: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST01\BACKUPSET\2011_05_18

\O1_MF_ANNNN_TAG20110518T114020_6X6HX600_.BKP
  Media-Handle:
  Comment:
  Tag: TAG20110518T114020
  Completion time  05/18/11 11:40:22
 RECID #5 Recno 5 Record timestamp  05/18/11 11:40:19 piece #1  copy #1 pool 0
  Backup set key: stamp=751462817, count=5
  V$RMAN_STATUS: recid=137870616, stamp=137870612
  Flags:
  Device: DISK
  Handle: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST01\BACKUPSET\2011_05_18

\O1_MF_NCSNF_TAG20110518T113932_6X6HX389_.BKP
  Media-Handle:
  Comment:
  Tag: TAG20110518T113932
  Completion time  05/18/11 11:40:20
 RECID #4 Recno 4 Record timestamp  05/18/11 11:39:32 piece #1  copy #1 pool 0
  Backup set key: stamp=751462772, count=4
  V$RMAN_STATUS: recid=137870616, stamp=137870612
  Flags:
  Device: DISK
  Handle: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST01\BACKUPSET\2011_05_18

\O1_MF_NNNDF_TAG20110518T113932_6X6HVNH4_.BKP
  Media-Handle:
  Comment:
  Tag: TAG20110518T113932
  Completion time  05/18/11 11:40:15
 RECID #3 Recno 3 Record timestamp  05/18/11 11:39:16 piece #1  copy #1 pool 0
  Backup set key: stamp=751462755, count=3
  V$RMAN_STATUS: recid=137870616, stamp=137870612
  Flags:
  Device: DISK
  Handle: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST01\BACKUPSET\2011_05_18

\O1_MF_ANNNN_TAG20110518T113914_6X6HV4VC_.BKP
  Media-Handle:
  Comment:
  Tag: TAG20110518T113914
  Completion time  05/18/11 11:39:24
 RECID #2 Recno 2 Record timestamp  05/18/11 11:17:57 piece #1  copy #1 pool 0
  Backup set key: stamp=751461475, count=2
  V$RMAN_STATUS: recid=137870616, stamp=137870612
  Flags:
  Device: DISK
  Handle: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST01\BACKUPSET\2011_05_18

\O1_MF_NCSNF_TAG20110518T111709_6X6GM5X9_.BKP
  Media-Handle:
  Comment:
  Tag: TAG20110518T111709
  Completion time  05/18/11 11:17:58
 RECID #1 Recno 1 Record timestamp  05/18/11 11:17:10 piece #1  copy #1 pool 0
  Backup set key: stamp=751461430, count=1
  V$RMAN_STATUS: recid=137870616, stamp=137870612
  Flags:
  Device: DISK
  Handle: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST01\BACKUPSET\2011_05_18

\O1_MF_NNNDF_TAG20110518T111709_6X6GKPK2_.BKP
  Media-Handle:
  Comment:
  Tag: TAG20110518T111709
  Completion time  05/18/11 11:17:54
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-695670/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13778402