Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: startup failed, ora-1122

Re: startup failed, ora-1122

From: yls177 <yls177_at_hotmail.com>
Date: 19 Nov 2003 05:10:17 -0800
Message-ID: <c06e4d68.0311190510.390ac44e@posting.google.com>


Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1069045373.994441_at_yasure>...
> yls177 wrote:
> > Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3FA6B567.2D3B647A_at_remove_spam.peasland.com>...
> >
> >>Did you restore your control file from a backup? The message is stating
> >>that your datafile and your control file are not in sync. More
> >>specifically, the control file is older than the datafile. You'll need
> >>to make sure that you recover your database, probably by recovering from
> >>this backup control file. But hopefully, you'll make sure that this is
> >>exactly what you want to do before proceeding.
> >>
> >>HTH,
> >>Brian
> >>
> >>yls177 wrote:
> >>
> >>>did a startup. got the below
> >>>
> >>>ORA-01122: database file 7 failed verification check
> >>>ORA-01110: data file 7: '/oracle/SID/data10/myfile/myfile.data1'
> >>>ORA-01207: file is more recent than controlfile - old controlfile
> >>>
> >>>select * from v$recover_file;
> >>>got 15 rows selected.
> >>>
> >>>what can i do to get it started up?
> >>
> >>
> >>--
> >>===================================================================
> >>
> >>Brian Peasland
> >>dba_at_remove_spam.peasland.com
> >>
> >>Remove the "remove_spam." from the email address to email me.
> >>
> >>
> >>"I can give it to you cheap, quick, and good. Now pick two out of
> >> the three"
> >
> >
> >
> >
> > this happened after my database was stopped suddenly.
> > and when i want to startup, i got these messgages
> >
> >
> > as follows from my alert file
> >
> > ORA-00600: internal error code, arguments: [4146], [16870], [16346],
> > [], [], [], [], []
> >
> > ORA-00600: internal error code, arguments: [4146], [29666], [29166],
> > [], [], [], [], []
> >
> > ORA-00600: internal error code, arguments: [4146], [14936], [14679],
> > [], [], [], [], []
> >
> > ORA-00600: internal error code, arguments: [4146], [32336], [31836],
> > [], [], [], [], []
> >
> > ORA-00600: internal error code, arguments: [12700], [38076],
> > [222350457], [2], [], [], [], []
> >
> > ORA-00600: internal error code, arguments: [12700], [38076],
> > [222350457], [2], [], [], [], []
> >
> > ORA-00600: internal error code, arguments: [4146], [29667], [28667],
> > [], [], [], [], []
> >
> > ORA-00600: internal error code, arguments: [4146], [14937], [14680],
> > [], [], [], [], []
> >
> > ORA-00600: internal error code, arguments: [12700], [72332],
> > [364929936], [97], [], [], [], []
>
> Open an iTAR.

too late ... the database instance went crashed...

when i want to startup, it prompt me for recovery.... didnt have chance for that as my colleague wiped out them...

its a test box.

but i was worried that the same scenario might happen to my production ones Received on Wed Nov 19 2003 - 07:10:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US