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


Execution Time

CURRENT_DATE
2013-03-19 10:40:10

DB Version

BANNER
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

Controlfile Information

DBID NAME CREATED OPEN_MODE LOG_MODE CHECKPOINT_CHANGE# CTL_TYPE CTL_CREATED CTL_CHANGE# CTL_TIME RESETLOGS_CHANGE# RESETLOGS_TIME
3999170018 TEST01 2013-03-18 18:12:54 MOUNTED NOARCHIVELOG 5965127724871 CREATED 2013-03-18 18:12:54 5965127724871 2013-03-19 10:01:28 5965127724868 2013-03-19 10:01:14

Non-default Parameter

NAME INSTANCE_NAME VALUE
_b_tree_bitmap_plans test01 FALSE
_fast_full_scan_enabled test01 FALSE
_index_join_enabled test01 FALSE
_like_with_bind_as_equality test01 TRUE
_optimizer_autostats_job test01 FALSE
_sort_elimination_cost_ratio test01 5
_sqlexec_progression_cost test01 2147483647
_system_trig_enabled test01 TRUE
_trace_files_public test01 TRUE
aq_tm_processes test01 1
compatible test01 11.1.0
control_files test01 /u01/TEST01/db/apps_st/data/cntrl01.dbf, /u01/TEST01/db/apps_st/data/cntrl02.dbf , /u01/TEST01/db/apps_st/data/cntrl03.dbf
cursor_sharing test01 EXACT
db_block_checking test01 FALSE
db_block_checksum test01 TRUE
db_block_size test01 8192
db_files test01 512
db_name test01 test01
diagnostic_dest test01 /u01/TEST01/db/tech_st/11.1.0/admin/test01_erpdevtest
dml_locks test01 10000
ifile test01 /u01/TEST01/db/tech_st/11.1.0/dbs/test01_erpdevtest_ifile.ora
job_queue_processes test01 2
log_buffer test01 10485760
log_checkpoint_interval test01 100000
log_checkpoint_timeout test01 1200
log_checkpoints_to_alert test01 TRUE
max_dump_file_size test01 20480
nls_comp test01 binary
nls_date_format test01 DD-MON-RR
nls_language test01 american
nls_length_semantics test01 BYTE
nls_numeric_characters test01 .,
nls_sort test01 binary
nls_territory test01 america
olap_page_pool_size test01 4194304
open_cursors test01 600
optimizer_secure_view_merging test01 FALSE
parallel_max_servers test01 8
parallel_min_servers test01 0
pga_aggregate_target test01 1073741824
plsql_code_type test01 INTERPRETED
plsql_native_library_dir test01 /u01/TEST01/db/tech_st/11.1.0/plsql/nativelib
plsql_native_library_subdir_count test01 149
plsql_optimize_level test01 2
processes test01 300
query_rewrite_enabled test01 true
sec_case_sensitive_logon test01 FALSE
session_cached_cursors test01 500
sessions test01 400
sga_target test01 1073741824
shared_pool_reserved_size test01 41943040
shared_pool_size test01 419430400
timed_statistics test01 TRUE
undo_management test01 AUTO
undo_tablespace test01 UNDO_TBS
utl_file_dir test01 /usr/tmp, /usr/tmp, /u01/TEST01/db/tech_st/11.1.0/appsutil/outbound/test01_erpde vtest, /usr/tmp
workarea_size_policy test01 AUTO

Tablespace Information

union all
*
ERROR at line 3:
ORA-00933: SQL command not properly ended
Datafile Information

TS# FILE# FILE_SIZE_G STATUS ENABLED SCN STOP_SCN NAME
0 1 .9765625 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system01.dbf
0 2 .9765625 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system02.dbf
0 3 .9765625 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system03.dbf
0 4 .9765625 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system04.dbf
0 5 .9765625 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system05.dbf
0 13 1.49316406 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system12.dbf
0 288 .638671875 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system10.dbf
0 295 .732421875 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system06.dbf
0 351 .732421875 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system07.dbf
0 352 1.46582031 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system09.dbf
0 353 1.7578125 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system08.dbf
0 354 .680664063 SYSTEM DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/system11.dbf
1 6 .017578125 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/ctxd01.dbf
2 7 .009765625 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/owad01.dbf
307 314 .09765625 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/portal01.dbf
368 379 1.68945313 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/undo01.dbf
381 14 1.703125 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_data04.dbf
381 392 1.23779297 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_data01.dbf
381 401 1.61877441 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_data02.dbf
381 402 1.29199219 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_data03.dbf
382 15 1.07800293 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_ind06.dbf
382 393 1.08789063 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_ind01.dbf
382 403 1.47741699 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_ind02.dbf
382 404 1.05358887 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_ind03.dbf
382 405 1.7578125 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_ind04.dbf
382 406 1.80847168 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_txn_ind05.dbf
383 16 .357421875 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_ref03.dbf
383 394 1.46484375 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_ref01.dbf
383 407 1.14453125 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_ref02.dbf
384 17 .014648438 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_int02.dbf
384 395 1.00195313 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_int01.dbf
385 396 1.11914063 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_summ01.dbf
386 397 .0625 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_nolog01.dbf
387 398 .845703125 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_archive01.dbf
388 8 .48828125 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_queue02.dbf
388 399 .48828125 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_queue01.dbf
389 400 1.41210938 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/a_media01.dbf
390 9 .01171875 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/odm.dbf
391 10 .016601563 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/olap.dbf
392 11 .27355957 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/sysaux01.dbf
392 18 .162109375 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/sysaux02.dbf
393 12 .48828125 ONLINE DISABLED 5965127724871   /u01/TEST01/db/apps_st/data/apps_ts_tools01.dbf

Datafile Header Information

TS# FILE# TABLESPACE_NAME STATUS FUZZY CREATE_TIME SCN RESETLOGS SCN
0 1 SYSTEM ONLINE YES 2000-05-12 14:27:59 5965127724871 5965127724868
0 2 SYSTEM ONLINE YES 2000-05-12 14:28:14 5965127724871 5965127724868
0 3 SYSTEM ONLINE YES 2000-05-12 14:28:28 5965127724871 5965127724868
0 4 SYSTEM ONLINE YES 2000-05-12 14:28:43 5965127724871 5965127724868
0 5 SYSTEM ONLINE YES 2000-05-12 14:28:55 5965127724871 5965127724868
0 13 SYSTEM ONLINE YES 2007-01-05 13:21:04 5965127724871 5965127724868
0 288 SYSTEM ONLINE YES 2003-06-24 04:29:06 5965127724871 5965127724868
0 295 SYSTEM ONLINE YES 2000-12-20 14:22:17 5965127724871 5965127724868
0 351 SYSTEM ONLINE YES 2002-05-30 16:09:52 5965127724871 5965127724868
0 352 SYSTEM ONLINE YES 2002-10-05 10:14:36 5965127724871 5965127724868
0 353 SYSTEM ONLINE YES 2002-10-05 10:15:07 5965127724871 5965127724868
0 354 SYSTEM ONLINE YES 2003-06-24 04:30:37 5965127724871 5965127724868
1 6 CTXD ONLINE YES 2000-05-12 14:29:33 5965127724871 5965127724868
2 7 OWAPUB ONLINE YES 2000-05-12 14:29:34 5965127724871 5965127724868
307 314 PORTAL ONLINE YES 2002-03-20 16:15:43 5965127724871 5965127724868
368 379 APPS_UNDOTS1 ONLINE YES 2003-01-30 10:22:23 5965127724871 5965127724868
381 14 APPS_TS_TX_DATA ONLINE YES 2007-01-05 13:21:24 5965127724871 5965127724868
381 392 APPS_TS_TX_DATA ONLINE YES 2003-11-27 02:29:12 5965127724871 5965127724868
381 401 APPS_TS_TX_DATA ONLINE YES 2003-11-27 02:37:33 5965127724871 5965127724868
381 402 APPS_TS_TX_DATA ONLINE YES 2003-11-27 02:37:56 5965127724871 5965127724868
382 15 APPS_TS_TX_IDX ONLINE YES 2007-01-05 13:21:36 5965127724871 5965127724868
382 393 APPS_TS_TX_IDX ONLINE YES 2003-11-27 02:30:43 5965127724871 5965127724868
382 403 APPS_TS_TX_IDX ONLINE YES 2003-11-27 02:39:26 5965127724871 5965127724868
382 404 APPS_TS_TX_IDX ONLINE YES 2003-11-27 02:40:57 5965127724871 5965127724868
382 405 APPS_TS_TX_IDX ONLINE YES 2003-11-27 02:42:28 5965127724871 5965127724868
382 406 APPS_TS_TX_IDX ONLINE YES 2003-11-27 02:43:32 5965127724871 5965127724868
383 16 APPS_TS_SEED ONLINE YES 2007-01-05 13:22:12 5965127724871 5965127724868
383 394 APPS_TS_SEED ONLINE YES 2003-11-27 02:32:14 5965127724871 5965127724868
383 407 APPS_TS_SEED ONLINE YES 2003-11-27 02:44:35 5965127724871 5965127724868
384 17 APPS_TS_INTERFACE ONLINE YES 2007-01-05 13:22:29 5965127724871 5965127724868
384 395 APPS_TS_INTERFACE ONLINE YES 2003-11-27 02:32:47 5965127724871 5965127724868
385 396 APPS_TS_SUMMARY ONLINE YES 2003-11-27 02:33:33 5965127724871 5965127724868
386 397 APPS_TS_NOLOGGING ONLINE YES 2003-11-27 02:33:38 5965127724871 5965127724868
387 398 APPS_TS_ARCHIVE ONLINE YES 2003-11-27 02:34:23 5965127724871 5965127724868
388 8 APPS_TS_QUEUES ONLINE YES 2004-02-21 16:16:01 5965127724871 5965127724868
388 399 APPS_TS_QUEUES ONLINE YES 2003-11-27 02:34:29 5965127724871 5965127724868
389 400 APPS_TS_MEDIA ONLINE YES 2003-11-27 02:36:01 5965127724871 5965127724868
390 9 ODM ONLINE YES 2004-03-21 09:32:59 5965127724871 5965127724868
391 10 OLAP ONLINE YES 2004-03-21 09:33:20 5965127724871 5965127724868
392 11 SYSAUX ONLINE YES 2005-12-05 02:20:53 5965127724871 5965127724868
392 18 SYSAUX ONLINE YES 2007-01-05 13:22:46 5965127724871 5965127724868
393 12 APPS_TS_TOOLS ONLINE YES 2005-12-05 18:14:25 5965127724871 5965127724868

FILENUMBER STATUS SCN SEQUENCE
1 8196 5965127724871 1
2 4 5965127724871 1
3 4 5965127724871 1
4 4 5965127724871 1
5 4 5965127724871 1
6 4 5965127724871 1
7 4 5965127724871 1
8 4 5965127724871 1
9 4 5965127724871 1
10 4 5965127724871 1
11 4 5965127724871 1
12 4 5965127724871 1
13 4 5965127724871 1
14 4 5965127724871 1
15 4 5965127724871 1
16 4 5965127724871 1
17 4 5965127724871 1
18 4 5965127724871 1
288 4 5965127724871 1
295 4 5965127724871 1
314 4 5965127724871 1
351 4 5965127724871 1
352 4 5965127724871 1
353 4 5965127724871 1
354 4 5965127724871 1
379 4 5965127724871 1
392 4 5965127724871 1
393 4 5965127724871 1
394 4 5965127724871 1
395 4 5965127724871 1
396 4 5965127724871 1
397 4 5965127724871 1
398 4 5965127724871 1
399 4 5965127724871 1
400 4 5965127724871 1
401 4 5965127724871 1
402 4 5965127724871 1
403 4 5965127724871 1
404 4 5965127724871 1
405 4 5965127724871 1
406 4 5965127724871 1
407 4 5965127724871 1

Redofile Information

THREAD# SEQUENCE# GROUP# SCN STATUS MEMBER
1 1 1 5965127724868 CURRENT /u01/TEST01/db/apps_st/data/log01a.dbf
1 1 1 5965127724868 CURRENT /u01/TEST01/db/apps_st/data/log01b.dbf
1 0 2 0 UNUSED /u01/TEST01/db/apps_st/data/log02a.dbf
1 0 2 0 UNUSED /u01/TEST01/db/apps_st/data/log02b.dbf

V$recover_file Information

Hot Backup Information

FILE# SCN TIME
1 0  
2 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  
16 0  
17 0  
18 0  
288 0  
295 0  
314 0  
351 0  
352 0  
353 0  
354 0  
379 0  
392 0  
393 0  
394 0  
395 0  
396 0  
397 0  
398 0  
399 0  
400 0  
401 0  
402 0  
403 0  
404 0  
405 0  
406 0  
407 0  

Archivelog Information

V$recover_log Information

Rman Information