Oracle Database Recovery Check Result
Copyright (c) 2012-2013 XIFENFEI. All rights reserved.


Execution Time

CURRENT_DATE
2008-09-12 10:30:51

DB Version

BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Controlfile Information

DBID NAME CREATED OPEN_MODE LOG_MODE CHECKPOINT_CHANGE# CTL_TYP CTL_CREATED CTL_CHANGE# CTL_TIME RESETLOGS_CHANGE# RESETLOGS_TIME
1289035024 ORCL 2011-09-07 19:31:28 MOUNTED NOARCHIVELOG 12043792768793 CURRENT 2011-09-07 19:31:28 12043792768793 2008-09-12 09:17:41 12043792768793 2008-09-12 09:17:41

Non-default Parameter

NAME INSTANCE_NAME VALUE
audit_file_dest orcl E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest orcl E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
compatible orcl 10.2.0.1.0
control_files orcl E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\OR ADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
core_dump_dest orcl E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_block_size orcl 8192
db_domain orcl  
db_file_multiblock_read_count orcl 16
db_name orcl orcl
db_recovery_file_dest orcl E:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size orcl 2147483648
dispatchers orcl (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes orcl 10
open_cursors orcl 300
pga_aggregate_target orcl 203423744
processes orcl 150
remote_login_passwordfile orcl EXCLUSIVE
sga_target orcl 612368384
spfile orcl E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
undo_management orcl MANUAL
undo_tablespace orcl  
user_dump_dest orcl E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP

Tablespace Information

TS# NAME TS_SIZE_G
0 SYSTEM .9375
1 UNDOTBS1 9.130859375
2 SYSAUX .5859375
3 TEMP 3.26953125
4 USERS .8984375
6 EXAMPLE .09765625
7 DATALEMIS 30
8 DATA 10
9 WORKFLOW 1
10 DATAQYB 150
11 SBXX 2.001953125
12 DFJHDATA 2

Datafile Information

TS# FILE# FILE_SIZE_G STATUS ENABLED CREATION_TIME SCN STOP_SCN NAME
0 1 .9375 SYSTEM DISABLED 2005-08-30 13:50:22 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF
1 2 9.130859375 OFFLINE DISABLED 2005-08-30 17:25:44 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF
2 3 .5859375 ONLINE DISABLED 2005-08-30 13:50:49 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF
4 4 .8984375 ONLINE DISABLED 2005-08-30 13:51:05 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
6 5 .09765625 ONLINE DISABLED 2011-09-07 19:32:17 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
7 6 30 ONLINE DISABLED 2011-09-08 17:21:34 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATALEMIS.DBF
8 7 10 ONLINE DISABLED 2011-09-09 12:03:13 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATA.DBF
9 8 1 ONLINE DISABLED 2011-10-18 12:57:27 12043792768793 12043792768793 E:\ORACLE\WORKFLOW.DBF
10 9 30 ONLINE DISABLED 2011-11-04 15:46:51 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAQYB01.DBF
10 10 30 ONLINE DISABLED 2011-11-04 15:46:51 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAQYB02.DBF
10 11 30 ONLINE DISABLED 2011-11-04 16:03:51 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAQYB04.DBF
10 12 30 ONLINE DISABLED 2011-11-04 16:19:47 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAQYB03.DBF
10 13 30 ONLINE DISABLED 2011-11-04 16:37:46 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATAQYB05.DBF
11 14 2.001953125 ONLINE DISABLED 2011-11-10 12:28:47 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SBXX.DBF
12 15 2 ONLINE DISABLED 2012-12-21 11:46:26 12043792768793 12043792768793 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DFJHDATA.DBF

Datafile Header Information

TS# FILE# TABLESPACE_NAME STATUS ERROR FORMAT REC FUZ CREATE_TIME SCN RESETLOGS SCN
0 1 SYSTEM ONLINE   0 NO NO 2005-08-30 13:50:22 12043792768793 12043792768793
1 2 UNDOTBS1 OFFLINE   0 NO NO 2005-08-30 17:25:44 12043792768793 12043792768793
2 3 SYSAUX ONLINE   0 NO NO 2005-08-30 13:50:49 12043792768793 12043792768793
4 4 USERS ONLINE   0 NO NO 2005-08-30 13:51:05 12043792768793 12043792768793
6 5 EXAMPLE ONLINE   0 NO NO 2011-09-07 19:32:17 12043792768793 12043792768793
7 6 DATALEMIS ONLINE   0 NO NO 2011-09-08 17:21:34 12043792768793 12043792768793
8 7 DATA ONLINE   0 NO NO 2011-09-09 12:03:13 12043792768793 12043792768793
9 8 WORKFLOW ONLINE   0 NO NO 2011-10-18 12:57:27 12043792768793 12043792768793
10 9 DATAQYB ONLINE   0 NO NO 2011-11-04 15:46:51 12043792768793 12043792768793
10 10 DATAQYB ONLINE   0 NO NO 2011-11-04 15:46:51 12043792768793 12043792768793
10 11 DATAQYB ONLINE   0 NO NO 2011-11-04 16:03:51 12043792768793 12043792768793
10 12 DATAQYB ONLINE   0 NO NO 2011-11-04 16:19:47 12043792768793 12043792768793
10 13 DATAQYB ONLINE   0 NO NO 2011-11-04 16:37:46 12043792768793 12043792768793
11 14 SBXX ONLINE   0 NO NO 2011-11-10 12:28:47 12043792768793 12043792768793
12 15 DFJHDATA ONLINE   0 NO NO 2012-12-21 11:46:26 12043792768793 12043792768793

FILENUMBER STATUS SCN SEQUENCE
1 8704 12043792768793 1
2 512 12043792768793 1
3 512 12043792768793 1
4 512 12043792768793 1
5 512 12043792768793 1
6 512 12043792768793 1
7 512 12043792768793 1
8 512 12043792768793 1
9 512 12043792768793 1
10 512 12043792768793 1
11 512 12043792768793 1
12 512 12043792768793 1
13 512 12043792768793 1
14 512 12043792768793 1
15 512 12043792768793 1

Redofile Information

THREAD# SEQUENCE# ARC GROUP# SCN STATUS MEMBER
1 1 NO 2 12043792768793 CURRENT E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
1 0 YES 1 0 UNUSED E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
1 0 YES 3 0 UNUSED E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG

V$recover_file Information

Hot Backup Information

FILE# SCN TIME
1 0  
3 0  
4 0  
5 0  
6 0  
7 0  
8 0  
9 0  
10 0  
11 0  
12 0  
13 0  
14 0  
15 0  

Archivelog Information

V$recover_log Information

Rman Information

*******ORACLE PATCH*******