Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: startup failed, ora-1122
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], [], [], [], [] Received on Sun Nov 16 2003 - 20:52:10 CST