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).