On 1/16/06, Prabhu, K <prabhu_adam@(protected)> wrote: > > All, > > We're testing User-Managed Backups of the Whole Database. Oracle recomends > to make backups of all datafiles as well as all control files but not > online > redo log files. > > During our testing we backed up all the datafiles and control files and > restored those files after couple of startup/shutdowns. While starting up > the database with backup files oracle signals error 'ora-00338 (See ora-00338.ora-code.com)'. > ORA-00338 (See ORA-00338.ora-code.com): log 1 of thread 1 is more recent than controlfile. > Even recover database doesn't help us. > > Is there anything we missed out or do we need to take online redologs as > well in our consistent whole backup ? > > Thanks > > > -- > http://www.freelists.org/webpage/oracle-l > > >
-- Yao Yongping Learning Oracle, UNIX/Linux... Love Reading, Classical Music, Philosophy, Economics etc. Blog: http://spaces.msn.com/members/yaoyp/
Would you like to post your backup script here? <br><br><div><span class="gmail _quote">On 1/16/06, <b class="gmail_sendername">Prabhu, K</b> <<a href= "mailto:prabhu_adam@(protected)">prabhu_adam@(protected)</a>> wrote: </span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">All,<br><br>We're testing User-Managed Backups of the Whole Database. Oracle recomends <br>to make backups of all datafiles as well as all control files but not online<br>redo log files.<br><br>During our testing we backed up all the datafiles and control files and<br>restored those files after couple of startup /shutdowns. While starting up <br>the database with backup files oracle signals error 'ora-00338 (See ora-00338.ora-code.com)'.<br>ORA -00338: log 1 of thread 1 is more recent than controlfile.<br>Even recover database doesn't help us.<br><br>Is there anything we missed out or do we need to take online redologs as <br>well in our consistent whole backup ?<br><br>Thanks<br><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>Yao Yongping<br>Learning Oracle, UNIX/Linux...<br>Love Reading, Classical Music, Philosophy, Economics etc.<br>Blog: <a href="http:/ /spaces.msn.com/members/yaoyp/">http://spaces.msn.com/members/yaoyp/</a>
