Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-00338: log 1 of thread 1 is more recent than controlfile.

Re: ORA-00338: log 1 of thread 1 is more recent than controlfile.

From: Yongping Yao <yaoyongping_at_gmail.com>
Date: Mon, 16 Jan 2006 20:53:49 +0800
Message-ID: <706468990601160453j7d1de339j9e716bbbef1200d2@mail.gmail.com>


Would you like to post your backup script here?

On 1/16/06, Prabhu, K <prabhu_adam_at_hotmail.com> 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'.
> ORA-00338: 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/

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 16 2006 - 06:54:02 CST

Original text of this message

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