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: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 16 Nov 2003 21:02:31 -0800
Message-ID: <1069045373.994441@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.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Nov 16 2003 - 23:02:31 CST

Original text of this message

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