Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gB6L4Z017942 for ; Fri, 6 Dec 2002 15:04:35 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gB6L4Y317935 for ; Fri, 6 Dec 2002 15:04:34 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA90614; Fri, 6 Dec 2002 09:46:03 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005148E3; Fri, 06 Dec 2002 08:59:48 -0800 Message-ID: Date: Fri, 06 Dec 2002 08:59:48 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Nick Wagner Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Nick Wagner Subject: RE: DB corruption question Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C29D48.EA21E050" ------_=_NextPart_001_01C29D48.EA21E050 Content-Type: text/plain; charset="iso-8859-1" This is more of a theoretical question, rather than an actual problem that happened. Let's assume the files were not copied, and there is no security at the site or on the disks themselves. -----Original Message----- Sent: Friday, December 06, 2002 5:20 AM To: Multiple recipients of list ORACLE-L Is it possible that the data files from the first database were copied to the second, but the control files did not get copied? > -----Original Message----- > From: wkhedr@attbi.com [mailto:wkhedr@attbi.com] > Sent: Thursday, December 05, 2002 5:05 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: DB corruption question > > > These errors are from the second database. It's normal to get them. > I do not think there is any corruptions. > > As long the first one is running without errors then do not worry. > > To make sure try to restart the database. > > Regards, > > Waleed > > Try, recreate the controlfile > > ----- Original Message ----- > > From: Nick Wagner > > To: Multiple recipients of list ORACLE-L > > Sent: Wednesday, December 04, 2002 10:09 PM > > Subject: DB corruption question > > > > > > > > With Oracle 8.1.7, Solaris 8 OS. > > > > I have a shared storage device for storing all my > datafiles, control files, > > redo logs, archive logs, etc.. everything except for the > ORACLE_HOME and Oracle > > binaries. > > > > If I have the file system and database mounted to one > machine, and have a > > fully open, available database running. What happens if > someone else tries to > > mount the same files to another machine and start up the > same database on it. > > (No OPS or RAC involved) > > > > I get the following error on the on the second machine... > > > > > > SVRMGR> ORACLE instance started. > > Total System Global Area 272359584 bytes > > Fixed Size 73888 bytes > > Variable Size 88678400 bytes > > Database Buffers 183427072 bytes > > Redo Buffers 180224 bytes > > Database mounted. > > SVRMGR> ORA-00283: recovery session canceled due to errors > > ORA-01122: database file 1 failed verification check > > ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' > > ORA-01207: file is more recent than controlfile - old controlfile > > SVRMGR> alter database open > > * > > ORA-01122: database file 1 failed verification check > > ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' > > ORA-01207: file is more recent than controlfile - old controlfile > > SVRMGR> Server Manager complete. > > EXITING 1 > > Unable to start Oracle instance > > > > Will this corrupt the database? Will it harm/corrupt the > original instance? > > What happens if someone tries to recover it at this point? > Does it make a > > difference whether its a RAW or cooked file system? > > > > Any help is appreciated! > > > > Nick > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: wkhedr@attbi.com > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: slee@dollar.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). ------_=_NextPart_001_01C29D48.EA21E050 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: DB corruption question

This is more of a theoretical question, rather than = an actual problem that happened.  Let's assume the files were not = copied, and there is no security at the site or on the disks = themselves. 

-----Original Message-----
From: Stephen Lee [mailto:slee@dollar.com]
Sent: Friday, December 06, 2002 5:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB corruption question



Is it possible that the data files from the first = database were copied to
the second, but the control files did not get = copied?

> -----Original Message-----
> From: wkhedr@attbi.com [mailto:wkhedr@attbi.com]
> Sent: Thursday, December 05, 2002 5:05 = PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: DB corruption question
>
>
> These errors are from the second database. It's = normal to get them.
> I do not think there is any corruptions.
>
> As long the first one is running without errors = then do not worry.
>
> To make sure try to restart the = database.
>
> Regards,
>
> Waleed
> > Try, recreate the controlfile
> >   ----- Original Message ----- =
> >   From: Nick Wagner
> >   To: Multiple recipients of = list ORACLE-L
> >   Sent: Wednesday, December 04, = 2002 10:09 PM
> >   Subject: DB corruption = question
> >
> >
> >
> >   With Oracle 8.1.7, Solaris 8 = OS. 
> >
> >   I have a shared storage device = for storing all my
> datafiles, control files,
> > redo logs, archive logs, etc..  = everything except for the
> ORACLE_HOME and Oracle
> > binaries. 
> >
> >   If I have the file system and = database mounted to one
> machine, and have a
> > fully open, available database = running.  What happens if
> someone else tries to
> > mount the same files to another machine = and start up the
> same database on it.
> > (No OPS or RAC involved)
> >
> >   I get the following error on = the on the second machine...
> >
> >
> >   SVRMGR> ORACLE instance = started.
> >   Total System Global Area = 272359584 bytes
> >   Fixed Size 73888 bytes
> >   Variable Size 88678400 = bytes
> >   Database Buffers 183427072 = bytes
> >   Redo Buffers 180224 = bytes
> >   Database mounted.
> >   SVRMGR> ORA-00283: recovery = session canceled due to errors
> >   ORA-01122: database file 1 = failed verification check
> >   ORA-01110: data file 1: = '/fs1/oradata/db1/system01_raw.dbf'
> >   ORA-01207: file is more recent = than controlfile - old controlfile
> >   SVRMGR> alter database = open
> >   *
> >   ORA-01122: database file 1 = failed verification check
> >   ORA-01110: data file 1: = '/fs1/oradata/db1/system01_raw.dbf'
> >   ORA-01207: file is more recent = than controlfile - old controlfile
> >   SVRMGR> Server Manager = complete.
> >   EXITING 1
> >   Unable to start Oracle = instance
> >
> >   Will this corrupt the = database?  Will it harm/corrupt the
> original instance?  
> > What happens if someone tries to recover = it at this point? 
> Does it make a
> > difference whether its a RAW or cooked = file system?
> >
> >   Any help is appreciated! =
> >
> >   Nick
> >
> >
> >
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: wkhedr@attbi.com
>
> Fat City Network Services    -- = 858-538-5051 http://www.fatcity.com
> San Diego, = California        -- Mailing list = and web hosting services
> = ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send = an E-Mail message
> to: ListGuru@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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
  INET: slee@dollar.com

Fat City Network Services    -- = 858-538-5051 http://www.fatcity.com
San Diego, = California        -- Mailing list = and web hosting services
---------------------------------------------------------------= ------
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@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).

------_=_NextPart_001_01C29D48.EA21E050-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nick Wagner INET: Nick.Wagner@quest.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).