Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: startup failed, ora-1122
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"
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