Re: Solaris 8 Question

Sam,
you may find that you need to issue "archive log stop" and "archive log start" to force the database to start archiving again. Once it's failed to archive a log it seems to lose heart and give up until you nudge it. Ironically the ARCHIVER will keep writing to the alert log to say that it's still trying. But it isn't. No doubt it's a feature. I've seen this on AIX, HP, Solaris, you name it.

Regards,
Mike Hately

|--------+------------------------>


|        |          Sam Roberts   |

|        |          <rabbit_at_emirat|

|        |          es.net.ae>    |

|        |                        |

|        |          07/24/01 04:05|

|        |          PM            |

|        |          Please respond|

|        |          to ORACLE-L   |

|        |                        |

|--------+------------------------>
  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  |
  |       cc:     (bcc: Mike Hately/ETECH)                                     |
  |       Subject:     Re: Solaris 8 Question                                  |
  >----------------------------------------------------------------------------|

This happened to me today: Solaris 5.8
we have a large data load exercise going on and the archive log directory filled - database stopped of course.
but after I had moved all the archive logs to another location the system still hung - I tried manual switching of log file ,still hung. I had to stop and start instance - I was surprised. did I miss something ?

sam

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: MHately_at_etech-uk.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).