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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
