1. You need to tell use whether you run the recover command after you restore before someone mucked the datafile? 2, Did you have backuped control before the "OPEN RESETLOGS" command, and did you record the exact RESETLOGS SCN, check the alert log file and find "RESETLOGS". 3, Are you running ARCHIVELOG mode and you have all the archive log files after you "OPEN RESETLOGS"?
On 11/15/05, J. Dex <cemail_219@(protected)> wrote: > > I have got a database that I cloned by copying a restore and then > recreating > the controlfile. It started up fine. After shutting it down, somebody > mucked with one of the database files at the OS level. Now, when I try to > start it up, it complains about that file so I shut it down and copied > once > again from the original backup the file that was messed with. Is there > anyway to save this database? These are the errors I am getting now. > > ORA-01190 (See ORA-01190.ora-code.com) controlfile or data file string is from before the last > RESETLOGS > Cause: An attempt was made to use a datafile when the log reset > information > in the file does not match the control file. Either the datafile or the > control file is > a backup that was made before the most recent ALTER DATABASE OPEN > RESETLOGS. > Action: Restore file from a more recent backup. > > ORA-01111 (See ORA-01111.ora-code.com) name for data file string is unknown - rename to correct file > Cause: The datafile was missing from a CREATE CONTROLFILE command or > BACKUP CONTROLFILE RECOVERY was done with a control file that was > saved before the file was created. > Action: Rename the MISSING file to the name of the real file. > > __ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __ > FREE pop-up blocking with the new MSN Toolbar ? get it now! > http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ > > -- > http://www.freelists.org/webpage/oracle-l > > >
-- Welcome! Home: http://www.anysql.net/en/
<div>1. You need to tell use whether you run the recover command after you restore before someone mucked the datafile?</div> <div>2, Did you have backuped control before the "OPEN RESETLOGS" command, and did you record the exact RESETLOGS SCN, check the alert log file and find "RESETLOGS".</div> <div>3, Are you running ARCHIVELOG mode and you have all the archive log files after you "OPEN RESETLOGS"?<br><br> </div> <div><span class="gmail_quote">On 11/15/05, <b class="gmail_sendername">J. Dex< /b> <<a href="mailto:cemail_219@(protected)">cemail_219@(protected)</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">I have got a database that I cloned by copying a restore and then recreating<br>the controlfile. It started up fine. After shutting it down, somebody <br>mucked with one of the database files at the OS level. Now, when I try to<br>start it up, it complains about that file so I shut it down and copied once<br>again from the original backup the file that was messed with. Is there <br>anyway to save this database? These are the errors I am getting now.<br><br>ORA-01190 (See ORA-01190.ora-code.com) controlfile or data file string is from before the last RESETLOGS<br>Cause: An attempt was made to use a datafile when the log reset information <br>in the file does not match the control file. Either the datafile or the<br >control file is<br>a backup that was made before the most recent ALTER DATABASE OPEN<br>RESETLOGS.<br>Action: Restore file from a more recent backup. <br><br>ORA-01111 (See ORA-01111.ora-code.com) name for data file string is unknown - rename to correct file <br>Cause: The datafile was missing from a CREATE CONTROLFILE command or<br >BACKUP CONTROLFILE RECOVERY was done with a control file that was<br> saved before the file was created.<br>Action: Rename the MISSING file to the name of the real file.<br><br>__ ____ ____ ____ ____ ____ ____ ____ ____ ______ __ ____ ____ ___<br>FREE pop-up blocking with the new MSN Toolbar ? get it now! <br><a href="http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/" >http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/</a><br><br>--<br> <a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org /webpage/oracle-l </a><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>Welcome!<br >Home: <a href="http://www.anysql.net/en/">http://www.anysql.net/en/</a>
