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


Execution Time

CURRENT_DATE
2015-03-04 18:24:00

DB Version

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

Instance Information

INSTANCE_NUMBER INSTANCE_NAME HOST_NAME STATUS STARTUP_TIME THREAD#
1 oa localhost.localdomain MOUNTED 2015-03-04 18:23:13 1

Controlfile Information

DBID NAME OPEN_MODE CREATED OPEN_MODE LOG_MODE CHECKPOINT_CHANGE# CTL_TYP CTL_CREATED CTL_CHANGE# CTL_TIME RESETLOGS_CHANGE# RESETLOGS_TIME
3278685018 OA MOUNTED 2014-10-10 18:46:50 MOUNTED NOARCHIVELOG 13287068 CURRENT 2014-10-10 18:46:50 13287068 2015-03-03 13:42:06 12986990 2015-03-03 11:18:13

SCN Information

TIM SCN HEADROOM ADJUST_SCN ALL_SCN
2015-03-04 18:24:00 13287068 10109.8 13328.3 13328.3

Non-default Parameter

NAME INSTANCE_NAME VALUE
_allow_resetlogs_corruption oa TRUE
audit_file_dest oa /u01/app/oracle/admin/oa/adump
audit_trail oa DB
compatible oa 11.2.0.0.0
control_files oa /u01/app/oracle/oradata/oa/control01.ctl, /u01/app/oracle/flash_recovery_area/oa /control02.ctl
db_block_size oa 8192
db_domain oa  
db_name oa oa
db_recovery_file_dest oa /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size oa 4070572032
diagnostic_dest oa /u01/app/oracle
dispatchers oa (PROTOCOL=TCP) (SERVICE=oaXDB)
memory_target oa 27111981056
open_cursors oa 300
processes oa 150
remote_login_passwordfile oa EXCLUSIVE
undo_tablespace oa SYSTEM

Tablespace Information

TS# NAME TS_SIZE_G
0 SYSTEM .732421875
1 SYSAUX .771484375
2 UNDOTBS1 .15625
3 TEMP .0771484375
4 USERS .101318359375

Datafile Information

TS# FILE# FILE_SIZE_G STATUS ENABLED CREATION_TIME SCN STOP_SCN OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TIME NAME
0 1 .732421875 SYSTEM DISABLED 2009-08-15 00:16:48 13287068   12986989 12986990 2015-03-03 11:18:13 /u01/app/oracle/oradata/oa/system01.dbf
1 2 .771484375 ONLINE DISABLED 2009-08-15 00:17:00 13287068   12986989 12986990 2015-03-03 11:18:13 /u01/app/oracle/oradata/oa/sysaux01.dbf
2 3 .15625 RECOVER DISABLED 2009-08-15 00:52:15 13027003 13047008 12986989 12986990 2015-03-03 11:18:13 /u01/app/oracle/oradata/oa/undotbs01.dbf
4 4 .101318359375 ONLINE DISABLED 2009-08-15 00:17:30 13287068   12986989 12986990 2015-03-03 11:18:13 /u01/app/oracle/oradata/oa/users01.dbf

STATUS CHECKPOINT_CHANGE# CHECKPOINT_TIME ROW_NUM
ONLINE 13287068 2015-03-03 13:42:06 2
RECOVER 13027003 2015-03-03 11:20:36 1
SYSTEM 13287068 2015-03-03 13:42:06 1

Datafile Header Information

TS# FILE# FILE_SIZE_G TABLESPACE_NAME STATUS ERROR FORMAT REC FUZ CREATE_TIME CHECKPOINT_CHANGE RESETLOGS_CHANGE RESETLOGS_TIME
0 1 .732421875 SYSTEM ONLINE   10 NO YES 2009-08-15 00:16:48 13287068 12986990 2015-03-03 11:18:13
1 2 .771484375 SYSAUX ONLINE   10 NO YES 2009-08-15 00:17:00 13287068 12986990 2015-03-03 11:18:13
2 3 .15625 UNDOTBS1 OFFLINE   10 YES YES 2009-08-15 00:52:15 13027003 12986990 2015-03-03 11:18:13
4 4 .101318359375 USERS ONLINE   10 NO YES 2009-08-15 00:17:30 13287068 12986990 2015-03-03 11:18:13

STATUS CHECKPOINT_CHANGE# CHECKPOINT_TIME ROW_NUM
OFFLINE 13027003 2015-03-03 11:20:36 1
ONLINE 13287068 2015-03-03 13:42:06 3

FILE# NAME STATUS DFILE_CHKP_CHANGE DFILE_HED_CHKP_CHANGE REC FUZ
1 /u01/app/oracle/oradata/oa/system01.dbf SYSTEM 13287068 13287068 NO YES
2 /u01/app/oracle/oradata/oa/sysaux01.dbf ONLINE 13287068 13287068 NO YES
3 /u01/app/oracle/oradata/oa/undotbs01.dbf RECOVER 13027003 13027003 YES YES
4 /u01/app/oracle/oradata/oa/users01.dbf ONLINE 13287068 13287068 NO YES

x$kcvfh Information

TS# FILE# RFILE# F_STATU F_ERROR STAUTUS FUZ CRT_SCN CRT_TIME CPT_SCN CPT_TIME RESETLOGS_SCN THREAD# SEQUENCE#
0 1 1 ONLINE   8196 YES 7 08/15/2009 00:16:48 13287068 03/03/2015 13:42:06 12986990 1 16
1 2 2 ONLINE   4 YES 2140 08/15/2009 00:17:00 13287068 03/03/2015 13:42:06 12986990 1 16
2 3 3 OFFLINE   4 YES 942603 08/15/2009 00:52:15 13027003 03/03/2015 11:20:36 12986990 1 3
4 4 4 ONLINE   4 YES 17993 08/15/2009 00:17:30 13287068 03/03/2015 13:42:06 12986990 1 16

THREAD SEQUENCE SCN STATUS ROW_NUM
1 3 13027003 4 1
1 16 13287068 4 2
1 16 13287068 8196 1

Minimum PITR SCN
0

Redofile Information

THREAD# GROUP# SEQUENCE# SIZE(M) F_SCN FIRST_TIME ARC STATUS MEMBER
1 1 16 50 13287067 2015-03-03 13:42:06 NO CURRENT /u01/app/oracle/oradata/oa/redo01.log
1 3 15 50 13267062 2015-03-03 13:20:58 NO INACTIVE /u01/app/oracle/oradata/oa/redo03.log
1 2 14 50 13247057 2015-03-03 13:14:43 NO INACTIVE /u01/app/oracle/oradata/oa/redo02.log

Incarnation Information

INCARNATION# RESETLOGS_CHANGE# RESETLOGS_TIME PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TIM STATUS RESETLOGS_ID PRIOR_INCARNATION# FLASHBACK_DATABASE_ALLOWED
1 1 2009-08-15 00:16:43 0   PARENT 694916203 0 NO
2 945184 2014-10-10 18:46:52 1 2009-08-15 00:16:43 PARENT 860611612 1 NO
3 12986990 2015-03-03 11:18:13 945184 2014-10-10 18:46:52 CURRENT 873371893 2 NO

Hot Backup Information

FILE# SCN TIME
1 0  
2 0  
4 0  

Archivelog Information

V$recover_log and V$recover_file

THREAD# SEQUENCE# TIME
1 3 2015-03-03 11:20:36
1 4 2015-03-03 11:35:34

FILE# STATUS SCN TIME
3 OFFLINE 13027003 2015-03-03 11:20:36

Rman Information

------------------------------ ORACLE PATCH ------------------------------ Invoking OPatch 11.1.0.6.6 Oracle 中间补丁程序安装程序版本 11.1.0.6.6 版权所有 (c) 2009, Oracle Corporation。保留所有权利。 Oracle 主目录 : /u01/app/oracle/product/11.2.0/dbhome_2 主产品清单: /u01/app/oraInventory 从 : /etc/oraInst.loc OPatch 版本 : 11.1.0.6.6 OUI 版本 : 11.2.0.1.0 OUI 位置 : /u01/app/oracle/product/11.2.0/dbhome_2/oui 日志文件位置 : /u01/app/oracle/product/11.2.0/dbhome_2/cfgtoollogs/opatch/opatch2015-03-04_18-24-00下午.log Patch history file: /u01/app/oracle/product/11.2.0/dbhome_2/cfgtoollogs/opatch/opatch_history.txt Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2015-03-04_18-24-00下午.txt -------------------------------------------------------------------------------- 已安装的顶级产品 (1): Oracle Database 11g 11.2.0.1.0 此 Oracle 主目录中已安装 1 个产品。 此 Oracle 主目录中未安装任何中间补丁程序。 -------------------------------------------------------------------------------- OPatch succeeded. ------------------------------ ORACLE ALERT ------------------------------ starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Tue Mar 03 12:48:13 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291443789 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Tue Mar 03 12:48:17 2015 ALTER DATABASE OPEN Beginning crash recovery of 1 threads parallel recovery started with 23 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 10, block 2, scn 13167038 Recovery of Online Redo Log: Thread 1 Group 1 Seq 10 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/oa/redo01.log Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 10, block 3, scn 13187040 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Thread 1 advanced to log sequence 11 (thread open) Thread 1 opened at log sequence 11 Current log# 2 seq# 11 mem# 0: /u01/app/oracle/oradata/oa/redo02.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set SMON: enabling cache recovery Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_9682.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_9682.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Error 704 happened during db open, shutting down database USER (ospid: 9682): terminating the instance due to error 704 Instance terminated by USER, pid = 9682 ORA-1092 signalled during: ALTER DATABASE OPEN... opiodr aborting process unknown ospid (9682) as a result of ORA-1092 Tue Mar 03 12:48:20 2015 ORA-1092 : opitsk aborting process Tue Mar 03 12:49:02 2015 Adjusting the default value of parameter parallel_max_servers from 240 to 135 due to the value of parameter processes (150) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned off. LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_2/dbs/spfileoa.ora System parameters with non-default values: processes = 150 memory_target = 25856M control_files = "/u01/app/oracle/oradata/oa/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/oa/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_management = "MANUAL" undo_tablespace = "SYSTEM" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=oaXDB)" audit_file_dest = "/u01/app/oracle/admin/oa/adump" audit_trail = "DB" db_name = "oa" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Mar 03 12:49:11 2015 PMON started with pid=2, OS id=9798 Tue Mar 03 12:49:11 2015 VKTM started with pid=3, OS id=9800 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Mar 03 12:49:11 2015 GEN0 started with pid=4, OS id=9804 Tue Mar 03 12:49:11 2015 DIAG started with pid=5, OS id=9806 Tue Mar 03 12:49:11 2015 DBRM started with pid=6, OS id=9808 Tue Mar 03 12:49:11 2015 PSP0 started with pid=7, OS id=9810 Tue Mar 03 12:49:11 2015 DIA0 started with pid=8, OS id=9812 Tue Mar 03 12:49:11 2015 MMAN started with pid=9, OS id=9814 Tue Mar 03 12:49:11 2015 DBW0 started with pid=10, OS id=9816 Tue Mar 03 12:49:11 2015 DBW1 started with pid=11, OS id=9818 Tue Mar 03 12:49:11 2015 DBW2 started with pid=12, OS id=9820 Tue Mar 03 12:49:11 2015 LGWR started with pid=13, OS id=9822 Tue Mar 03 12:49:11 2015 CKPT started with pid=14, OS id=9824 Tue Mar 03 12:49:11 2015 SMON started with pid=15, OS id=9826 Tue Mar 03 12:49:11 2015 RECO started with pid=16, OS id=9828 Tue Mar 03 12:49:11 2015 MMON started with pid=17, OS id=9830 Tue Mar 03 12:49:11 2015 MMNL started with pid=18, OS id=9832 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Tue Mar 03 12:49:12 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291445128 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Tue Mar 03 12:52:45 2015 Checker run found 1 new persistent data failures Tue Mar 03 12:53:39 2015 alter database datafile 3 offline drop Completed: alter database datafile 3 offline drop Tue Mar 03 12:55:08 2015 alter database open Beginning crash recovery of 1 threads parallel recovery started with 23 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 11, block 2, scn 13187043 Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/oa/redo02.log Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 11, block 3, scn 13207045 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Tue Mar 03 12:55:09 2015 Thread 1 advanced to log sequence 12 (thread open) Thread 1 opened at log sequence 12 Current log# 3 seq# 12 mem# 0: /u01/app/oracle/oradata/oa/redo03.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue Mar 03 12:55:09 2015 SMON: enabling cache recovery Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_9895.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_9895.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Error 704 happened during db open, shutting down database USER (ospid: 9895): terminating the instance due to error 704 Instance terminated by USER, pid = 9895 ORA-1092 signalled during: alter database open... opiodr aborting process unknown ospid (9895) as a result of ORA-1092 Tue Mar 03 12:55:11 2015 ORA-1092 : opitsk aborting process Tue Mar 03 13:02:38 2015 Adjusting the default value of parameter parallel_max_servers from 240 to 135 due to the value of parameter processes (150) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned off. LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_2/dbs/spfileoa.ora System parameters with non-default values: processes = 150 memory_target = 25856M control_files = "/u01/app/oracle/oradata/oa/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/oa/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_management = "MANUAL" undo_tablespace = "SYSTEM" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=oaXDB)" audit_file_dest = "/u01/app/oracle/admin/oa/adump" audit_trail = "DB" db_name = "oa" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Mar 03 13:02:47 2015 PMON started with pid=2, OS id=10061 Tue Mar 03 13:02:47 2015 VKTM started with pid=3, OS id=10063 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Mar 03 13:02:47 2015 GEN0 started with pid=4, OS id=10067 Tue Mar 03 13:02:47 2015 DIAG started with pid=5, OS id=10069 Tue Mar 03 13:02:47 2015 DBRM started with pid=6, OS id=10071 Tue Mar 03 13:02:47 2015 PSP0 started with pid=7, OS id=10073 Tue Mar 03 13:02:47 2015 DIA0 started with pid=8, OS id=10075 Tue Mar 03 13:02:47 2015 MMAN started with pid=9, OS id=10077 Tue Mar 03 13:02:47 2015 DBW0 started with pid=10, OS id=10079 Tue Mar 03 13:02:47 2015 DBW1 started with pid=11, OS id=10081 Tue Mar 03 13:02:47 2015 DBW2 started with pid=12, OS id=10083 Tue Mar 03 13:02:47 2015 LGWR started with pid=13, OS id=10085 Tue Mar 03 13:02:47 2015 CKPT started with pid=14, OS id=10087 Tue Mar 03 13:02:47 2015 SMON started with pid=15, OS id=10089 Tue Mar 03 13:02:47 2015 RECO started with pid=16, OS id=10091 Tue Mar 03 13:02:47 2015 MMON started with pid=17, OS id=10093 Tue Mar 03 13:02:47 2015 MMNL started with pid=18, OS id=10095 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Tue Mar 03 13:02:48 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291429304 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Tue Mar 03 13:03:18 2015 alter database datafile 3 online Tue Mar 03 13:03:18 2015 Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_dbw0_10079.trc: ORA-01157: cannot identify/lock data file 3 - see DBWR trace file ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-1157 signalled during: alter database datafile 3 online... Tue Mar 03 13:03:51 2015 alter database datafile 3 online Completed: alter database datafile 3 online alter database open Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10105.trc: ORA-01113: file 3 needs media recovery ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' ORA-1113 signalled during: alter database open... Tue Mar 03 13:04:14 2015 alter database recover datafile 3 Media Recovery Start Media Recovery failed with error 16433 ORA-283 signalled during: alter database recover datafile 3 ... Tue Mar 03 13:08:38 2015 alter database open noresetlogs ORA-1139 signalled during: alter database open noresetlogs... Tue Mar 03 13:08:59 2015 alter database open resetlogs ORA-1139 signalled during: alter database open resetlogs... Tue Mar 03 13:12:04 2015 Shutting down instance (immediate) Shutting down instance: further logons disabled Stopping background process MMNL Stopping background process MMON License high water mark = 1 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Tue Mar 03 13:12:07 2015 Stopping background process VKTM: Tue Mar 03 13:12:10 2015 Instance shutdown complete Tue Mar 03 13:12:46 2015 Adjusting the default value of parameter parallel_max_servers from 240 to 135 due to the value of parameter processes (150) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned off. LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_2/dbs/spfileoa.ora System parameters with non-default values: processes = 150 memory_target = 25856M control_files = "/u01/app/oracle/oradata/oa/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/oa/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_management = "MANUAL" undo_tablespace = "SYSTEM" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=oaXDB)" audit_file_dest = "/u01/app/oracle/admin/oa/adump" audit_trail = "DB" db_name = "oa" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Mar 03 13:12:55 2015 PMON started with pid=2, OS id=10197 Tue Mar 03 13:12:55 2015 VKTM started with pid=3, OS id=10199 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Mar 03 13:12:55 2015 GEN0 started with pid=4, OS id=10203 Tue Mar 03 13:12:55 2015 DIAG started with pid=5, OS id=10205 Tue Mar 03 13:12:55 2015 DBRM started with pid=6, OS id=10207 Tue Mar 03 13:12:55 2015 PSP0 started with pid=7, OS id=10209 Tue Mar 03 13:12:55 2015 DIA0 started with pid=8, OS id=10211 Tue Mar 03 13:12:55 2015 MMAN started with pid=9, OS id=10213 Tue Mar 03 13:12:55 2015 DBW0 started with pid=10, OS id=10215 Tue Mar 03 13:12:55 2015 DBW1 started with pid=11, OS id=10217 Tue Mar 03 13:12:55 2015 DBW2 started with pid=12, OS id=10219 Tue Mar 03 13:12:55 2015 LGWR started with pid=13, OS id=10221 Tue Mar 03 13:12:55 2015 CKPT started with pid=14, OS id=10223 Tue Mar 03 13:12:55 2015 SMON started with pid=15, OS id=10225 Tue Mar 03 13:12:55 2015 RECO started with pid=16, OS id=10227 Tue Mar 03 13:12:55 2015 MMON started with pid=17, OS id=10229 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue Mar 03 13:12:55 2015 MMNL started with pid=18, OS id=10231 starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Tue Mar 03 13:12:55 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291465751 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Tue Mar 03 13:13:00 2015 ALTER DATABASE OPEN MIGRATE Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10241.trc: ORA-01113: file 3 needs media recovery ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' ORA-1113 signalled during: ALTER DATABASE OPEN MIGRATE... Tue Mar 03 13:13:25 2015 alter database datafile 3 offline drop Completed: alter database datafile 3 offline drop Tue Mar 03 13:13:38 2015 alter database open Beginning crash recovery of 1 threads parallel recovery started with 23 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 12, block 2, scn 13207048 Recovery of Online Redo Log: Thread 1 Group 3 Seq 12 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/oa/redo03.log Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 12, block 3, scn 13227050 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Tue Mar 03 13:13:39 2015 Thread 1 advanced to log sequence 13 (thread open) Thread 1 opened at log sequence 13 Current log# 1 seq# 13 mem# 0: /u01/app/oracle/oradata/oa/redo01.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue Mar 03 13:13:39 2015 SMON: enabling cache recovery Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10241.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10241.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Error 704 happened during db open, shutting down database USER (ospid: 10241): terminating the instance due to error 704 Instance terminated by USER, pid = 10241 ORA-1092 signalled during: alter database open... opiodr aborting process unknown ospid (10241) as a result of ORA-1092 Tue Mar 03 13:13:41 2015 ORA-1092 : opitsk aborting process Tue Mar 03 13:14:29 2015 Adjusting the default value of parameter parallel_max_servers from 240 to 135 due to the value of parameter processes (150) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned off. LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_2/dbs/spfileoa.ora System parameters with non-default values: processes = 150 memory_target = 25856M control_files = "/u01/app/oracle/oradata/oa/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/oa/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_management = "MANUAL" undo_tablespace = "SYSTEM" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=oaXDB)" audit_file_dest = "/u01/app/oracle/admin/oa/adump" audit_trail = "DB" db_name = "oa" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Mar 03 13:14:38 2015 PMON started with pid=2, OS id=10361 Tue Mar 03 13:14:38 2015 VKTM started with pid=3, OS id=10363 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Mar 03 13:14:38 2015 GEN0 started with pid=4, OS id=10367 Tue Mar 03 13:14:38 2015 DIAG started with pid=5, OS id=10369 Tue Mar 03 13:14:38 2015 DBRM started with pid=6, OS id=10371 Tue Mar 03 13:14:38 2015 PSP0 started with pid=7, OS id=10373 Tue Mar 03 13:14:38 2015 DIA0 started with pid=8, OS id=10375 Tue Mar 03 13:14:38 2015 MMAN started with pid=9, OS id=10377 Tue Mar 03 13:14:38 2015 DBW0 started with pid=10, OS id=10379 Tue Mar 03 13:14:38 2015 DBW1 started with pid=11, OS id=10381 Tue Mar 03 13:14:38 2015 DBW2 started with pid=12, OS id=10383 Tue Mar 03 13:14:38 2015 LGWR started with pid=13, OS id=10385 Tue Mar 03 13:14:38 2015 CKPT started with pid=14, OS id=10387 Tue Mar 03 13:14:38 2015 SMON started with pid=15, OS id=10389 Tue Mar 03 13:14:39 2015 RECO started with pid=16, OS id=10391 Tue Mar 03 13:14:39 2015 MMON started with pid=17, OS id=10393 Tue Mar 03 13:14:39 2015 MMNL started with pid=18, OS id=10395 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Tue Mar 03 13:14:39 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291412607 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Tue Mar 03 13:14:43 2015 ALTER DATABASE OPEN MIGRATE Beginning crash recovery of 1 threads parallel recovery started with 23 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 13, block 2, scn 13227053 Recovery of Online Redo Log: Thread 1 Group 1 Seq 13 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/oa/redo01.log Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 13, block 3, scn 13247055 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Thread 1 advanced to log sequence 14 (thread open) Thread 1 opened at log sequence 14 Current log# 2 seq# 14 mem# 0: /u01/app/oracle/oradata/oa/redo02.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set SMON: enabling cache recovery Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10406.trc: ORA-00604: error occurred at recursive SQL level 3 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10406.trc: ORA-00604: error occurred at recursive SQL level 3 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Error 604 happened during db open, shutting down database USER (ospid: 10406): terminating the instance due to error 604 Instance terminated by USER, pid = 10406 ORA-1092 signalled during: ALTER DATABASE OPEN MIGRATE... opiodr aborting process unknown ospid (10406) as a result of ORA-1092 Tue Mar 03 13:14:46 2015 ORA-1092 : opitsk aborting process Tue Mar 03 13:17:47 2015 Adjusting the default value of parameter parallel_max_servers from 240 to 135 due to the value of parameter processes (150) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =29 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in client-side pfile /u01/app/2.ora on machine localhost.localdomain System parameters with non-default values: processes = 150 memory_target = 25856M control_files = "/u01/app/oracle/oradata/oa/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/oa/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_tablespace = "SYSTEM" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=oaXDB)" audit_file_dest = "/u01/app/oracle/admin/oa/adump" audit_trail = "DB" db_name = "oa" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Mar 03 13:17:56 2015 PMON started with pid=2, OS id=10555 Tue Mar 03 13:17:56 2015 VKTM started with pid=3, OS id=10557 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Mar 03 13:17:56 2015 GEN0 started with pid=4, OS id=10561 Tue Mar 03 13:17:56 2015 DIAG started with pid=5, OS id=10563 Tue Mar 03 13:17:56 2015 DBRM started with pid=6, OS id=10565 Tue Mar 03 13:17:56 2015 PSP0 started with pid=7, OS id=10567 Tue Mar 03 13:17:56 2015 DIA0 started with pid=8, OS id=10569 Tue Mar 03 13:17:56 2015 MMAN started with pid=9, OS id=10571 Tue Mar 03 13:17:56 2015 DBW0 started with pid=10, OS id=10573 Tue Mar 03 13:17:56 2015 DBW1 started with pid=11, OS id=10575 Tue Mar 03 13:17:56 2015 DBW2 started with pid=12, OS id=10577 Tue Mar 03 13:17:56 2015 LGWR started with pid=13, OS id=10579 Tue Mar 03 13:17:56 2015 CKPT started with pid=14, OS id=10581 Tue Mar 03 13:17:56 2015 SMON started with pid=15, OS id=10583 Tue Mar 03 13:17:56 2015 RECO started with pid=16, OS id=10585 Tue Mar 03 13:17:56 2015 MMON started with pid=17, OS id=10587 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue Mar 03 13:17:56 2015 MMNL started with pid=18, OS id=10589 starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Tue Mar 03 13:17:56 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291432260 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Tue Mar 03 13:18:45 2015 Shutting down instance (immediate) Shutting down instance: further logons disabled Stopping background process MMNL Stopping background process MMON License high water mark = 1 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Tue Mar 03 13:18:48 2015 Stopping background process VKTM: Tue Mar 03 13:18:51 2015 Instance shutdown complete Tue Mar 03 13:19:08 2015 Adjusting the default value of parameter parallel_max_servers from 240 to 135 due to the value of parameter processes (150) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =29 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_2/dbs/spfileoa.ora System parameters with non-default values: processes = 150 memory_target = 25856M control_files = "/u01/app/oracle/oradata/oa/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/oa/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_tablespace = "SYSTEM" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=oaXDB)" audit_file_dest = "/u01/app/oracle/admin/oa/adump" audit_trail = "DB" db_name = "oa" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Mar 03 13:19:17 2015 PMON started with pid=2, OS id=10667 Tue Mar 03 13:19:17 2015 VKTM started with pid=3, OS id=10669 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Mar 03 13:19:17 2015 GEN0 started with pid=4, OS id=10673 Tue Mar 03 13:19:17 2015 DIAG started with pid=5, OS id=10675 Tue Mar 03 13:19:17 2015 DBRM started with pid=6, OS id=10677 Tue Mar 03 13:19:17 2015 PSP0 started with pid=7, OS id=10679 Tue Mar 03 13:19:17 2015 DIA0 started with pid=8, OS id=10681 Tue Mar 03 13:19:17 2015 MMAN started with pid=9, OS id=10683 Tue Mar 03 13:19:17 2015 DBW0 started with pid=10, OS id=10685 Tue Mar 03 13:19:17 2015 DBW1 started with pid=11, OS id=10687 Tue Mar 03 13:19:17 2015 DBW2 started with pid=12, OS id=10689 Tue Mar 03 13:19:17 2015 LGWR started with pid=13, OS id=10691 Tue Mar 03 13:19:17 2015 CKPT started with pid=14, OS id=10693 Tue Mar 03 13:19:17 2015 SMON started with pid=15, OS id=10695 Tue Mar 03 13:19:17 2015 RECO started with pid=16, OS id=10697 Tue Mar 03 13:19:17 2015 MMON started with pid=17, OS id=10699 Tue Mar 03 13:19:17 2015 MMNL started with pid=18, OS id=10701 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Tue Mar 03 13:19:17 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291455637 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Tue Mar 03 13:20:12 2015 alter database datafile 3 online Completed: alter database datafile 3 online alter database open Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10711.trc: ORA-01113: file 3 needs media recovery ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' ORA-1113 signalled during: alter database open... Tue Mar 03 13:20:32 2015 ALTER DATABASE RECOVER datafile 3 Media Recovery Start Media Recovery failed with error 16433 ORA-283 signalled during: ALTER DATABASE RECOVER datafile 3 ... Tue Mar 03 13:20:48 2015 alter database datafile 3 offline drop Completed: alter database datafile 3 offline drop alter database open Beginning crash recovery of 1 threads parallel recovery started with 23 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 14, block 2, scn 13247058 Recovery of Online Redo Log: Thread 1 Group 2 Seq 14 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/oa/redo02.log Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 14, block 3, scn 13267060 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Tue Mar 03 13:20:58 2015 Thread 1 advanced to log sequence 15 (thread open) Thread 1 opened at log sequence 15 Current log# 3 seq# 15 mem# 0: /u01/app/oracle/oradata/oa/redo03.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Tue Mar 03 13:20:58 2015 SMON: enabling cache recovery Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10711.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10711.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Error 704 happened during db open, shutting down database USER (ospid: 10711): terminating the instance due to error 704 Tue Mar 03 13:20:59 2015 Instance terminated by USER, pid = 10711 ORA-1092 signalled during: alter database open... opiodr aborting process unknown ospid (10711) as a result of ORA-1092 Tue Mar 03 13:21:00 2015 ORA-1092 : opitsk aborting process Tue Mar 03 13:41:51 2015 Adjusting the default value of parameter parallel_max_servers from 240 to 135 due to the value of parameter processes (150) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =29 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_2/dbs/spfileoa.ora System parameters with non-default values: processes = 150 memory_target = 25856M control_files = "/u01/app/oracle/oradata/oa/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/oa/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_tablespace = "SYSTEM" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=oaXDB)" audit_file_dest = "/u01/app/oracle/admin/oa/adump" audit_trail = "DB" db_name = "oa" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Mar 03 13:42:00 2015 PMON started with pid=2, OS id=10941 Tue Mar 03 13:42:00 2015 VKTM started with pid=3, OS id=10943 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Mar 03 13:42:01 2015 GEN0 started with pid=4, OS id=10947 Tue Mar 03 13:42:01 2015 DIAG started with pid=5, OS id=10949 Tue Mar 03 13:42:01 2015 DBRM started with pid=6, OS id=10951 Tue Mar 03 13:42:01 2015 PSP0 started with pid=7, OS id=10953 Tue Mar 03 13:42:01 2015 DIA0 started with pid=8, OS id=10955 Tue Mar 03 13:42:01 2015 MMAN started with pid=9, OS id=10957 Tue Mar 03 13:42:01 2015 DBW0 started with pid=10, OS id=10959 Tue Mar 03 13:42:01 2015 DBW1 started with pid=11, OS id=10961 Tue Mar 03 13:42:01 2015 DBW2 started with pid=12, OS id=10963 Tue Mar 03 13:42:01 2015 LGWR started with pid=13, OS id=10965 Tue Mar 03 13:42:01 2015 CKPT started with pid=14, OS id=10967 Tue Mar 03 13:42:01 2015 SMON started with pid=15, OS id=10969 Tue Mar 03 13:42:01 2015 RECO started with pid=16, OS id=10971 Tue Mar 03 13:42:01 2015 MMON started with pid=17, OS id=10973 Tue Mar 03 13:42:01 2015 MMNL started with pid=18, OS id=10975 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Tue Mar 03 13:42:01 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291450601 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Tue Mar 03 13:42:05 2015 ALTER DATABASE OPEN Beginning crash recovery of 1 threads parallel recovery started with 23 processes Started redo scan Completed redo scan read 0 KB redo, 0 data blocks need recovery Started redo application at Thread 1: logseq 15, block 2, scn 13267063 Recovery of Online Redo Log: Thread 1 Group 3 Seq 15 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/oa/redo03.log Completed redo application of 0.00MB Completed crash recovery at Thread 1: logseq 15, block 3, scn 13287065 0 data blocks read, 0 data blocks written, 0 redo k-bytes read Thread 1 advanced to log sequence 16 (thread open) Thread 1 opened at log sequence 16 Current log# 1 seq# 16 mem# 0: /u01/app/oracle/oradata/oa/redo01.log Successful open of redo thread 1 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set SMON: enabling cache recovery Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10985.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Errors in file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_10985.trc: ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '/u01/app/oracle/oradata/oa/undotbs01.dbf' Error 704 happened during db open, shutting down database USER (ospid: 10985): terminating the instance due to error 704 Instance terminated by USER, pid = 10985 ORA-1092 signalled during: ALTER DATABASE OPEN... opiodr aborting process unknown ospid (10985) as a result of ORA-1092 Tue Mar 03 13:42:08 2015 ORA-1092 : opitsk aborting process Wed Mar 04 18:23:09 2015 Adjusting the default value of parameter parallel_max_servers from 240 to 135 due to the value of parameter processes (150) Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. IMODE=BR ILAT =29 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options. Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_2/dbs/spfileoa.ora System parameters with non-default values: processes = 150 memory_target = 25856M control_files = "/u01/app/oracle/oradata/oa/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/oa/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/u01/app/oracle/flash_recovery_area" db_recovery_file_dest_size= 3882M _allow_resetlogs_corruption= TRUE undo_tablespace = "SYSTEM" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=oaXDB)" audit_file_dest = "/u01/app/oracle/admin/oa/adump" audit_trail = "DB" db_name = "oa" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Wed Mar 04 18:23:18 2015 PMON started with pid=2, OS id=15709 Wed Mar 04 18:23:18 2015 VKTM started with pid=3, OS id=15711 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Wed Mar 04 18:23:18 2015 GEN0 started with pid=4, OS id=15715 Wed Mar 04 18:23:19 2015 DIAG started with pid=5, OS id=15717 Wed Mar 04 18:23:19 2015 DBRM started with pid=6, OS id=15719 Wed Mar 04 18:23:19 2015 PSP0 started with pid=7, OS id=15721 Wed Mar 04 18:23:19 2015 DIA0 started with pid=8, OS id=15723 Wed Mar 04 18:23:19 2015 MMAN started with pid=9, OS id=15725 Wed Mar 04 18:23:19 2015 DBW0 started with pid=10, OS id=15727 Wed Mar 04 18:23:19 2015 DBW1 started with pid=11, OS id=15729 Wed Mar 04 18:23:19 2015 DBW2 started with pid=12, OS id=15731 Wed Mar 04 18:23:19 2015 LGWR started with pid=13, OS id=15733 Wed Mar 04 18:23:19 2015 CKPT started with pid=14, OS id=15735 Wed Mar 04 18:23:19 2015 SMON started with pid=15, OS id=15737 Wed Mar 04 18:23:19 2015 RECO started with pid=16, OS id=15739 Wed Mar 04 18:23:19 2015 MMON started with pid=17, OS id=15741 Wed Mar 04 18:23:19 2015 MMNL started with pid=18, OS id=15743 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... starting up 1 shared server(s) ... ORACLE_BASE not set in environment. It is recommended that ORACLE_BASE be set in the environment Reusing ORACLE_BASE from an earlier startup = /u01/app/oracle Wed Mar 04 18:23:19 2015 ALTER DATABASE MOUNT Successful mount of redo thread 1, with mount id 3291579479 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT ------------------------------ ORACLE DUMP------------------------------ -------------------dump file_hdrs------------------- Trace file /u01/app/oracle/diag/rdbms/oa/oa/trace/oa_ora_15753.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_2 System name: Linux Node name: localhost.localdomain Release: 2.6.32-358.11.1.2.ky3.1.x86_64 Version: #1 SMP Mon Jul 8 13:05:58 CST 2013 Machine: x86_64 Instance name: oa Redo thread mounted by this instance: 1 Oracle process number: 21 Unix process pid: 15753, image: oracle@localhost.localdomain (TNS V1-V3) *** 2015-03-04 18:24:02.184 *** SESSION ID:(232.3) 2015-03-04 18:24:02.184 *** CLIENT ID:() 2015-03-04 18:24:02.184 *** SERVICE NAME:() 2015-03-04 18:24:02.184 *** MODULE NAME:(sqlplus@localhost.localdomain (TNS V1-V3)) 2015-03-04 18:24:02.184 *** ACTION NAME:() 2015-03-04 18:24:02.184 DUMP OF DATA FILES: 4 files in database DATA FILE #1: name #7: /u01/app/oracle/oradata/oa/system01.dbf creation size=0 block size=8192 status=0x2 head=7 tail=7 dup=1 tablespace 0, index=1 krfil=1 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:875 scn: 0x0000.00cabe9c 03/03/2015 13:42:06 Stop scn: 0xffff.ffffffff 03/03/2015 13:20:58 Creation Checkpointed at scn: 0x0000.00000007 08/15/2009 00:16:48 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00c62a6d prev_range: 0 Online Checkpointed at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 thread:1 rba:(0x1.2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED Plugged readony: NO Plugin scnscn: 0x0000.00000000 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Online move state: 0 V10 STYLE FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3278685018=0xc36cc35a, Db Name='OA' Activation ID=0=0x0 Control Seq=75254=0x125f6, File size=96000=0x17700 File Number=1, Blksiz=8192, File Type=3 DATA Tablespace #0 - SYSTEM rel_fn:1 Creation at scn: 0x0000.00000007 08/15/2009 00:16:48 Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0 reset logs count:0x340e98f5 scn: 0x0000.00c62a6e prev reset logs count:0x334be41c scn: 0x0000.000e6c20 recovered at 03/03/2015 13:42:06 status:0x2004 root dba:0x00400208 chkpt cnt: 875 ctl cnt:874 begin-hot-backup file size: 0 Checkpointed at scn: 0x0000.00cabe9c 03/03/2015 13:42:06 thread:1 rba:(0x10.2.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Backup Checkpointed at scn: 0x0000.00000000 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 External cache id: 0x0 0x0 0x0 0x0 Absolute fuzzy scn: 0x0000.00000000 Recovery fuzzy scn: 0x0000.00000000 10/10/2014 18:47:54 Terminal Recovery Stamp 01/01/1988 00:00:00 Platform Information: Creation Platform ID: 13 Current Platform ID: 13 Last Platform ID: 13 DATA FILE #2: name #6: /u01/app/oracle/oradata/oa/sysaux01.dbf creation size=0 block size=8192 status=0x2 head=6 tail=6 dup=1 tablespace 1, index=2 krfil=2 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:875 scn: 0x0000.00cabe9c 03/03/2015 13:42:06 Stop scn: 0xffff.ffffffff 03/03/2015 13:20:58 Creation Checkpointed at scn: 0x0000.0000085c 08/15/2009 00:17:00 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00c62a6d prev_range: 0 Online Checkpointed at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 thread:1 rba:(0x1.2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED Plugged readony: NO Plugin scnscn: 0x0000.00000000 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Online move state: 0 V10 STYLE FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3278685018=0xc36cc35a, Db Name='OA' Activation ID=0=0x0 Control Seq=75254=0x125f6, File size=101120=0x18b00 File Number=2, Blksiz=8192, File Type=3 DATA Tablespace #1 - SYSAUX rel_fn:2 Creation at scn: 0x0000.0000085c 08/15/2009 00:17:00 Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0 reset logs count:0x340e98f5 scn: 0x0000.00c62a6e prev reset logs count:0x334be41c scn: 0x0000.000e6c20 recovered at 03/03/2015 13:42:06 status:0x4 root dba:0x00000000 chkpt cnt: 875 ctl cnt:874 begin-hot-backup file size: 0 Checkpointed at scn: 0x0000.00cabe9c 03/03/2015 13:42:06 thread:1 rba:(0x10.2.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Backup Checkpointed at scn: 0x0000.00000000 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 External cache id: 0x0 0x0 0x0 0x0 Absolute fuzzy scn: 0x0000.00000000 Recovery fuzzy scn: 0x0000.00000000 10/10/2014 18:47:54 Terminal Recovery Stamp 01/01/1988 00:00:00 Platform Information: Creation Platform ID: 13 Current Platform ID: 13 Last Platform ID: 13 DATA FILE #3: name #5: /u01/app/oracle/oradata/oa/undotbs01.dbf creation size=0 block size=8192 status=0x810 head=5 tail=5 dup=1 tablespace 2, index=3 krfil=3 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:753 scn: 0x0000.00c6c6bb 03/03/2015 11:20:36 Stop scn: 0x0000.00c714e0 03/03/2015 11:35:34 Creation Checkpointed at scn: 0x0000.000e620b 08/15/2009 00:52:15 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00c62a6d prev_range: 0 Online Checkpointed at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 thread:1 rba:(0x1.2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED Plugged readony: NO Plugin scnscn: 0x0000.00000000 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Online move state: 0 V10 STYLE FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3278685018=0xc36cc35a, Db Name='OA' Activation ID=0=0x0 Control Seq=75028=0x12514, File size=20480=0x5000 File Number=3, Blksiz=8192, File Type=3 DATA Tablespace #2 - UNDOTBS1 rel_fn:3 Creation at scn: 0x0000.000e620b 08/15/2009 00:52:15 Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0 reset logs count:0x340e98f5 scn: 0x0000.00c62a6e prev reset logs count:0x334be41c scn: 0x0000.000e6c20 recovered at 03/03/2015 11:20:36 status:0x4 root dba:0x00000000 chkpt cnt: 753 ctl cnt:752 begin-hot-backup file size: 0 Checkpointed at scn: 0x0000.00c6c6bb 03/03/2015 11:20:36 thread:1 rba:(0x3.2.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Backup Checkpointed at scn: 0x0000.00000000 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 External cache id: 0x0 0x0 0x0 0x0 Absolute fuzzy scn: 0x0000.00000000 Recovery fuzzy scn: 0x0000.00000000 10/10/2014 18:47:54 Terminal Recovery Stamp 01/01/1988 00:00:00 Platform Information: Creation Platform ID: 13 Current Platform ID: 13 Last Platform ID: 13 DATA FILE #4: name #4: /u01/app/oracle/oradata/oa/users01.dbf creation size=0 block size=8192 status=0x2 head=4 tail=4 dup=1 tablespace 4, index=4 krfil=4 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:866 scn: 0x0000.00cabe9c 03/03/2015 13:42:06 Stop scn: 0xffff.ffffffff 03/03/2015 13:20:58 Creation Checkpointed at scn: 0x0000.00004649 08/15/2009 00:17:30 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00c62a6d prev_range: 0 Online Checkpointed at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 thread:1 rba:(0x1.2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED Plugged readony: NO Plugin scnscn: 0x0000.00000000 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Online move state: 0 V10 STYLE FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3278685018=0xc36cc35a, Db Name='OA' Activation ID=0=0x0 Control Seq=75254=0x125f6, File size=13280=0x33e0 File Number=4, Blksiz=8192, File Type=3 DATA Tablespace #4 - USERS rel_fn:4 Creation at scn: 0x0000.00004649 08/15/2009 00:17:30 Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread:0 reset logs count:0x340e98f5 scn: 0x0000.00c62a6e prev reset logs count:0x334be41c scn: 0x0000.000e6c20 recovered at 03/03/2015 13:42:06 status:0x4 root dba:0x00000000 chkpt cnt: 866 ctl cnt:865 begin-hot-backup file size: 0 Checkpointed at scn: 0x0000.00cabe9c 03/03/2015 13:42:06 thread:1 rba:(0x10.2.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Backup Checkpointed at scn: 0x0000.00000000 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 External cache id: 0x0 0x0 0x0 0x0 Absolute fuzzy scn: 0x0000.00000000 Recovery fuzzy scn: 0x0000.00000000 10/10/2014 18:47:54 Terminal Recovery Stamp 01/01/1988 00:00:00 Platform Information: Creation Platform ID: 13 Current Platform ID: 13 Last Platform ID: 13 DUMP OF TEMP FILES: 1 files in database TEMP FILE #1: External File #201 name #8: /u01/app/oracle/oradata/oa/temp01.dbf creation size=2560 block size=8192 status=0x1e head=8 tail=8 dup=1 tablespace 3, index=5 krfil=1 prev_file=0 unrecoverable scn: 0x0000.000e6cfb 10/10/2014 18:46:54 DDE rules only execution for: ORA 1110 ----- START Event Driven Actions Dump ---- ---- END Event Driven Actions Dump ---- ----- START DDE Actions Dump ----- Executing SYNC actions ----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) ----- Successfully dispatched ----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) ----- Executing ASYNC actions ----- END DDE Actions Dump (total 0 csec) ----- ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: '/u01/app/oracle/oradata/oa/temp01.dbf' *** Error 1157 in open/read file # 201 *** -------------------dump controlf------------------- DUMP OF CONTROL FILES, Seq # 75259 = 0x125fb V10 STYLE FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3278685018=0xc36cc35a, Db Name='OA' Activation ID=0=0x0 Control Seq=75259=0x125fb, File size=594=0x252 File Number=0, Blksiz=16384, File Type=1 CONTROL *************************************************************************** DATABASE ENTRY *************************************************************************** (size = 316, compat size = 316, section max = 1, section in-use = 1, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 1, numrecs = 1) 10/10/2014 18:46:50 DB Name "OA" Database flags = 0x00404802 0x00001000 Controlfile Creation Timestamp 10/10/2014 18:46:50 Incmplt recovery scn: 0x0000.00000000 Resetlogs scn: 0x0000.00c62a6e Resetlogs Timestamp 03/03/2015 11:18:13 Prior resetlogs scn: 0x0000.000e6c20 Prior resetlogs Timestamp 10/10/2014 18:46:52 Redo Version: compatible=0xb200000 #Data files = 4, #Online files = 3 Database checkpoint: Thread=1 scn: 0x0000.00cabe9c Threads: #Enabled=1, #Open=1, Head=1, Tail=1 enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Max log members = 3, Max data members = 1 Arch list: Head=0, Tail=0, Force scn: 0x0000.00000000scn: 0x0000.00c62a6e Activation ID: 3291455720 Controlfile Checkpointed at scn: 0x0000.00cabe9c 03/03/2015 13:42:06 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 *************************************************************************** CHECKPOINT PROGRESS RECORDS *************************************************************************** (size = 8180, compat size = 8180, section max = 11, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 2, numrecs = 11) THREAD #1 - status:0x2 flags:0x0 dirty:234 low cache rba:(0x2d6.91df.0) on disk rba:(0x2d6.94a0.0) on disk scn: 0x0000.00c69cb2 03/02/2015 14:28:54 resetlogs scn: 0x0000.000e6c20 10/10/2014 18:46:52 heartbeat: 873476648 mount id: 3291579479 THREAD #2 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #3 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #4 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #5 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #6 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #7 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 THREAD #8 - status:0x0 flags:0x0 dirty:0 low cache rba:(0x0.0.0) on disk rba:(0x0.0.0) on disk scn: 0x0000.00000000 01/01/1988 00:00:00 resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00 heartbeat: 0 mount id: 0 *************************************************************************** EXTENDED DATABASE ENTRY *************************************************************************** (size = 900, compat size = 900, section max = 1, section in-use = 1, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 140, numrecs = 1) Control AutoBackup date(dd/mm/yyyy)=10/10/2014 Next AutoBackup sequence= 0 Database recovery target inc#:3, Last open inc#:3 flg:0x20, flag:0x0 Change tracking state=0, file index=0, checkpoint count=0scn: 0x0000.00000000 Flashback log count=0, block count=0 Desired flashback log size=0 blocks Oldest guarantee restore point=0 Highest thread enable/disable scn: 0x0000.00000000 Number of Open thread with finite next SCN in last log: 0 Number of half-enabled redo threads: 0 Sum of absolute file numbers for files currently being moved online: 0 *************************************************************************** REDO THREAD RECORDS *************************************************************************** (size = 256, compat size = 256, section max = 8, section in-use = 1, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 9, numrecs = 8) THREAD #1 - status:0xf thread links forward:0 back:0 #logs:3 first:1 last:3 current:1 last used seq#:0x10 enabled at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00 opened at 03/03/2015 13:42:06 by instance oa Checkpointed at scn: 0x0000.00cabe9c 03/03/2015 13:42:06 thread:1 rba:(0x10.2.10) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 log history: 740 restore point keep sequence: 0 *************************************************************************** LOG FILE RECORDS *************************************************************************** (size = 72, compat size = 72, section max = 16, section in-use = 3, last-recid= 6, old-recno = 0, last-recno = 0) (extent = 1, blkno = 10, numrecs = 16) LOG FILE #1: name #3: /u01/app/oracle/oradata/oa/redo01.log Thread 1 redo log links: forward: 2 backward: 0 siz: 0x19000 seq: 0x00000010 hws: 0x2 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00ca7076 Low scn: 0x0000.00cabe9b 03/03/2015 13:42:06 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00 LOG FILE #2: name #2: /u01/app/oracle/oradata/oa/redo02.log Thread 1 redo log links: forward: 3 backward: 1 siz: 0x19000 seq: 0x0000000e hws: 0x6 bsz: 512 nab: 0x3 flg: 0x0 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00c9d42c Low scn: 0x0000.00ca2251 03/03/2015 13:14:43 Next scn: 0x0000.00ca7076 03/03/2015 13:20:58 LOG FILE #3: name #1: /u01/app/oracle/oradata/oa/redo03.log Thread 1 redo log links: forward: 0 backward: 2 siz: 0x19000 seq: 0x0000000f hws: 0x5 bsz: 512 nab: 0x3 flg: 0x0 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00ca2251 Low scn: 0x0000.00ca7076 03/03/2015 13:20:58 Next scn: 0x0000.00cabe9b 03/03/2015 13:42:06 *************************************************************************** DATA FILE RECORDS *************************************************************************** (size = 520, compat size = 520, section max = 100, section in-use = 4, last-recid= 201, old-recno = 0, last-recno = 0) (extent = 1, blkno = 11, numrecs = 100) DATA FILE #1: name #7: /u01/app/oracle/oradata/oa/system01.dbf creation size=0 block size=8192 status=0x2 head=7 tail=7 dup=1 tablespace 0, index=1 krfil=1 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:875 scn: 0x0000.00cabe9c 03/03/2015 13:42:06 Stop scn: 0xffff.ffffffff 03/03/2015 13:20:58 Creation Checkpointed at scn: 0x0000.00000007 08/15/2009 00:16:48 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00c62a6d prev_range: 0 Online Checkpointed at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 thread:1 rba:(0x1.2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED Plugged readony: NO Plugin scnscn: 0x0000.00000000 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Online move state: 0 DATA FILE #2: name #6: /u01/app/oracle/oradata/oa/sysaux01.dbf creation size=0 block size=8192 status=0x2 head=6 tail=6 dup=1 tablespace 1, index=2 krfil=2 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:875 scn: 0x0000.00cabe9c 03/03/2015 13:42:06 Stop scn: 0xffff.ffffffff 03/03/2015 13:20:58 Creation Checkpointed at scn: 0x0000.0000085c 08/15/2009 00:17:00 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00c62a6d prev_range: 0 Online Checkpointed at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 thread:1 rba:(0x1.2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED Plugged readony: NO Plugin scnscn: 0x0000.00000000 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Online move state: 0 DATA FILE #3: name #5: /u01/app/oracle/oradata/oa/undotbs01.dbf creation size=0 block size=8192 status=0x810 head=5 tail=5 dup=1 tablespace 2, index=3 krfil=3 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:753 scn: 0x0000.00c6c6bb 03/03/2015 11:20:36 Stop scn: 0x0000.00c714e0 03/03/2015 11:35:34 Creation Checkpointed at scn: 0x0000.000e620b 08/15/2009 00:52:15 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00c62a6d prev_range: 0 Online Checkpointed at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 thread:1 rba:(0x1.2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED Plugged readony: NO Plugin scnscn: 0x0000.00000000 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Online move state: 0 DATA FILE #4: name #4: /u01/app/oracle/oradata/oa/users01.dbf creation size=0 block size=8192 status=0x2 head=4 tail=4 dup=1 tablespace 4, index=4 krfil=4 prev_file=0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt:866 scn: 0x0000.00cabe9c 03/03/2015 13:42:06 Stop scn: 0xffff.ffffffff 03/03/2015 13:20:58 Creation Checkpointed at scn: 0x0000.00004649 08/15/2009 00:17:30 thread:0 rba:(0x0.0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000.00c62a6d prev_range: 0 Online Checkpointed at scn: 0x0000.00c62a6e 03/03/2015 11:18:13 thread:1 rba:(0x1.2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is NOT DEFINED Plugged readony: NO Plugin scnscn: 0x0000.00000000 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00 Online move state: 0 *************************************************************************** TEMP FILE RECORDS *************************************************************************** (size = 56, compat size = 56, section max = 100, section in-use = 1, last-recid= 1, old-recno = 0, last-recno = 0) (extent = 1, blkno = 90, numrecs = 100) TEMP FILE #1: External File #201 name #8: /u01/app/oracle/oradata/oa/temp01.dbf creation size=2560 block size=8192 status=0x1e head=8 tail=8 dup=1 tablespace 3, index=5 krfil=1 prev_file=0 unrecoverable scn: 0x0000.000e6cfb 10/10/2014 18:46:54 *************************************************************************** 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 = 89, 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 SYSAUX: 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 UNDOTBS1: 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=1 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 *************************************************************************** (size = 1108, compat size = 1108, section max = 50, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 91, 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 = 142, 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 = 159, numrecs = 8) oa 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 = 160, numrecs = 8) MTTR record for thread 1 MTTR statistics status: 1 Init time: Avg: 12295000 us, Times measured: 2 File open time: Avg: 446 us, Times measured: 12 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: 388430 # of data blocks measured: 24521 # of change vectors measured: 1409168 *************************************************************************** STANDBY DATABASE MAP RECORDS *************************************************************************** (size = 400, compat size = 400, section max = 31, section in-use = 31, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 163, numrecs = 31) *************************************************************************** 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 = 164, numrecs = 2048) *************************************************************************** ACM SERVICE RECORDS *************************************************************************** (size = 104, compat size = 104, section max = 64, section in-use = 6, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 259, numrecs = 64) ACM record=1 id=0 descrip=ACM unit testing operation attr=1 ver=0 exptime=0 cpid=0 cinst=0 phase=1 ACM record=2 id=1 descrip=LSB Database Guard attr=1 ver=0 exptime=0 cpid=0 cinst=0 phase=1 ACM record=3 id=2 descrip=Supplemental Log Data DDL attr=1 ver=0 exptime=0 cpid=0 cinst=0 phase=1 ACM record=4 id=3 descrip=LSB Role Change Support attr=1 ver=0 exptime=0 cpid=0 cinst=0 phase=1 ACM record=5 id=4 descrip=RFS block and kill across RAC attr=1 ver=0 exptime=0 cpid=0 cinst=0 phase=1 ACM record=6 id=5 descrip=RAC-wide SGA attr=1 ver=0 exptime=0 cpid=0 cinst=0 phase=1 *************************************************************************** LOG FILE HISTORY RECORDS *************************************************************************** (size = 56, compat size = 56, section max = 292, section in-use = 292, last-recid= 740, old-recno = 157, last-recno = 156) (extent = 1, blkno = 95, numrecs = 292) Earliest record: RECID #449 Recno 157 Record timestamp 01/05/15 22:20:14 Thread=1 Seq#=449 Link-Recid=448 kccic-Recid=2 Low scn: 0x0000.0082c34b 01/05/15 22:20:12 Next scn: 0x0000.0082cc3c Latest record: RECID #740 Recno 156 Record timestamp 03/03/15 13:42:06 Thread=1 Seq#=15 Link-Recid=739 kccic-Recid=3 Low scn: 0x0000.00ca7076 03/03/15 13:20:58 Next scn: 0x0000.00cabe9b *************************************************************************** OFFLINE RANGE RECORDS *************************************************************************** (size = 200, compat size = 200, section max = 163, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 96, numrecs = 163) *************************************************************************** ARCHIVED LOG RECORDS *************************************************************************** (size = 584, compat size = 584, section max = 28, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 98, numrecs = 28) *************************************************************************** FOREIGN ARCHIVED LOG RECORDS *************************************************************************** (size = 604, compat size = 604, section max = 1002, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 260, numrecs = 1002) *************************************************************************** BACKUP SET 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 = 99, numrecs = 409) *************************************************************************** BACKUP PIECE RECORDS *************************************************************************** (size = 736, compat size = 736, section max = 200, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 100, numrecs = 200) *************************************************************************** BACKUP DATAFILE RECORDS *************************************************************************** (size = 200, compat size = 200, section max = 245, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 109, numrecs = 245) *************************************************************************** BACKUP LOG RECORDS *************************************************************************** (size = 76, compat size = 76, section max = 215, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 112, numrecs = 215) *************************************************************************** DATAFILE COPY RECORDS *************************************************************************** (size = 736, compat size = 736, section max = 200, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 113, numrecs = 200) *************************************************************************** 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 = 122, 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 = 123, 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 = 124, numrecs = 818) *************************************************************************** PROXY COPY RECORDS *************************************************************************** (size = 928, compat size = 928, section max = 246, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 125, numrecs = 246) *************************************************************************** INCARNATION RECORDS *************************************************************************** (size = 56, compat size = 56, section max = 292, section in-use = 3, last-recid= 3, old-recno = 1, last-recno = 3) (extent = 1, blkno = 141, numrecs = 292) Earliest record: RECID #1 Recno 1 Record timestamp Resetlogs scn and time scn: 0x0000.00000001 08/15/09 00:16:43 Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00 Incarnation (parent inc#, flag)=(0, 0) Latest record: RECID #3 Recno 3 Record timestamp Resetlogs scn and time scn: 0x0000.00c62a6e 03/03/15 11:18:13 Previous Resetlogs scn and time scn: 0x0000.000e6c20 10/10/14 18:46:52 Incarnation (parent inc#, flag)=(2, 2) *************************************************************************** RMAN STATUS RECORDS *************************************************************************** (size = 116, compat size = 116, section max = 141, section in-use = 4, last-recid= 4, old-recno = 1, last-recno = 4) (extent = 1, blkno = 158, numrecs = 141) Earliest record: RECID #1 Recno 1 Internal Status: 34 External Status: 2 Command id: 2015-03-03T12:52:38 Operation: RMAN Start and End time 03/03/15 12:52:39 03/03/15 12:52:54 Latest record: RECID #4 Recno 4 Internal Status: 34 External Status: 2 Command id: 2015-03-03T12:53:47 Operation: report Start and End time 03/03/15 12:53:52 03/03/15 12:53: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 = 161, 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 = 191, numrecs = 2083) *************************************************************************** DATABASE BLOCK CORRUPTION RECORDS *************************************************************************** (size = 80, compat size = 80, section max = 8384, section in-use = 0, last-recid= 0, old-recno = 0, last-recno = 0) (extent = 1, blkno = 218, numrecs = 8384) *** END OF DUMP *** -------------------dump redohdr------------------- *** 2015-03-04 18:24:02.232 DUMP OF LOG FILES: 3 logs in database LOG FILE #1: name #3: /u01/app/oracle/oradata/oa/redo01.log Thread 1 redo log links: forward: 2 backward: 0 siz: 0x19000 seq: 0x00000010 hws: 0x2 bsz: 512 nab: 0xffffffff flg: 0x8 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00ca7076 Low scn: 0x0000.00cabe9b 03/03/2015 13:42:06 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00 FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3278685018=0xc36cc35a, Db Name='OA' Activation ID=3291455720=0xc42fa0e8 Control Seq=75254=0x125f6, File size=102400=0x19000 File Number=1, Blksiz=512, File Type=2 LOG redo log key is 3c9b1e312af857d1e8a7f9657f962ab5 redo log key flag is 5 descrip:"Thread 0001, Seq# 0000000016, SCN 0x000000cabe9b-0xffffffffffff" thread: 1 nab: 0xffffffff seq: 0x00000010 hws: 0x2 eot: 1 dis: 0 reset logs count: 0x340e98f5 scn: 0x0000.00c62a6e Low scn: 0x0000.00cabe9b 03/03/2015 13:42:06 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00 Enabled scn: 0x0000.00c62a6e 03/03/2015 11:18:13 Thread closed scn: 0x0000.00cabe9b 03/03/2015 13:42:06 Disk cksum: 0xe3e1 Calc cksum: 0xe3e1 Terminal Recovery Stop scn: 0x0000.00000000 Terminal Recovery Stamp 01/01/1988 00:00:00 Most recent redo scn: 0x0000.00000000 Largest LWN: 0 blocks Miscellaneous flags: 0x800000 Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000 LOG FILE #2: name #2: /u01/app/oracle/oradata/oa/redo02.log Thread 1 redo log links: forward: 3 backward: 1 siz: 0x19000 seq: 0x0000000e hws: 0x6 bsz: 512 nab: 0x3 flg: 0x0 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00c9d42c Low scn: 0x0000.00ca2251 03/03/2015 13:14:43 Next scn: 0x0000.00ca7076 03/03/2015 13:20:58 FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3278685018=0xc36cc35a, Db Name='OA' Activation ID=3291455720=0xc42fa0e8 Control Seq=75252=0x125f4, File size=102400=0x19000 File Number=2, Blksiz=512, File Type=2 LOG redo log key is 513191ce97281320697b5fb4837875da redo log key flag is 5 descrip:"Thread 0001, Seq# 0000000014, SCN 0x000000ca2251-0x000000ca7076" thread: 1 nab: 0x3 seq: 0x0000000e hws: 0x6 eot: 0 dis: 0 reset logs count: 0x340e98f5 scn: 0x0000.00c62a6e Low scn: 0x0000.00ca2251 03/03/2015 13:14:43 Next scn: 0x0000.00ca7076 03/03/2015 13:20:58 Enabled scn: 0x0000.00c62a6e 03/03/2015 11:18:13 Thread closed scn: 0x0000.00ca7074 03/03/2015 13:14:43 Disk cksum: 0x12b6 Calc cksum: 0x12b6 Terminal Recovery Stop scn: 0x0000.00000000 Terminal Recovery Stamp 01/01/1988 00:00:00 Most recent redo scn: 0x0000.00000000 Largest LWN: 0 blocks Miscellaneous flags: 0x800000 Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000 LOG FILE #3: name #1: /u01/app/oracle/oradata/oa/redo03.log Thread 1 redo log links: forward: 0 backward: 2 siz: 0x19000 seq: 0x0000000f hws: 0x5 bsz: 512 nab: 0x3 flg: 0x0 dup: 1 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00ca2251 Low scn: 0x0000.00ca7076 03/03/2015 13:20:58 Next scn: 0x0000.00cabe9b 03/03/2015 13:42:06 FILE HEADER: Compatibility Vsn = 186646528=0xb200000 Db ID=3278685018=0xc36cc35a, Db Name='OA' Activation ID=3291455720=0xc42fa0e8 Control Seq=75253=0x125f5, File size=102400=0x19000 File Number=3, Blksiz=512, File Type=2 LOG redo log key is a3601388d0bac880759113e4223622e redo log key flag is 5 descrip:"Thread 0001, Seq# 0000000015, SCN 0x000000ca7076-0x000000cabe9b" thread: 1 nab: 0x3 seq: 0x0000000f hws: 0x5 eot: 0 dis: 0 reset logs count: 0x340e98f5 scn: 0x0000.00c62a6e Low scn: 0x0000.00ca7076 03/03/2015 13:20:58 Next scn: 0x0000.00cabe9b 03/03/2015 13:42:06 Enabled scn: 0x0000.00c62a6e 03/03/2015 11:18:13 Thread closed scn: 0x0000.00cabe99 03/03/2015 13:20:58 Disk cksum: 0x329b Calc cksum: 0x329b Terminal Recovery Stop scn: 0x0000.00000000 Terminal Recovery Stamp 01/01/1988 00:00:00 Most recent redo scn: 0x0000.00000000 Largest LWN: 0 blocks Miscellaneous flags: 0x800000 Thread internal enable indicator: thr: 0, seq: 0 scn: 0x0000.00000000