Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 24956 invoked from network); 14 Jul 2007 20:45:01 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 14 Jul 2007 20:45:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B881712AEE; Sat, 14 Jul 2007 21:42:52 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25127-06; Sat, 14 Jul 2007 21:42:51 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 672D37129C0; Sat, 14 Jul 2007 21:42:51 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 14 Jul 2007 21:01:43 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 79D297127DA for ; Sat, 14 Jul 2007 21:01:43 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14040-06-2 for ; Sat, 14 Jul 2007 21:01:43 -0400 (EDT) Received: from smtp102.sbc.mail.re2.yahoo.com (smtp102.sbc.mail.re2.yahoo.com [68.142.229.103]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id DFD31712E91 for ; Sat, 14 Jul 2007 21:01:40 -0400 (EDT) Received: (qmail 92283 invoked from network); 15 Jul 2007 01:03:49 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:Reply-To:From:To:References:Subject:Date:Organization:Message-ID:MIME-Version:Content-Type:X-Mailer:In-Reply-To:X-MimeOLE:Thread-Index; b=trS/ydYwUHHiEoU1NEFC6S+/l3l5orDn/WfU5piAb1ci06x1g52ZjKKwPnCzeUNWfHk1flGoDEx0KQuOKl8ce+nD1HpFZQ6xo7SFm0WdpFYjtmt9R4EGvRNn4Lpxr8v5hzMxytnYFXEe8FxFpwyjLFQxs4JNW8S4Lulom+MdQ3w= ; Received: from unknown (HELO scraunch) (randyjo@sbcglobal.net@68.95.135.107 with login) by smtp102.sbc.mail.re2.yahoo.com with SMTP; 15 Jul 2007 01:03:48 -0000 X-YMail-OSG: RJxvp24VM1llv5Qabu1GYnnbuE8KMeLn736gzYLrWGuqILaaNaWo9A4m55Lv.37O3DC.3bh2Gu79OWREMjRaYtcbKjdVafKuk0JiUCcmPV1XqGL5KUsVUNYT6l615AUwY6ckfoMKrQhIni4- From: "Randy Johnson" To: References: <7091A5ABA356E04B8FA592067D78B53907774202@mail.alfredstate.edu> Subject: RE: Offline status in dictionary Date: Sat, 14 Jul 2007 20:03:45 -0500 Organization: Home Message-ID: <006a01c7c67b$fef20760$6701a8c0@scraunch> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006B_01C7C652.161E7060" In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-archive-position: 50885 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: randyjo@sbcglobal.net Precedence: normal Reply-to: randyjo@sbcglobal.net List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_NextPart_000_006B_01C7C652.161E7060 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable If it was missing when the database started up then that would cause the datafile to be offline. I would imagine that would include cases where = the database could not write to the datafile. I know this is true in 10g not sure about 9i. In 7 and I believe 8 & 8i the database would simply not = open but that behavior has changed in 10. =20 -Randy =20 =20 =20 Randy Johnson Sr. Technical Consultant Enkitec, LLP Office ..... 817-255-3580 Mobile .... 817-564-6583 Email ..... HYPERLINK "mailto:randy.johnson@enkitec.com"randy.johnson@enkitec.com=20 =20 _____ =20 From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ankur Godambe Sent: Friday, July 13, 2007 3:16 PM To: oracle-l@freelists.org Subject: Offline status in dictionary Hi, =20 Apart from explicitly putting datafile or tabespace in offline mode = though alter database=85.. or alter tablespace=85.. command , under what = circumstances would STATUS column in v$datafile and dba_tablespaces change to OFFLINE? =20 Thanks.=20 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.5/899 - Release Date: = 7/13/2007 3:41 PM No virus found in this outgoing message. Checked by AVG Free Edition.=20 Version: 7.5.476 / Virus Database: 269.10.5/899 - Release Date: = 7/13/2007 3:41 PM =20 ------=_NextPart_000_006B_01C7C652.161E7060 Content-Type: text/html; charset="windows-1250" Content-Transfer-Encoding: quoted-printable
If it was missing when the database started up = then that=20 would cause the datafile to be offline. I would imagine that would = include cases=20 where the database could not write to the datafile. I know this is true = in 10g=20 not sure about 9i. In 7 and I believe 8 & 8i the database would = simply not=20 open but that behavior has changed in 10.
 
    -Randy
 
 
 
Randy Johnson
Sr. = Technical=20 Consultant
Enkitec, LLP

Office ..... = 817-255-3580
Mobile=20 .... 817-564-6583
Email ..... randy.johnson@enkitec.com=20
 

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ankur=20 Godambe
Sent: Friday, July 13, 2007 3:16 PM
To:=20 oracle-l@freelists.org
Subject: Offline status in=20 dictionary

Hi,

 

Apart from = explicitly=20 putting datafile or tabespace in offline mode though alter = database….. or=20 alter tablespace….. command , under what circumstances would = STATUS column in=20 v$datafile and dba_tablespaces change to = OFFLINE?

 

Thanks.=20


No virus found in this incoming message.
Checked by = AVG Free=20 Edition.
Version: 7.5.476 / Virus Database: 269.10.5/899 - Release = Date:=20 7/13/2007 3:41 PM


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.5/899 - Release Date: = 7/13/2007 3:41 PM

------=_NextPart_000_006B_01C7C652.161E7060-- -- http://www.freelists.org/webpage/oracle-l