***************************************************************************
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

認識Oracle控制檔案(10g) 2 - final

相關文章