Alert.log Analysis

For /home/oracle/rda_4.23/rda/NOD002/RDA_LOG_alert_log.txt

Processing Totals

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

Back to top

10 Shortest Redo Log Switch Times

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

Back to top

Alter System Commands

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

Back to top

Counts by Error

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

Back to top

Error Summary

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

Back to top

Trace Summary

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:

Back to top