Fri Oct 30 10:04:58 2015 Starting ORACLE instance (normal) (OS id: 30013) Fri Oct 30 10:04:58 2015 CLI notifier numLatches:3 maxDescs:519 Fri Oct 30 10:04:58 2015 ********************************************************************** Fri Oct 30 10:04:58 2015 Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Fri Oct 30 10:04:58 2015 Per process system memlock (soft) limit = 64K Fri Oct 30 10:04:58 2015 Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 818M Fri Oct 30 10:04:58 2015 Available system pagesizes: 4K, 2048K Fri Oct 30 10:04:58 2015 Supported system pagesize(s): Fri Oct 30 10:04:58 2015 PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) Fri Oct 30 10:04:58 2015 4K Configured 4 208900 NONE Fri Oct 30 10:04:58 2015 2048K 0 409 0 NONE Fri Oct 30 10:04:58 2015 RECOMMENDATION: Fri Oct 30 10:04:58 2015 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. Fri Oct 30 10:04:58 2015 2. Increase per process memlock (soft) limit to at least 818MB to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory Fri Oct 30 10:04:58 2015 ********************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 2 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is enabled NOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASM Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1 System name: Linux Node name: db7clone Release: 3.8.13-68.3.4.el6uek.x86_64 Version: #2 SMP Tue Jul 14 15:03:36 PDT 2015 Machine: x86_64 VM name: Xen Version: 4.3 (PVM) Using parameter settings in server-side spfile +DB1DATA/TESTDB1/PARAMETERFILE/spfile.265.893851227 System parameters with non-default values: processes = 300 sga_target = 816M control_files = "+DB1DATA/TESTDB1/CONTROLFILE/current.260.893849157" control_files = "+DB1FRA/TESTDB1/CONTROLFILE/current.256.893849187" db_block_size = 8192 compatible = "12.1.0.2.0" db_create_file_dest = "+DB1DATA" db_recovery_file_dest = "+DB1FRA" db_recovery_file_dest_size= 4560M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=TESTDB1XDB)" audit_file_dest = "/u01/app/oracle/admin/TESTDB1/adump" audit_trail = "DB" db_name = "TESTDB1" open_cursors = 300 pga_aggregate_target = 272M diagnostic_dest = "/u01/app/oracle" NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON Fri Oct 30 10:04:58 2015 PMON started with pid=2, OS id=30020 Starting background process PSP0 Starting background process VKTM Fri Oct 30 10:04:58 2015 PSP0 started with pid=3, OS id=30022 Fri Oct 30 10:04:59 2015 VKTM started with pid=4, OS id=30024 at elevated (RT) priority Starting background process GEN0 Fri Oct 30 10:04:59 2015 VKTM running at (1)millisec precision with DBRM quantum (100)ms Starting background process MMAN Fri Oct 30 10:04:59 2015 GEN0 started with pid=5, OS id=30028 Fri Oct 30 10:04:59 2015 MMAN started with pid=6, OS id=30030 Starting background process DIAG Fri Oct 30 10:04:59 2015 DIAG started with pid=8, OS id=30034 Starting background process DBRM Fri Oct 30 10:04:59 2015 DBRM started with pid=9, OS id=30036 Starting background process VKRM Fri Oct 30 10:04:59 2015 VKRM started with pid=10, OS id=30038 Starting background process DIA0 Starting background process DBW0 Fri Oct 30 10:04:59 2015 DIA0 started with pid=11, OS id=30040 Starting background process LGWR Fri Oct 30 10:04:59 2015 DBW0 started with pid=12, OS id=30042 Starting background process CKPT Fri Oct 30 10:04:59 2015 LGWR started with pid=13, OS id=30044 Fri Oct 30 10:04:59 2015 CKPT started with pid=14, OS id=30046 Starting background process SMON Fri Oct 30 10:04:59 2015 SMON started with pid=16, OS id=30050 Starting background process RECO Starting background process LREG Fri Oct 30 10:04:59 2015 RECO started with pid=18, OS id=30054 Starting background process PXMN Fri Oct 30 10:05:00 2015 LREG started with pid=19, OS id=30056 Starting background process RBAL Fri Oct 30 10:05:00 2015 PXMN started with pid=20, OS id=30058 Starting background process ASMB Fri Oct 30 10:05:00 2015 RBAL started with pid=21, OS id=30060 Starting background process MMON Fri Oct 30 10:05:00 2015 ASMB started with pid=22, OS id=30062 Starting background process MMNL Fri Oct 30 10:05:00 2015 MMON started with pid=23, OS id=30064 Fri Oct 30 10:05:00 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Fri Oct 30 10:05:00 2015 MMNL started with pid=24, OS id=30068 starting up 1 shared server(s) ... Fri Oct 30 10:05:00 2015 NOTE: ASMB registering with ASM instance as Standard client 0xffffffffffffffff (reg:4292951568) (new connection) NOTE: ASMB connected to ASM instance +ASM osid: 30066 (Flex mode; client id 0xffffffffffffffff) NOTE: initiating MARK startup Starting background process MARK Fri Oct 30 10:05:00 2015 MARK started with pid=27, OS id=30074 ORACLE_BASE from environment = /u01/app/oracle Fri Oct 30 10:05:00 2015 NOTE: MARK has subscribed Fri Oct 30 10:05:02 2015 Using default pga_aggregate_limit of 2048 MB Fri Oct 30 10:05:03 2015 NOTE: ASMB mounting group 2 (DB1DATA) NOTE: Assigning number (2,0) to disk (/dev/oracleasm/disks/DATA1) NOTE: Assigning number (2,1) to disk (/dev/oracleasm/disks/DATA2) SUCCESS: mounted group 2 (DB1DATA) NOTE: grp 2 disk 0: DB1DATA_0000 path:/dev/oracleasm/disks/DATA1 NOTE: grp 2 disk 1: DB1DATA_0001 path:/dev/oracleasm/disks/DATA2 Fri Oct 30 10:05:03 2015 ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.8.103)(PORT=1521))' SCOPE=MEMORY SID='TESTDB1'; Fri Oct 30 10:05:03 2015 ALTER SYSTEM SET control_files='+DB1DATA/TESTDB1/CONTROLFILE/Current.260.893849157' SCOPE=SPFILE; Shutting down instance (immediate) Shutting down instance: further logons disabled Stopping background process MMNL Fri Oct 30 10:05:04 2015 NOTE: dependency between database TESTDB1 and diskgroup resource ora.DB1DATA.dg is established Stopping background process MMON License high water mark = 2 Fri Oct 30 10:05:05 2015 All dispatchers and shared servers shutdown ALTER DATABASE CLOSE NORMAL ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL... ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled ARCH: Archival disabled due to shutdown: 1089 Fri Oct 30 10:05:08 2015 Stopping background process VKTM Shutting down archive processes Archiving is disabled Fri Oct 30 10:05:08 2015 NOTE: Shutting down MARK background process Fri Oct 30 10:05:18 2015 NOTE: ASMB releasing group resources due to shutdown NOTE: ASMB clearing idle groups before exit Stopping background process RBAL Fri Oct 30 10:05:21 2015 Instance shutdown complete Fri Oct 30 10:05:25 2015 Starting ORACLE instance (normal) (OS id: 30139) Fri Oct 30 10:05:25 2015 CLI notifier numLatches:3 maxDescs:519 Fri Oct 30 10:05:25 2015 ********************************************************************** Fri Oct 30 10:05:25 2015 Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Fri Oct 30 10:05:25 2015 Per process system memlock (soft) limit = 64K Fri Oct 30 10:05:25 2015 Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 818M Fri Oct 30 10:05:25 2015 Available system pagesizes: 4K, 2048K Fri Oct 30 10:05:25 2015 Supported system pagesize(s): Fri Oct 30 10:05:25 2015 PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) Fri Oct 30 10:05:25 2015 4K Configured 4 208900 NONE Fri Oct 30 10:05:25 2015 2048K 0 409 0 NONE Fri Oct 30 10:05:25 2015 RECOMMENDATION: Fri Oct 30 10:05:25 2015 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. Fri Oct 30 10:05:25 2015 2. Increase per process memlock (soft) limit to at least 818MB to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory Fri Oct 30 10:05:25 2015 ********************************************************************** LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Initial number of CPU is 2 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 =51 LICENSE_MAX_USERS = 0 SYS auditing is enabled NOTE: remote asm mode is local (mode 0x1; from cluster type) NOTE: Using default ASM root directory ASM Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options. ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1 System name: Linux Node name: db7clone Release: 3.8.13-68.3.4.el6uek.x86_64 Version: #2 SMP Tue Jul 14 15:03:36 PDT 2015 Machine: x86_64 VM name: Xen Version: 4.3 (PVM) Using parameter settings in server-side spfile +DB1DATA/TESTDB1/PARAMETERFILE/spfile.265.893851227 System parameters with non-default values: processes = 300 sga_target = 816M control_files = "+DB1DATA/TESTDB1/CONTROLFILE/current.260.893849157" db_block_size = 8192 compatible = "12.1.0.2.0" db_create_file_dest = "+DB1DATA" db_recovery_file_dest = "+DB1FRA" db_recovery_file_dest_size= 4560M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=TESTDB1XDB)" audit_file_dest = "/u01/app/oracle/admin/TESTDB1/adump" audit_trail = "DB" db_name = "TESTDB1" open_cursors = 300 pga_aggregate_target = 272M diagnostic_dest = "/u01/app/oracle" NOTE: remote asm mode is local (mode 0x1; from cluster type) Starting background process PMON Starting background process PSP0 Fri Oct 30 10:05:26 2015 PMON started with pid=2, OS id=30146 Starting background process VKTM Fri Oct 30 10:05:26 2015 PSP0 started with pid=3, OS id=30148 Fri Oct 30 10:05:27 2015 VKTM started with pid=4, OS id=30150 at elevated (RT) priority Starting background process GEN0 Fri Oct 30 10:05:27 2015 VKTM running at (1)millisec precision with DBRM quantum (100)ms Starting background process MMAN Fri Oct 30 10:05:27 2015 GEN0 started with pid=5, OS id=30154 Fri Oct 30 10:05:27 2015 MMAN started with pid=6, OS id=30156 Starting background process DIAG Fri Oct 30 10:05:27 2015 DIAG started with pid=8, OS id=30160 Starting background process DBRM Fri Oct 30 10:05:27 2015 DBRM started with pid=9, OS id=30162 Starting background process VKRM Fri Oct 30 10:05:27 2015 VKRM started with pid=10, OS id=30164 Starting background process DIA0 Fri Oct 30 10:05:27 2015 DIA0 started with pid=11, OS id=30166 Starting background process DBW0 Fri Oct 30 10:05:27 2015 DBW0 started with pid=12, OS id=30168 Starting background process LGWR Fri Oct 30 10:05:27 2015 LGWR started with pid=13, OS id=30170 Starting background process CKPT Fri Oct 30 10:05:27 2015 CKPT started with pid=14, OS id=30172 Starting background process SMON Fri Oct 30 10:05:27 2015 SMON started with pid=16, OS id=30176 Starting background process RECO Fri Oct 30 10:05:27 2015 RECO started with pid=18, OS id=30180 Starting background process LREG Fri Oct 30 10:05:27 2015 LREG started with pid=19, OS id=30182 Starting background process PXMN Fri Oct 30 10:05:27 2015 PXMN started with pid=20, OS id=30184 Starting background process RBAL Fri Oct 30 10:05:27 2015 RBAL started with pid=21, OS id=30186 Starting background process ASMB Fri Oct 30 10:05:27 2015 ASMB started with pid=22, OS id=30188 Starting background process MMON Starting background process MMNL Fri Oct 30 10:05:27 2015 MMON started with pid=23, OS id=30190 Fri Oct 30 10:05:27 2015 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Fri Oct 30 10:05:27 2015 MMNL started with pid=24, OS id=30194 starting up 1 shared server(s) ... Fri Oct 30 10:05:28 2015 NOTE: ASMB registering with ASM instance as Standard client 0xffffffffffffffff (reg:2562040050) (new connection) NOTE: ASMB connected to ASM instance +ASM osid: 30192 (Flex mode; client id 0xffffffffffffffff) NOTE: initiating MARK startup Starting background process MARK Fri Oct 30 10:05:28 2015 MARK started with pid=27, OS id=30200 ORACLE_BASE from environment = /u01/app/oracle Fri Oct 30 10:05:28 2015 NOTE: MARK has subscribed Fri Oct 30 10:05:28 2015 ALTER DATABASE MOUNT Fri Oct 30 10:05:28 2015 ALTER SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.8.103)(PORT=1521))' SCOPE=MEMORY SID='TESTDB1'; Fri Oct 30 10:05:31 2015 NOTE: ASMB mounting group 2 (DB1DATA) NOTE: Assigning number (2,0) to disk (/dev/oracleasm/disks/DATA1) NOTE: Assigning number (2,1) to disk (/dev/oracleasm/disks/DATA2) SUCCESS: mounted group 2 (DB1DATA) NOTE: grp 2 disk 0: DB1DATA_0000 path:/dev/oracleasm/disks/DATA1 NOTE: grp 2 disk 1: DB1DATA_0001 path:/dev/oracleasm/disks/DATA2 Fri Oct 30 10:05:31 2015 Using default pga_aggregate_limit of 2048 MB Fri Oct 30 10:05:31 2015 NOTE: dependency between database TESTDB1 and diskgroup resource ora.DB1DATA.dg is established Fri Oct 30 10:05:36 2015 Network Resource Management enabled for Process LGWR (pid 30170) for Exadata I/O Successful mount of redo thread 1, with mount id 646597801 Fri Oct 30 10:05:36 2015 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Fri Oct 30 10:05:36 2015 ALTER DATABASE RECOVER database using backup controlfile until cancel Media Recovery Start Started logmerger process Fri Oct 30 10:05:36 2015 NOTE: ASMB mounting group 6 (DB1TEMP) NOTE: Assigning number (6,0) to disk (/dev/oracleasm/disks/TEMP) SUCCESS: mounted group 6 (DB1TEMP) NOTE: grp 6 disk 0: DB1TEMP_0000 path:/dev/oracleasm/disks/TEMP Fri Oct 30 10:05:36 2015 Starting background process TMON Fri Oct 30 10:05:36 2015 ARCH: STARTING ARCH PROCESSES Fri Oct 30 10:05:36 2015 TMON started with pid=32, OS id=30237 Starting background process ARC0 Fri Oct 30 10:05:36 2015 ARC0 started with pid=33, OS id=30239 Fri Oct 30 10:05:36 2015 NOTE: dependency between database TESTDB1 and diskgroup resource ora.DB1TEMP.dg is established Fri Oct 30 10:05:36 2015 ARC0: Archival started ARCH: STARTING ARCH PROCESSES COMPLETE Fri Oct 30 10:05:36 2015 ARC0: STARTING ARCH PROCESSES Starting background process ARC1 Starting background process ARC2 Fri Oct 30 10:05:36 2015 ARC1 started with pid=34, OS id=30241 Starting background process ARC3 Fri Oct 30 10:05:36 2015 ARC2 started with pid=35, OS id=30243 ARC1: Archival started ARC2: Archival started Fri Oct 30 10:05:36 2015 ARC2: Becoming the 'no FAL' ARCH ARC2: Becoming the 'no SRL' ARCH Fri Oct 30 10:05:36 2015 ARC3 started with pid=36, OS id=30245 Fri Oct 30 10:05:36 2015 ARC1: Becoming the heartbeat ARCH Fri Oct 30 10:05:36 2015 ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Fri Oct 30 10:05:36 2015 Parallel Media Recovery started with 2 slaves Fri Oct 30 10:05:37 2015 NOTE: ASMB mounting group 3 (DB1FRA) NOTE: Assigning number (3,0) to disk (/dev/oracleasm/disks/FRA1) NOTE: Assigning number (3,1) to disk (/dev/oracleasm/disks/FRA2) SUCCESS: mounted group 3 (DB1FRA) NOTE: grp 3 disk 0: DB1FRA_0000 path:/dev/oracleasm/disks/FRA1 NOTE: grp 3 disk 1: DB1FRA_0001 path:/dev/oracleasm/disks/FRA2 ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ... ALTER DATABASE RECOVER CONTINUE DEFAULT Fri Oct 30 10:05:37 2015 Media Recovery Log +DB1FRA/TESTDB1/ARCHIVELOG/2015_10_29/thread_1_seq_27.276.894380913 Fri Oct 30 10:05:37 2015 NOTE: dependency between database TESTDB1 and diskgroup resource ora.DB1FRA.dg is established ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ... ALTER DATABASE RECOVER CONTINUE DEFAULT Fri Oct 30 10:05:37 2015 Media Recovery Log +DB1FRA Fri Oct 30 10:05:37 2015 Errors with log +DB1FRA Fri Oct 30 10:05:37 2015 Errors in file /u01/app/oracle/diag/rdbms/testdb1/TESTDB1/trace/TESTDB1_pr00_30233.trc: ORA-00308: cannot open archived log '+DB1FRA' ORA-17503: ksfdopn:2 Failed to open file +DB1FRA ORA-15045: ASM file name '+DB1FRA' is not in reference form ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ... ALTER DATABASE RECOVER CANCEL Fri Oct 30 10:05:37 2015 Media Recovery Canceled Completed: ALTER DATABASE RECOVER CANCEL Fri Oct 30 10:05:37 2015 alter database open resetlogs RESETLOGS after incomplete recovery UNTIL CHANGE 1945150 time 10/29/2015 15:08:32 Fri Oct 30 10:05:37 2015 NOTE: ASMB mounting group 4 (DB1REDO1) NOTE: Assigning number (4,0) to disk (/dev/oracleasm/disks/REDO1) SUCCESS: mounted group 4 (DB1REDO1) NOTE: grp 4 disk 0: DB1REDO1_0000 path:/dev/oracleasm/disks/REDO1 NOTE: ASMB mounting group 5 (DB1REDO2) NOTE: Assigning number (5,0) to disk (/dev/oracleasm/disks/REDO2) SUCCESS: mounted group 5 (DB1REDO2) NOTE: grp 5 disk 0: DB1REDO2_0000 path:/dev/oracleasm/disks/REDO2 Fri Oct 30 10:05:37 2015 ARCH: Logfile 1 is wrong incarnation (0:1944824:10/30/2015 10:01:42 vs 0:1594143:10/23/2015 11:27:00) Fri Oct 30 10:05:37 2015 NOTE: dependency between database TESTDB1 and diskgroup resource ora.DB1REDO1.dg is established Fri Oct 30 10:05:37 2015 Clearing online redo logfile 1 +DB1REDO1/TESTDB1/ONLINELOG/group_1.258.894122235 Clearing online log 1 of thread 1 sequence number 27 Fri Oct 30 10:05:37 2015 NOTE: dependency between database TESTDB1 and diskgroup resource ora.DB1REDO2.dg is established Fri Oct 30 10:05:39 2015 Clearing online redo logfile 1 complete Resetting resetlogs activation ID 646004994 (0x26814102) Online log +DB1REDO1/TESTDB1/ONLINELOG/group_1.258.894122235: Thread 1 Group 1 was previously cleared Online log +DB1REDO2/TESTDB1/ONLINELOG/group_1.258.894122267: Thread 1 Group 1 was previously cleared Online log +DB1REDO1/TESTDB1/ONLINELOG/group_2.256.894121835: Thread 1 Group 2 was previously cleared Online log +DB1REDO2/TESTDB1/ONLINELOG/group_2.256.894121837: Thread 1 Group 2 was previously cleared Online log +DB1REDO1/TESTDB1/ONLINELOG/group_3.257.894121965: Thread 1 Group 3 was previously cleared Online log +DB1REDO2/TESTDB1/ONLINELOG/group_3.257.894121995: Thread 1 Group 3 was previously cleared Fri Oct 30 10:05:39 2015 Setting recovery target incarnation to 3 Fri Oct 30 10:05:40 2015 Ping without log force is disabled . Fri Oct 30 10:05:40 2015 Assigning activation ID 646597801 (0x268a4ca9) Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0: +DB1REDO1/TESTDB1/ONLINELOG/group_1.258.894122235 Current log# 1 seq# 1 mem# 1: +DB1REDO2/TESTDB1/ONLINELOG/group_1.258.894122267 Successful open of redo thread 1 Fri Oct 30 10:05:40 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Fri Oct 30 10:05:40 2015 Network Resource Management enabled for Process LG00 (pid 30174) for Exadata I/O Fri Oct 30 10:05:40 2015 SMON: enabling cache recovery Fri Oct 30 10:05:42 2015 [30267] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:251591324 end:251592334 diff:1010 ms (1.0 seconds) Dictionary check beginning Dictionary check complete Verifying minimum file header compatibility (11g) for tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Fri Oct 30 10:05:42 2015 SMON: enabling tx recovery Starting background process SMCO Fri Oct 30 10:05:42 2015 Database Characterset is AL32UTF8 Fri Oct 30 10:05:42 2015 SMCO started with pid=37, OS id=30271 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC Fri Oct 30 10:05:45 2015 AQPC started with pid=40, OS id=30284 LOGSTDBY: Validating controlfile with logical metadata LOGSTDBY: Validation complete Starting background process CJQ0 Fri Oct 30 10:05:47 2015 CJQ0 started with pid=46, OS id=30296 Completed: alter database open resetlogs Fri Oct 30 10:05:55 2015 Shared IO Pool defaulting to 32MB. Trying to get it from Buffer Cache for process 30190. =========================================================== Dumping current patch information =========================================================== No patches have been applied =========================================================== Fri Oct 30 10:05:56 2015 db_recovery_file_dest_size of 4560 MB is 10.33% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Fri Oct 30 10:06:36 2015 TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P431 (2129) VALUES LESS THAN (TO_DATE(' 2015-10-31 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P432 (2129) VALUES LESS THAN (TO_DATE(' 2015-10-31 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P435 (2128) VALUES LESS THAN (TO_DATE(' 2015-10-30 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))