<!-- Oracle Remote Diagnostic Agent / Data Collection Results 4.23 -->
<!-- Module:S204LOG Version:2.07 Report:alert_sum OS:linux -->
---+!! Alert.log Analysis
---## For /home/oracle/rda_4.23/rda/output/RDA_LOG_alert_log.txt
%TOC%
---+ Processing Totals
|*Total alert.log records(lines) read*| 8569|
|*Start time*|27-Mar-2011&nbsp;14:48:53 |
|*End time*|14-Jun-2011&nbsp;02:55:21 |
|*Total instance startups encountered*| 43|
|*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*| 34|
|*Total ``Reconfiguration complete`` events found*| 34|
[[#Top][Back to top]]
---+ 10 Shortest Redo Log Switch Times
|*Event Time Stamp*|* Previous Event Time Stamp*| *Duration(seconds)*|
|02-Apr-2011&nbsp;23:50:45 |02-Apr-2011&nbsp;23:50:46 | 1|
|02-Apr-2011&nbsp;23:50:46 |02-Apr-2011&nbsp;23:50:47 | 1|
|02-Apr-2011&nbsp;23:50:49 |02-Apr-2011&nbsp;23:50:50 | 1|
|02-Apr-2011&nbsp;23:50:47 |02-Apr-2011&nbsp;23:50:49 | 2|
|27-Mar-2011&nbsp;16:18:39 |27-Mar-2011&nbsp;16:18:45 | 6|
|27-Mar-2011&nbsp;15:42:48 |27-Mar-2011&nbsp;15:43:01 | 13|
|27-Mar-2011&nbsp;15:35:35 |27-Mar-2011&nbsp;15:35:53 | 18|
|27-Mar-2011&nbsp;15:43:40 |27-Mar-2011&nbsp;15:44:04 | 24|
|04-Apr-2011&nbsp;09:13:43 |04-Apr-2011&nbsp;09:14:20 | 37|
|27-Mar-2011&nbsp;15:43:01 |27-Mar-2011&nbsp;15:43:40 | 39|
[[#Top][Back to top]]
---+ Alter System Commands
|*Time Stamp*|*Command*|
|27-Mar-2011&nbsp;15:33:41|ALTER SYSTEM ARCHIVE LOG|
|27-Mar-2011&nbsp;15:35:35|ALTER SYSTEM ARCHIVE LOG|
|27-Mar-2011&nbsp;15:35:53|ALTER SYSTEM ARCHIVE LOG|
|27-Mar-2011&nbsp;15:37:43|ALTER SYSTEM ARCHIVE LOG|
|27-Mar-2011&nbsp;15:38:14|ALTER SYSTEM SET db_recovery_file_dest_size='120G' SCOPE=BOTH;|
|27-Mar-2011&nbsp;15:39:56|ALTER SYSTEM SET db_recovery_file_dest='/dbpcardarch/pcard1/pcard' SCOPE=BOTH;|
|27-Mar-2011&nbsp;15:40:04|ALTER SYSTEM SET db_recovery_file_dest='/dbpcardarch/pcard1/pcard' SCOPE=BOTH;|
|27-Mar-2011&nbsp;15:42:43|ALTER SYSTEM SET db_recovery_file_dest='/dbpcardarch/pcard1' SCOPE=BOTH;|
|27-Mar-2011&nbsp;15:43:01|ALTER SYSTEM ARCHIVE LOG|
|27-Mar-2011&nbsp;15:44:04|ALTER SYSTEM ARCHIVE LOG|
|28-Mar-2011&nbsp;11:12:47|ALTER SYSTEM SET remote_listener='LISTENERS_PCARD' SCOPE=BOTH;|
|28-Mar-2011&nbsp;11:19:32|ALTER SYSTEM SET remote_listener='PCARD_LSNR' SCOPE=BOTH;|
|28-Mar-2011&nbsp;11:19:57|ALTER SYSTEM SET local_listener='PCARD_LSNR' SCOPE=BOTH;|
|29-Mar-2011&nbsp;02:00:03|ALTER SYSTEM ARCHIVE LOG|
|30-Mar-2011&nbsp;02:00:02|ALTER SYSTEM ARCHIVE LOG|
|30-Mar-2011&nbsp;14:17:41|ALTER SYSTEM ARCHIVE LOG|
|31-Mar-2011&nbsp;02:00:03|ALTER SYSTEM ARCHIVE LOG|
|01-Apr-2011&nbsp;02:00:02|ALTER SYSTEM ARCHIVE LOG|
|02-Apr-2011&nbsp;02:00:03|ALTER SYSTEM ARCHIVE LOG|
|02-Apr-2011&nbsp;23:13:08|ALTER SYSTEM SET fal_server='pcard' SCOPE=BOTH;|
|02-Apr-2011&nbsp;23:13:25|ALTER SYSTEM SET fal_client='PCARDDR' SCOPE=BOTH;|
|02-Apr-2011&nbsp;23:13:55|ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;|
|02-Apr-2011&nbsp;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&nbsp;23:47:19|ALTER SYSTEM SET log_archive_dest_1='LOCATION=/dbpcardarch/pcard1/PCARD/archivelog' SCOPE=BOTH;|
|02-Apr-2011&nbsp;23:52:10|ALTER SYSTEM SET fal_server='PCARD' SCOPE=BOTH;|
|03-Apr-2011&nbsp;00:16:31|ALTER SYSTEM ARCHIVE LOG|
|03-Apr-2011&nbsp;02:05:04|ALTER SYSTEM ARCHIVE LOG|
|04-Apr-2011&nbsp;09:14:20|ALTER SYSTEM ARCHIVE LOG|
|05-Apr-2011&nbsp;02:00:05|ALTER SYSTEM ARCHIVE LOG|
|06-Apr-2011&nbsp;02:00:06|ALTER SYSTEM ARCHIVE LOG|
|07-Apr-2011&nbsp;02:00:07|ALTER SYSTEM ARCHIVE LOG|
|08-Apr-2011&nbsp;02:00:10|ALTER SYSTEM ARCHIVE LOG|
|09-Apr-2011&nbsp;02:00:05|ALTER SYSTEM ARCHIVE LOG|
|09-Apr-2011&nbsp;07:37:39|ALTER SYSTEM SET log_archive_config='DG_CONFIG=(pcard,pcarddr)' SCOPE=BOTH;|
|10-Apr-2011&nbsp;02:04:11|ALTER SYSTEM ARCHIVE LOG|
|11-Apr-2011&nbsp;02:00:08|ALTER SYSTEM ARCHIVE LOG|
[[#Top][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|
[[#Top][Back to top]]
---+ Error Summary
|*First Occurrence*|*Last Occurrence*|*Count*|*Event*|
|27-Mar-2011&nbsp;14:48:53 |||Instance was restarted |
|27-Mar-2011&nbsp;14:55:46 |||ORA-279 signalled during: alter database recover if needed |
|27-Mar-2011&nbsp;14:56:04 |||ORA-00313: open failed for members of log group 1 of thread 1%BR%ORA-00312: online log 1 thread 1: '/pcard13/oradata/pcard/redopcard01.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:05 |||ORA-00313: open failed for members of log group 2 of thread 1%BR%ORA-00312: online log 2 thread 1: '/pcard14/oradata/pcard/redopcard02.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:06 |||ORA-00313: open failed for members of log group 3 of thread 1%BR%ORA-00312: online log 3 thread 1: '/pcard13/oradata/pcard/redopcard03.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:07 |||ORA-00313: open failed for members of log group 4 of thread 1%BR%ORA-00312: online log 4 thread 1: '/pcard14/oradata/pcard/redopcard04.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:08 |||ORA-00313: open failed for members of log group 5 of thread 1%BR%ORA-00312: online log 5 thread 1: '/pcard13/oradata/pcard/redopcard05.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:09 |||ORA-00313: open failed for members of log group 6 of thread 1%BR%ORA-00312: online log 6 thread 1: '/pcard14/oradata/pcard/redopcard06.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:10 |||ORA-00313: open failed for members of log group 7 of thread 1%BR%ORA-00312: online log 7 thread 1: '/pcard13/oradata/pcard/redopcard07.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:11 |||ORA-00313: open failed for members of log group 8 of thread 1%BR%ORA-00312: online log 8 thread 1: '/pcard14/oradata/pcard/redopcard08.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:12 |||ORA-00313: open failed for members of log group 9 of thread 1%BR%ORA-00312: online log 9 thread 1: '/pcard13/oradata/pcard/redopcard09.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:13 |||ORA-00313: open failed for members of log group 10 of thread 1%BR%ORA-00312: online log 10 thread 1: '/pcard14/oradata/pcard/redopcard10.log'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:21 |||ORA-01157: cannot identify/lock data file 201 - see DBWR trace file%BR%ORA-01110: data file 201: '/pcard02/oradata/pcard/pwrcrd_tmp01.dbf'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:21 |||ORA-01186: file 201 failed verification tests%BR%ORA-01157: cannot identify/lock data file 201 - see DBWR trace file%BR%ORA-01110: data file 201: '/pcard02/oradata/pcard/pwrcrd_tmp01.dbf' |
|27-Mar-2011&nbsp;14:56:21 |||ORA-01157: cannot identify/lock data file 202 - see DBWR trace file%BR%ORA-01110: data file 202: '/pcard02/oradata/pcard/pwrcrd_tmp02.dbf'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;14:56:21 |||ORA-01186: file 202 failed verification tests%BR%ORA-01157: cannot identify/lock data file 202 - see DBWR trace file%BR%ORA-01110: data file 202: '/pcard02/oradata/pcard/pwrcrd_tmp02.dbf' |
|27-Mar-2011&nbsp;14:58:32 |27-Mar-2011&nbsp;15:46:04 | 11|Instance was restarted |
|27-Mar-2011&nbsp;15:46:10 |||ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [1565], [], [], [], [], [], []%BR%ORA-01565: error in identifying file '/oracle/app/oracle/product/10.2.0/db_1/dbs/spfilepcard.ora'%BR%ORA-27037: unable to obtain file status%BR%Additional information: 3 |
|27-Mar-2011&nbsp;15:47:24 |02-Apr-2011&nbsp;02:41:17 | 8|Instance was restarted |
|02-Apr-2011&nbsp;23:15:56 |02-Apr-2011&nbsp;23:25:58 | 3|ORA-12514: TNS:listener does not currently know of service requested in connect descriptor |
|02-Apr-2011&nbsp;23:48:12 |||ORA-03135: connection lost contact |
|02-Apr-2011&nbsp;23:48:12 |||ORA-16055: FAL request rejected |
|03-Apr-2011&nbsp;00:10:32 |||ORA-03113: end-of-file on communication channel |
|03-Apr-2011&nbsp;00:10:33 |||ORA-16055: FAL request rejected |
|03-Apr-2011&nbsp;00:10:37 |||ORA-12537: TNS:connection closed |
|03-Apr-2011&nbsp;00:10:37 |||ORA-16055: FAL request rejected |
|03-Apr-2011&nbsp;00:10:41 |||ORA-12537: TNS:connection closed |
|03-Apr-2011&nbsp;00:10:41 |||ORA-16055: FAL request rejected |
|03-Apr-2011&nbsp;00:10:44 |||ORA-12537: TNS:connection closed |
|03-Apr-2011&nbsp;00:10:44 |||ORA-16055: FAL request rejected |
|03-Apr-2011&nbsp;00:10:46 |||ORA-12537: TNS:connection closed |
|03-Apr-2011&nbsp;00:10:46 |||ORA-16055: FAL request rejected |
|03-Apr-2011&nbsp;00:10:49 |||ORA-01034: ORACLE not available |
|03-Apr-2011&nbsp;00:10:49 |||ORA-16055: FAL request rejected |
|04-Apr-2011&nbsp;08:48:13 |09-Apr-2011&nbsp;06:35:36 | 3|Instance was restarted |
|09-Apr-2011&nbsp;09:01:13 |||ORA-16047: DGID mismatch between destination setting and standby |
|09-Apr-2011&nbsp;09:01:13 |||ORA-16055: FAL request rejected |
|09-Apr-2011&nbsp;09:06:55 |10-Apr-2011&nbsp;02:03:05 | 203|ORA-16047: DGID mismatch between destination setting and standby |
|10-Apr-2011&nbsp;23:55:47 |||Instance was restarted |
|10-Apr-2011&nbsp;23:56:56 |11-Apr-2011&nbsp;01:57:52 | 25|ORA-16047: DGID mismatch between destination setting and standby |
|14-Apr-2011&nbsp;10:11:49 |18-Apr-2011&nbsp;12:04:43 | 7|Instance was restarted |
|18-Apr-2011&nbsp;12:04:54 |||ORA-30012: undo tablespace 'UNDOTBS2' does not exist or of wrong type |
|18-Apr-2011&nbsp;12:04:54 |||ORA-1092 signalled during: ALTER DATABASE OPEN... |
|19-Apr-2011&nbsp;10:57:38 |04-May-2011&nbsp;21:00:08 | 11|Instance was restarted |
|04-May-2011&nbsp;21:00:25 |||ORA-00313: open failed for members of log group 1 of thread 1 |
|04-May-2011&nbsp;21:00:26 |||ORA-00313: open failed for members of log group 2 of thread 1 |
|04-May-2011&nbsp;21:00:26 |||ORA-00313: open failed for members of log group 3 of thread 1 |
|04-May-2011&nbsp;21:00:26 |||ORA-00313: open failed for members of log group 4 of thread 1 |
|04-May-2011&nbsp;21:00:26 |||ORA-00313: open failed for members of log group 5 of thread 1 |
|04-May-2011&nbsp;21:00:26 |||ORA-00313: open failed for members of log group 6 of thread 1 |
|04-May-2011&nbsp;21:00:26 |||ORA-00313: open failed for members of log group 7 of thread 1 |
|14-Jun-2011&nbsp;02:36:19 |||Instance was restarted |
[[#Top][Back to top]]
---+ Trace Summary
|*First Occurrence*|*Last Occurrence*|*Count*|*Event*|
|27-Mar-2011&nbsp;14:48:53 |||Instance was restarted |
|27-Mar-2011&nbsp;14:56:04 |27-Mar-2011&nbsp;14:56:13 | 10|Errors in file /pcard18/admin/pcard/udump/pcard_ora_18931.trc: |
|27-Mar-2011&nbsp;14:56:21 |27-Mar-2011&nbsp;14:56:21 | 4|Errors in file /pcard18/admin/pcard/bdump/pcard_dbw0_16849.trc: |
|27-Mar-2011&nbsp;14:58:32 |27-Mar-2011&nbsp;15:46:04 | 11|Instance was restarted |
|27-Mar-2011&nbsp;15:46:10 |||Errors in file /pcard18/admin/pcard/bdump/pcard_mmon_2726.trc: |
|27-Mar-2011&nbsp;15:47:24 |02-Apr-2011&nbsp;02:41:17 | 8|Instance was restarted |
|02-Apr-2011&nbsp;23:15:56 |03-Apr-2011&nbsp;00:10:49 | 17|Errors in file /pcard18/admin/pcard/bdump/pcard_arc1_12442.trc: |
|04-Apr-2011&nbsp;08:48:13 |09-Apr-2011&nbsp;06:35:36 | 3|Instance was restarted |
|09-Apr-2011&nbsp;09:01:13 |10-Apr-2011&nbsp;02:03:05 | 205|Errors in file /pcard18/admin/pcard/bdump/pcard_arc0_25833.trc: |
|10-Apr-2011&nbsp;23:55:47 |||Instance was restarted |
|10-Apr-2011&nbsp;23:56:56 |11-Apr-2011&nbsp;01:57:52 | 25|Errors in file /pcard18/admin/pcard/bdump/pcard_arc1_10827.trc: |
|14-Apr-2011&nbsp;10:11:49 |18-Apr-2011&nbsp;12:04:43 | 7|Instance was restarted |
|18-Apr-2011&nbsp;12:04:54 |||Errors in file /pcard18/admin/pcard/udump/pcard_ora_24226.trc: |
|19-Apr-2011&nbsp;10:57:38 |04-May-2011&nbsp;21:00:08 | 11|Instance was restarted |
|04-May-2011&nbsp;21:00:25 |04-May-2011&nbsp;21:00:26 | 7|Errors in file /pcard18/admin/pcard/bdump/pcard_lgwr_19996.trc: |
|14-Jun-2011&nbsp;02:36:19 |||Instance was restarted |
[[#Top][Back to top]]
