| Total alert.log records(lines) read | 8369 |
|---|---|
| Start time | 27-Mar-2011 14:48:53 |
| End time | 04-May-2011 21:02:17 |
| Total instance startups encountered | 42 |
| Total log switches found | 63 |
Total Checkpoint not complete messages found |
0 |
Total Cannot allocate new log messages found |
0 |
Total IPC Send timeout messages found |
0 |
Total Reconfiguration started events found |
33 |
Total Reconfiguration complete events found |
33 |
| Event Time Stamp | Previous Event Time Stamp | Duration(seconds) |
|---|---|---|
| 02-Apr-2011 23:50:45 | 02-Apr-2011 23:50:46 | 1 |
| 02-Apr-2011 23:50:46 | 02-Apr-2011 23:50:47 | 1 |
| 02-Apr-2011 23:50:49 | 02-Apr-2011 23:50:50 | 1 |
| 02-Apr-2011 23:50:47 | 02-Apr-2011 23:50:49 | 2 |
| 27-Mar-2011 16:18:39 | 27-Mar-2011 16:18:45 | 6 |
| 27-Mar-2011 15:42:48 | 27-Mar-2011 15:43:01 | 13 |
| 27-Mar-2011 15:35:35 | 27-Mar-2011 15:35:53 | 18 |
| 27-Mar-2011 15:43:40 | 27-Mar-2011 15:44:04 | 24 |
| 04-Apr-2011 09:13:43 | 04-Apr-2011 09:14:20 | 37 |
| 27-Mar-2011 15:43:01 | 27-Mar-2011 15:43:40 | 39 |
| Time Stamp | Command |
|---|---|
| 27-Mar-2011 15:33:41 | ALTER SYSTEM ARCHIVE LOG |
| 27-Mar-2011 15:35:35 | ALTER SYSTEM ARCHIVE LOG |
| 27-Mar-2011 15:35:53 | ALTER SYSTEM ARCHIVE LOG |
| 27-Mar-2011 15:37:43 | ALTER SYSTEM ARCHIVE LOG |
| 27-Mar-2011 15:38:14 | ALTER SYSTEM SET db_recovery_file_dest_size='120G' SCOPE=BOTH; |
| 27-Mar-2011 15:39:56 | ALTER SYSTEM SET db_recovery_file_dest='/dbpcardarch/pcard1/pcard' SCOPE=BOTH; |
| 27-Mar-2011 15:40:04 | ALTER SYSTEM SET db_recovery_file_dest='/dbpcardarch/pcard1/pcard' SCOPE=BOTH; |
| 27-Mar-2011 15:42:43 | ALTER SYSTEM SET db_recovery_file_dest='/dbpcardarch/pcard1' SCOPE=BOTH; |
| 27-Mar-2011 15:43:01 | ALTER SYSTEM ARCHIVE LOG |
| 27-Mar-2011 15:44:04 | ALTER SYSTEM ARCHIVE LOG |
| 28-Mar-2011 11:12:47 | ALTER SYSTEM SET remote_listener='LISTENERS_PCARD' SCOPE=BOTH; |
| 28-Mar-2011 11:19:32 | ALTER SYSTEM SET remote_listener='PCARD_LSNR' SCOPE=BOTH; |
| 28-Mar-2011 11:19:57 | ALTER SYSTEM SET local_listener='PCARD_LSNR' SCOPE=BOTH; |
| 29-Mar-2011 02:00:03 | ALTER SYSTEM ARCHIVE LOG |
| 30-Mar-2011 02:00:02 | ALTER SYSTEM ARCHIVE LOG |
| 30-Mar-2011 14:17:41 | ALTER SYSTEM ARCHIVE LOG |
| 31-Mar-2011 02:00:03 | ALTER SYSTEM ARCHIVE LOG |
| 01-Apr-2011 02:00:02 | ALTER SYSTEM ARCHIVE LOG |
| 02-Apr-2011 02:00:03 | ALTER SYSTEM ARCHIVE LOG |
| 02-Apr-2011 23:13:08 | ALTER SYSTEM SET fal_server='pcard' SCOPE=BOTH; |
| 02-Apr-2011 23:13:25 | ALTER SYSTEM SET fal_client='PCARDDR' SCOPE=BOTH; |
| 02-Apr-2011 23:13:55 | ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH; |
| 02-Apr-2011 23:15:01 | ALTER SYSTEM SET log_archive_dest_2='service=pcarddr async db_unique_name=pcard valid_for=(primary_role,online_logfile)' SCOPE=BOTH; |
| 02-Apr-2011 23:47:19 | ALTER SYSTEM SET log_archive_dest_1='LOCATION=/dbpcardarch/pcard1/PCARD/archivelog' SCOPE=BOTH; |
| 02-Apr-2011 23:52:10 | ALTER SYSTEM SET fal_server='PCARD' SCOPE=BOTH; |
| 03-Apr-2011 00:16:31 | ALTER SYSTEM ARCHIVE LOG |
| 03-Apr-2011 02:05:04 | ALTER SYSTEM ARCHIVE LOG |
| 04-Apr-2011 09:14:20 | ALTER SYSTEM ARCHIVE LOG |
| 05-Apr-2011 02:00:05 | ALTER SYSTEM ARCHIVE LOG |
| 06-Apr-2011 02:00:06 | ALTER SYSTEM ARCHIVE LOG |
| 07-Apr-2011 02:00:07 | ALTER SYSTEM ARCHIVE LOG |
| 08-Apr-2011 02:00:10 | ALTER SYSTEM ARCHIVE LOG |
| 09-Apr-2011 02:00:05 | ALTER SYSTEM ARCHIVE LOG |
| 09-Apr-2011 07:37:39 | ALTER SYSTEM SET log_archive_config='DG_CONFIG=(pcard,pcarddr)' SCOPE=BOTH; |
| 10-Apr-2011 02:04:11 | ALTER SYSTEM ARCHIVE LOG |
| 11-Apr-2011 02:00:08 | ALTER SYSTEM ARCHIVE LOG |
| Error | Count | Error | Count | Error | Count |
|---|---|---|---|---|---|
| ORA-16047 | 229 | ORA-00313 | 17 | ORA-27037 | 13 |
| ORA-00312 | 10 | ORA-16055 | 8 | ORA-12537 | 4 |
| ORA-01157 | 4 | ORA-01110 | 4 | ORA-12514 | 3 |
| ORA-01186 | 2 | ORA-30012 | 1 | ORA-01565 | 1 |
| ORA-279 | 1 | ORA-03135 | 1 | ORA-03113 | 1 |
| ORA-00600 | 1 | ORA-01034 | 1 | ORA-1092 | 1 |
| First Occurrence | Last Occurrence | Count | Event |
|---|---|---|---|
| 27-Mar-2011 14:48:53 | Instance was restarted | ||
| 27-Mar-2011 14:55:46 | ORA-279 signalled during: alter database recover if needed | ||
| 27-Mar-2011 14:56:04 | ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/pcard13/oradata/pcard/redopcard01.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:05 | ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/pcard14/oradata/pcard/redopcard02.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:06 | ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/pcard13/oradata/pcard/redopcard03.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:07 | ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 4 thread 1: '/pcard14/oradata/pcard/redopcard04.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:08 | ORA-00313: open failed for members of log group 5 of thread 1 ORA-00312: online log 5 thread 1: '/pcard13/oradata/pcard/redopcard05.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:09 | ORA-00313: open failed for members of log group 6 of thread 1 ORA-00312: online log 6 thread 1: '/pcard14/oradata/pcard/redopcard06.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:10 | ORA-00313: open failed for members of log group 7 of thread 1 ORA-00312: online log 7 thread 1: '/pcard13/oradata/pcard/redopcard07.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:11 | ORA-00313: open failed for members of log group 8 of thread 1 ORA-00312: online log 8 thread 1: '/pcard14/oradata/pcard/redopcard08.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:12 | ORA-00313: open failed for members of log group 9 of thread 1 ORA-00312: online log 9 thread 1: '/pcard13/oradata/pcard/redopcard09.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:13 | ORA-00313: open failed for members of log group 10 of thread 1 ORA-00312: online log 10 thread 1: '/pcard14/oradata/pcard/redopcard10.log' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:21 | ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: '/pcard02/oradata/pcard/pwrcrd_tmp01.dbf' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:21 | ORA-01186: file 201 failed verification tests ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: '/pcard02/oradata/pcard/pwrcrd_tmp01.dbf' |
||
| 27-Mar-2011 14:56:21 | ORA-01157: cannot identify/lock data file 202 - see DBWR trace file ORA-01110: data file 202: '/pcard02/oradata/pcard/pwrcrd_tmp02.dbf' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 14:56:21 | ORA-01186: file 202 failed verification tests ORA-01157: cannot identify/lock data file 202 - see DBWR trace file ORA-01110: data file 202: '/pcard02/oradata/pcard/pwrcrd_tmp02.dbf' |
||
| 27-Mar-2011 14:58:32 | 27-Mar-2011 15:46:04 | 11 | Instance was restarted |
| 27-Mar-2011 15:46:10 | ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [1565], [], [], [], [], [], [] ORA-01565: error in identifying file '/oracle/app/oracle/product/10.2.0/db_1/dbs/spfilepcard.ora' ORA-27037: unable to obtain file status Additional information: 3 |
||
| 27-Mar-2011 15:47:24 | 02-Apr-2011 02:41:17 | 8 | Instance was restarted |
| 02-Apr-2011 23:15:56 | 02-Apr-2011 23:25:58 | 3 | ORA-12514: TNS:listener does not currently know of service requested in connect descriptor |
| 02-Apr-2011 23:48:12 | ORA-03135: connection lost contact | ||
| 02-Apr-2011 23:48:12 | ORA-16055: FAL request rejected | ||
| 03-Apr-2011 00:10:32 | ORA-03113: end-of-file on communication channel | ||
| 03-Apr-2011 00:10:33 | ORA-16055: FAL request rejected | ||
| 03-Apr-2011 00:10:37 | ORA-12537: TNS:connection closed | ||
| 03-Apr-2011 00:10:37 | ORA-16055: FAL request rejected | ||
| 03-Apr-2011 00:10:41 | ORA-12537: TNS:connection closed | ||
| 03-Apr-2011 00:10:41 | ORA-16055: FAL request rejected | ||
| 03-Apr-2011 00:10:44 | ORA-12537: TNS:connection closed | ||
| 03-Apr-2011 00:10:44 | ORA-16055: FAL request rejected | ||
| 03-Apr-2011 00:10:46 | ORA-12537: TNS:connection closed | ||
| 03-Apr-2011 00:10:46 | ORA-16055: FAL request rejected | ||
| 03-Apr-2011 00:10:49 | ORA-01034: ORACLE not available | ||
| 03-Apr-2011 00:10:49 | ORA-16055: FAL request rejected | ||
| 04-Apr-2011 08:48:13 | 09-Apr-2011 06:35:36 | 3 | Instance was restarted |
| 09-Apr-2011 09:01:13 | ORA-16047: DGID mismatch between destination setting and standby | ||
| 09-Apr-2011 09:01:13 | ORA-16055: FAL request rejected | ||
| 09-Apr-2011 09:06:55 | 10-Apr-2011 02:03:05 | 203 | ORA-16047: DGID mismatch between destination setting and standby |
| 10-Apr-2011 23:55:47 | Instance was restarted | ||
| 10-Apr-2011 23:56:56 | 11-Apr-2011 01:57:52 | 25 | ORA-16047: DGID mismatch between destination setting and standby |
| 14-Apr-2011 10:11:49 | 18-Apr-2011 12:04:43 | 7 | Instance was restarted |
| 18-Apr-2011 12:04:54 | ORA-30012: undo tablespace 'UNDOTBS2' does not exist or of wrong type | ||
| 18-Apr-2011 12:04:54 | ORA-1092 signalled during: ALTER DATABASE OPEN... | ||
| 19-Apr-2011 10:57:38 | 04-May-2011 21:00:08 | 11 | Instance was restarted |
| 04-May-2011 21:00:25 | ORA-00313: open failed for members of log group 1 of thread 1 | ||
| 04-May-2011 21:00:26 | ORA-00313: open failed for members of log group 2 of thread 1 | ||
| 04-May-2011 21:00:26 | ORA-00313: open failed for members of log group 3 of thread 1 | ||
| 04-May-2011 21:00:26 | ORA-00313: open failed for members of log group 4 of thread 1 | ||
| 04-May-2011 21:00:26 | ORA-00313: open failed for members of log group 5 of thread 1 | ||
| 04-May-2011 21:00:26 | ORA-00313: open failed for members of log group 6 of thread 1 | ||
| 04-May-2011 21:00:26 | ORA-00313: open failed for members of log group 7 of thread 1 | ||
| First Occurrence | Last Occurrence | Count | Event |
|---|---|---|---|
| 27-Mar-2011 14:48:53 | Instance was restarted | ||
| 27-Mar-2011 14:56:04 | 27-Mar-2011 14:56:13 | 10 | Errors in file /pcard18/admin/pcard/udump/pcard_ora_18931.trc: |
| 27-Mar-2011 14:56:21 | 27-Mar-2011 14:56:21 | 4 | Errors in file /pcard18/admin/pcard/bdump/pcard_dbw0_16849.trc: |
| 27-Mar-2011 14:58:32 | 27-Mar-2011 15:46:04 | 11 | Instance was restarted |
| 27-Mar-2011 15:46:10 | Errors in file /pcard18/admin/pcard/bdump/pcard_mmon_2726.trc: | ||
| 27-Mar-2011 15:47:24 | 02-Apr-2011 02:41:17 | 8 | Instance was restarted |
| 02-Apr-2011 23:15:56 | 03-Apr-2011 00:10:49 | 17 | Errors in file /pcard18/admin/pcard/bdump/pcard_arc1_12442.trc: |
| 04-Apr-2011 08:48:13 | 09-Apr-2011 06:35:36 | 3 | Instance was restarted |
| 09-Apr-2011 09:01:13 | 10-Apr-2011 02:03:05 | 205 | Errors in file /pcard18/admin/pcard/bdump/pcard_arc0_25833.trc: |
| 10-Apr-2011 23:55:47 | Instance was restarted | ||
| 10-Apr-2011 23:56:56 | 11-Apr-2011 01:57:52 | 25 | Errors in file /pcard18/admin/pcard/bdump/pcard_arc1_10827.trc: |
| 14-Apr-2011 10:11:49 | 18-Apr-2011 12:04:43 | 7 | Instance was restarted |
| 18-Apr-2011 12:04:54 | Errors in file /pcard18/admin/pcard/udump/pcard_ora_24226.trc: | ||
| 19-Apr-2011 10:57:38 | 04-May-2011 21:00:08 | 11 | Instance was restarted |
| 04-May-2011 21:00:25 | 04-May-2011 21:00:26 | 7 | Errors in file /pcard18/admin/pcard/bdump/pcard_lgwr_19996.trc: |