Look in the alert log ane please tell me the solution for it..
Current log# 2 seq# 30254 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30255 (LGWR switch) Current log# 3 seq# 30255 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:05:50 2014 Thread 1 cannot allocate new log, sequence 30256 Checkpoint not complete Current log# 3 seq# 30255 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30256 (LGWR switch) Current log# 1 seq# 30256 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:06:41 2014 Thread 1 cannot allocate new log, sequence 30257 Checkpoint not complete Current log# 1 seq# 30256 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30257 (LGWR switch) Current log# 2 seq# 30257 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:07:33 2014 Thread 1 cannot allocate new log, sequence 30258 Checkpoint not complete Current log# 2 seq# 30257 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30258 (LGWR switch) Current log# 3 seq# 30258 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:08:24 2014 Thread 1 cannot allocate new log, sequence 30259 Checkpoint not complete Current log# 3 seq# 30258 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30259 (LGWR switch) Current log# 1 seq# 30259 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:09:15 2014 Thread 1 cannot allocate new log, sequence 30260 Checkpoint not complete Current log# 1 seq# 30259 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30260 (LGWR switch) Current log# 2 seq# 30260 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:10:06 2014 Thread 1 cannot allocate new log, sequence 30261 Checkpoint not complete Current log# 2 seq# 30260 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30261 (LGWR switch) Current log# 3 seq# 30261 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:10:54 2014 Thread 1 cannot allocate new log, sequence 30262 Checkpoint not complete Current log# 3 seq# 30261 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30262 (LGWR switch) Current log# 1 seq# 30262 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:11:45 2014 Thread 1 cannot allocate new log, sequence 30263 Checkpoint not complete Current log# 1 seq# 30262 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30263 (LGWR switch) Current log# 2 seq# 30263 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:12:33 2014 Thread 1 cannot allocate new log, sequence 30264 Checkpoint not complete Current log# 2 seq# 30263 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30264 (LGWR switch) Current log# 3 seq# 30264 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:13:24 2014 Thread 1 cannot allocate new log, sequence 30265 Checkpoint not complete Current log# 3 seq# 30264 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30265 (LGWR switch) Current log# 1 seq# 30265 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:14:15 2014 Thread 1 advanced to log sequence 30266 (LGWR switch) Current log# 2 seq# 30266 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:15:00 2014 Thread 1 cannot allocate new log, sequence 30267 Checkpoint not complete Current log# 2 seq# 30266 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30267 (LGWR switch) Current log# 3 seq# 30267 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:15:46 2014 Thread 1 cannot allocate new log, sequence 30268 Checkpoint not complete Current log# 3 seq# 30267 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30268 (LGWR switch) Current log# 1 seq# 30268 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 cannot allocate new log, sequence 30269 Checkpoint not complete Current log# 1 seq# 30268 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:16:03 2014 Thread 1 advanced to log sequence 30269 (LGWR switch) Current log# 2 seq# 30269 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 cannot allocate new log, sequence 30270 Checkpoint not complete Current log# 2 seq# 30269 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30270 (LGWR switch) Current log# 3 seq# 30270 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 cannot allocate new log, sequence 30271 Checkpoint not complete Current log# 3 seq# 30270 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:16:28 2014 Thread 1 advanced to log sequence 30271 (LGWR switch) Current log# 1 seq# 30271 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 cannot allocate new log, sequence 30272 Checkpoint not complete Current log# 1 seq# 30271 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30272 (LGWR switch) Current log# 2 seq# 30272 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 cannot allocate new log, sequence 30273 Checkpoint not complete Current log# 2 seq# 30272 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:16:46 2014 Thread 1 advanced to log sequence 30273 (LGWR switch) Current log# 3 seq# 30273 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 cannot allocate new log, sequence 30274 Checkpoint not complete Current log# 3 seq# 30273 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:18:16 2014 Thread 1 advanced to log sequence 30274 (LGWR switch) Current log# 1 seq# 30274 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:19:23 2014 Thread 1 cannot allocate new log, sequence 30275 Checkpoint not complete Current log# 1 seq# 30274 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:19:36 2014 Thread 1 advanced to log sequence 30275 (LGWR switch) Current log# 2 seq# 30275 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:19:55 2014 Thread 1 cannot allocate new log, sequence 30276 Checkpoint not complete Current log# 2 seq# 30275 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:20:15 2014 Thread 1 advanced to log sequence 30276 (LGWR switch) Current log# 3 seq# 30276 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:22:59 2014 Thread 1 cannot allocate new log, sequence 30277 Checkpoint not complete Current log# 3 seq# 30276 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:23:29 2014 Thread 1 advanced to log sequence 30277 (LGWR switch) Current log# 1 seq# 30277 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:23:45 2014 Thread 1 cannot allocate new log, sequence 30278 Checkpoint not complete Current log# 1 seq# 30277 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:25:21 2014 Thread 1 advanced to log sequence 30278 (LGWR switch) Current log# 2 seq# 30278 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:25:50 2014 Thread 1 cannot allocate new log, sequence 30279 Checkpoint not complete Current log# 2 seq# 30278 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:27:56 2014 Thread 1 advanced to log sequence 30279 (LGWR switch) Current log# 3 seq# 30279 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:28:47 2014 Thread 1 cannot allocate new log, sequence 30280 Checkpoint not complete Current log# 3 seq# 30279 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:30:29 2014 Thread 1 advanced to log sequence 30280 (LGWR switch) Current log# 1 seq# 30280 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:31:12 2014 Thread 1 cannot allocate new log, sequence 30281 Checkpoint not complete Current log# 1 seq# 30280 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:32:30 2014 Thread 1 advanced to log sequence 30281 (LGWR switch) Current log# 2 seq# 30281 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:34:16 2014 Thread 1 cannot allocate new log, sequence 30282 Checkpoint not complete Current log# 2 seq# 30281 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:35:58 2014 Thread 1 advanced to log sequence 30282 (LGWR switch) Current log# 3 seq# 30282 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:36:24 2014 Thread 1 cannot allocate new log, sequence 30283 Checkpoint not complete Current log# 3 seq# 30282 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:38:01 2014 Thread 1 advanced to log sequence 30283 (LGWR switch) Current log# 1 seq# 30283 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:42:20 2014 Thread 1 advanced to log sequence 30284 (LGWR switch) Current log# 2 seq# 30284 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:43:08 2014 Thread 1 advanced to log sequence 30285 (LGWR switch) Current log# 3 seq# 30285 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:43:59 2014 Thread 1 cannot allocate new log, sequence 30286 Checkpoint not complete Current log# 3 seq# 30285 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30286 (LGWR switch) Current log# 1 seq# 30286 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:44:50 2014 Thread 1 cannot allocate new log, sequence 30287 Checkpoint not complete Current log# 1 seq# 30286 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30287 (LGWR switch) Current log# 2 seq# 30287 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:45:41 2014 Thread 1 cannot allocate new log, sequence 30288 Checkpoint not complete Current log# 2 seq# 30287 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30288 (LGWR switch) Current log# 3 seq# 30288 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:46:32 2014 Thread 1 cannot allocate new log, sequence 30289 Checkpoint not complete Current log# 3 seq# 30288 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30289 (LGWR switch) Current log# 1 seq# 30289 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:47:23 2014 Thread 1 cannot allocate new log, sequence 30290 Checkpoint not complete Current log# 1 seq# 30289 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30290 (LGWR switch) Current log# 2 seq# 30290 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:48:14 2014 Thread 1 cannot allocate new log, sequence 30291 Checkpoint not complete Current log# 2 seq# 30290 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30291 (LGWR switch) Current log# 3 seq# 30291 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:49:05 2014 Thread 1 cannot allocate new log, sequence 30292 Checkpoint not complete Current log# 3 seq# 30291 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30292 (LGWR switch) Current log# 1 seq# 30292 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:49:56 2014 Thread 1 cannot allocate new log, sequence 30293 Checkpoint not complete Current log# 1 seq# 30292 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30293 (LGWR switch) Current log# 2 seq# 30293 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:50:50 2014 Thread 1 cannot allocate new log, sequence 30294 Checkpoint not complete Current log# 2 seq# 30293 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30294 (LGWR switch) Current log# 3 seq# 30294 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:51:38 2014 Thread 1 cannot allocate new log, sequence 30295 Checkpoint not complete Current log# 3 seq# 30294 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30295 (LGWR switch) Current log# 1 seq# 30295 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:52:26 2014 Thread 1 cannot allocate new log, sequence 30296 Checkpoint not complete Current log# 1 seq# 30295 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30296 (LGWR switch) Current log# 2 seq# 30296 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:53:14 2014 Thread 1 cannot allocate new log, sequence 30297 Checkpoint not complete Current log# 2 seq# 30296 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30297 (LGWR switch) Current log# 3 seq# 30297 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 08:54:02 2014 Thread 1 cannot allocate new log, sequence 30298 Checkpoint not complete Current log# 3 seq# 30297 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Thread 1 advanced to log sequence 30298 (LGWR switch) Current log# 1 seq# 30298 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Tue Dec 30 08:54:50 2014 Thread 1 cannot allocate new log, sequence 30299 Checkpoint not complete Current log# 1 seq# 30298 mem# 0: /u01/app/oracle/oradata/localhost/redo01.log Thread 1 advanced to log sequence 30299 (LGWR switch) Current log# 2 seq# 30299 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Tue Dec 30 08:55:38 2014 Thread 1 cannot allocate new log, sequence 30300 Checkpoint not complete Current log# 2 seq# 30299 mem# 0: /u01/app/oracle/oradata/localhost/redo02.log Thread 1 advanced to log sequence 30300 (LGWR switch) Current log# 3 seq# 30300 mem# 0: /u01/app/oracle/oradata/localhost/redo03.log Tue Dec 30 09:32:08 2014 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 =27 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/db_1/dbs/spfilelocalhost.ora System parameters with non-default values: processes = 150 memory_target = 1552M control_files = "/u01/app/oracle/oradata/localhost/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/localhost/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 undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "localdomain" dispatchers = "(PROTOCOL=TCP) (SERVICE=localhostXDB)" audit_file_dest = "/u01/app/oracle/admin/localhost/adump" audit_trail = "DB" db_name = "localhos" db_unique_name = "localhost" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Dec 30 09:32:10 2014 PMON started with pid=2, OS id=3565 Tue Dec 30 09:32:10 2014 VKTM started with pid=3, OS id=3567 at elevated priority Tue Dec 30 09:32:10 2014 GEN0 started with pid=4, OS id=3571 Tue Dec 30 09:32:10 2014 DIAG started with pid=5, OS id=3573 Tue Dec 30 09:32:10 2014 DBRM started with pid=6, OS id=3575 Tue Dec 30 09:32:10 2014 PSP0 started with pid=7, OS id=3577 Tue Dec 30 09:32:10 2014 DIA0 started with pid=8, OS id=3579 VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Dec 30 09:32:10 2014 MMAN started with pid=9, OS id=3581 Tue Dec 30 09:32:10 2014 DBW0 started with pid=10, OS id=3583 Tue Dec 30 09:32:10 2014 LGWR started with pid=11, OS id=3585 Tue Dec 30 09:32:10 2014 CKPT started with pid=12, OS id=3587 Tue Dec 30 09:32:10 2014 SMON started with pid=13, OS id=3589 Tue Dec 30 09:32:10 2014 RECO started with pid=14, OS id=3591 Tue Dec 30 09:32:10 2014 MMON started with pid=15, OS id=3593 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue Dec 30 09:32:10 2014 MMNL started with pid=16, OS id=3595 starting up 1 shared server(s) ... ORACLE_BASE from environment = /u01/app/oracle Tue Dec 30 09:32:11 2014 ALTER DATABASE MOUNT USER (ospid: 3606): terminating the instance Instance terminated by USER, pid = 3606 Tue Dec 30 09:34:56 2014 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 =27 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/db_1/dbs/spfilelocalhost.ora System parameters with non-default values: processes = 150 memory_target = 1552M control_files = "/u01/app/oracle/oradata/localhost/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/localhost/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 undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "localdomain" dispatchers = "(PROTOCOL=TCP) (SERVICE=localhostXDB)" audit_file_dest = "/u01/app/oracle/admin/localhost/adump" audit_trail = "DB" db_name = "localhos" db_unique_name = "localhost" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Dec 30 09:34:57 2014 PMON started with pid=2, OS id=3710 Tue Dec 30 09:34:57 2014 VKTM started with pid=3, OS id=3712 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Dec 30 09:34:57 2014 GEN0 started with pid=4, OS id=3716 Tue Dec 30 09:34:57 2014 DIAG started with pid=5, OS id=3718 Tue Dec 30 09:34:57 2014 DBRM started with pid=6, OS id=3720 Tue Dec 30 09:34:57 2014 PSP0 started with pid=7, OS id=3722 Tue Dec 30 09:34:57 2014 DIA0 started with pid=8, OS id=3724 Tue Dec 30 09:34:57 2014 MMAN started with pid=9, OS id=3726 Tue Dec 30 09:34:57 2014 DBW0 started with pid=10, OS id=3728 Tue Dec 30 09:34:57 2014 LGWR started with pid=11, OS id=3730 Tue Dec 30 09:34:57 2014 CKPT started with pid=12, OS id=3732 Tue Dec 30 09:34:57 2014 SMON started with pid=13, OS id=3734 Tue Dec 30 09:34:57 2014 RECO started with pid=14, OS id=3736 Tue Dec 30 09:34:57 2014 MMON started with pid=15, OS id=3738 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue Dec 30 09:34:57 2014 MMNL started with pid=16, OS id=3740 starting up 1 shared server(s) ... ORACLE_BASE from environment = /u01/app/oracle Tue Dec 30 09:34:57 2014 ALTER DATABASE MOUNT USER (ospid: 3746): terminating the instance Instance terminated by USER, pid = 3746 Tue Dec 30 09:40:16 2014 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 =27 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/db_1/dbs/spfilelocalhost.ora System parameters with non-default values: processes = 150 memory_target = 1552M control_files = "/u01/app/oracle/oradata/localhost/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/localhost/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 undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "localdomain" dispatchers = "(PROTOCOL=TCP) (SERVICE=localhostXDB)" audit_file_dest = "/u01/app/oracle/admin/localhost/adump" audit_trail = "DB" db_name = "localhos" db_unique_name = "localhost" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Dec 30 09:40:21 2014 PMON started with pid=2, OS id=3479 Tue Dec 30 09:40:21 2014 VKTM started with pid=3, OS id=3481 at elevated priority Tue Dec 30 09:40:21 2014 GEN0 started with pid=4, OS id=3485 VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Dec 30 09:40:21 2014 DIAG started with pid=5, OS id=3487 Tue Dec 30 09:40:21 2014 DBRM started with pid=6, OS id=3489 Tue Dec 30 09:40:21 2014 PSP0 started with pid=7, OS id=3491 Tue Dec 30 09:40:21 2014 DIA0 started with pid=8, OS id=3493 Tue Dec 30 09:40:21 2014 MMAN started with pid=9, OS id=3495 Tue Dec 30 09:40:21 2014 DBW0 started with pid=10, OS id=3497 Tue Dec 30 09:40:21 2014 LGWR started with pid=11, OS id=3499 Tue Dec 30 09:40:21 2014 CKPT started with pid=12, OS id=3501 Tue Dec 30 09:40:21 2014 SMON started with pid=13, OS id=3503 Tue Dec 30 09:40:21 2014 RECO started with pid=14, OS id=3505 Tue Dec 30 09:40:21 2014 MMON started with pid=15, OS id=3507 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue Dec 30 09:40:21 2014 MMNL started with pid=16, OS id=3509 starting up 1 shared server(s) ... ORACLE_BASE from environment = /u01/app/oracle Tue Dec 30 09:40:22 2014 ALTER DATABASE MOUNT USER (ospid: 3530): terminating the instance Instance terminated by USER, pid = 3530 Tue Dec 30 10:07:04 2014 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 =27 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/db_1/dbs/spfilelocalhost.ora System parameters with non-default values: processes = 150 memory_target = 1552M control_files = "/u01/app/oracle/oradata/localhost/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/localhost/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 undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "localdomain" dispatchers = "(PROTOCOL=TCP) (SERVICE=localhostXDB)" audit_file_dest = "/u01/app/oracle/admin/localhost/adump" audit_trail = "DB" db_name = "localhos" db_unique_name = "localhost" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Dec 30 10:07:05 2014 PMON started with pid=2, OS id=3794 Tue Dec 30 10:07:05 2014 VKTM started with pid=3, OS id=3796 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Dec 30 10:07:05 2014 GEN0 started with pid=4, OS id=3800 Tue Dec 30 10:07:05 2014 DIAG started with pid=5, OS id=3802 Tue Dec 30 10:07:05 2014 DBRM started with pid=6, OS id=3804 Tue Dec 30 10:07:05 2014 PSP0 started with pid=7, OS id=3806 Tue Dec 30 10:07:05 2014 DIA0 started with pid=8, OS id=3808 Tue Dec 30 10:07:05 2014 MMAN started with pid=9, OS id=3810 Tue Dec 30 10:07:05 2014 DBW0 started with pid=10, OS id=3812 Tue Dec 30 10:07:05 2014 LGWR started with pid=11, OS id=3814 Tue Dec 30 10:07:05 2014 CKPT started with pid=12, OS id=3816 Tue Dec 30 10:07:05 2014 SMON started with pid=13, OS id=3818 Tue Dec 30 10:07:05 2014 RECO started with pid=14, OS id=3820 Tue Dec 30 10:07:05 2014 MMON started with pid=15, OS id=3822 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue Dec 30 10:07:05 2014 MMNL started with pid=16, OS id=3824 starting up 1 shared server(s) ... ORACLE_BASE from environment = /u01/app/oracle Tue Dec 30 10:07:05 2014 ALTER DATABASE MOUNT USER (ospid: 3830): terminating the instance Instance terminated by USER, pid = 3830 Tue Dec 30 10:11:32 2014 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 =27 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/db_1/dbs/spfilelocalhost.ora System parameters with non-default values: processes = 150 memory_target = 1552M control_files = "/u01/app/oracle/oradata/localhost/control01.ctl" control_files = "/u01/app/oracle/flash_recovery_area/localhost/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 undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "localdomain" dispatchers = "(PROTOCOL=TCP) (SERVICE=localhostXDB)" audit_file_dest = "/u01/app/oracle/admin/localhost/adump" audit_trail = "DB" db_name = "localhos" db_unique_name = "localhost" open_cursors = 300 diagnostic_dest = "/u01/app/oracle" Tue Dec 30 10:11:33 2014 PMON started with pid=2, OS id=3964 Tue Dec 30 10:11:33 2014 VKTM started with pid=3, OS id=3966 at elevated priority VKTM running at (10)millisec precision with DBRM quantum (100)ms Tue Dec 30 10:11:33 2014 GEN0 started with pid=4, OS id=3970 Tue Dec 30 10:11:33 2014 DIAG started with pid=5, OS id=3972 Tue Dec 30 10:11:33 2014 DBRM started with pid=6, OS id=3974 Tue Dec 30 10:11:33 2014 PSP0 started with pid=7, OS id=3976 Tue Dec 30 10:11:33 2014 DIA0 started with pid=8, OS id=3978 Tue Dec 30 10:11:33 2014 MMAN started with pid=9, OS id=3980 Tue Dec 30 10:11:33 2014 DBW0 started with pid=10, OS id=3982 Tue Dec 30 10:11:33 2014 LGWR started with pid=11, OS id=3984 Tue Dec 30 10:11:33 2014 CKPT started with pid=12, OS id=3986 Tue Dec 30 10:11:33 2014 SMON started with pid=13, OS id=3988 Tue Dec 30 10:11:33 2014 RECO started with pid=14, OS id=3990 Tue Dec 30 10:11:33 2014 MMON started with pid=15, OS id=3992 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Tue Dec 30 10:11:33 2014 MMNL started with pid=16, OS id=3994 starting up 1 shared server(s) ... ORACLE_BASE from environment = /u01/app/oracle Tue Dec 30 10:11:33 2014 ALTER DATABASE MOUNT USER (ospid: 4000): terminating the instance Instance terminated by USER, pid = 4000
Aucun commentaire:
Enregistrer un commentaire