From oracle-l-bounce@freelists.org Tue May 18 12:56:23 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i4IHu8L19430 for ; Tue, 18 May 2004 12:56:18 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i4IHtv619399 for ; Tue, 18 May 2004 12:56:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 644AF72C546; Tue, 18 May 2004 12:44:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12052-58; Tue, 18 May 2004 12:44:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0518472CBAA; Tue, 18 May 2004 12:44:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 18 May 2004 12:43:19 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4572572CFED for ; Tue, 18 May 2004 12:43:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11942-31 for ; Tue, 18 May 2004 12:43:18 -0500 (EST) Received: from web50804.mail.yahoo.com (web50804.mail.yahoo.com [206.190.38.113]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 1CB1F72D029 for ; Tue, 18 May 2004 12:43:13 -0500 (EST) Message-ID: <20040518174929.66174.qmail@web50804.mail.yahoo.com> Received: from [152.3.34.216] by web50804.mail.yahoo.com via HTTP; Tue, 18 May 2004 10:49:29 PDT Date: Tue, 18 May 2004 10:49:29 -0700 (PDT) From: Robert Pegram Subject: 8i Standby Problem To: oracle-l@freelists.org MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 824 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: pegramrg@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org OS: Solaris 8 Database: 8.1.7.4 - physical standby configuration: The primary database received "ARC2: Failed to archive log# 3 seq# 20878" messages, and would only allow internal connections. It appeared to be a problem archiving to the standby server (see sequence of events below). Why would the primary instance "freeze" if the standby was set up as optional? I have a tar opened with Oracle, but thought I would also ping the list. I also noticed the following errors in the standby alert log during the time of the problem. ============================================= Tue May 18 08:37:58 2004 WARNING: aiowait timed out 1 times WARNING: aiowait timed out 2 times WARNING: aiowait timed out 3 times WARNING: aiowait timed out 4 times WARNING: aiowait timed out 5 times WARNING: aiowait timed out 6 times WARNING: aiowait timed out 7 times WARNING: aiowait timed out 8 times WARNING: aiowait timed out 9 times WARNING: aiowait timed out 10 times WARNING: aiowait timed out 11 times WARNING: aiowait timed out 12 times WARNING: aiowait timed out 13 times Tue May 18 10:43:20 2004 ============================================= original init.ora parameters: log_archive_start = true log_archive_dest_1 = "location=/fs/local0/oraarch/XXXXXX/" log_archive_format = XXXXXX_%t_%s.arc log_archive_dest_2 = "SERVICE=XXXXXX_STDBY OPTIONAL REOPEN=300" log_archive_dest_state_2 = ENABLE log_archive_min_succeed_dest = 1 Sequence of events: 1. I got paged DB problems (of course the primary dba is not here today) 2. Noticed "unable to archive log" errors. 3. Plenty of space on primary server and standby server (archive destinations). 4. I can "touch" files in the archive dest (no permission problems) 5. Tried to bounce database - would not open - trying to archive log 20878. 6. Changed init.ora to point to a different file system - bounced database - same error. 7. Bounced server - same error. 8. Changed init.ora to comment out standby database info: #log_archive_dest_2 = "SERVICE=XXXXXX_STDBY OPTIONAL REOPEN=300" #log_archive_dest_state_2 = ENABLE #log_archive_min_succeed_dest = 1 9. Bounced database - all is ok. 10. Changed init.ora archive dest to orig location - bounced database - all is OK 11. I can manually scp files from the primary to standby server. I have a theory, but management wants a definite answer before we turn the standby back on. Thanks for your thoughts, Rob Pegram __________________________________ Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------