Re: Something strange when full offline backup

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Thu, 8 Oct 1998 21:48:59 -0700
Message-ID: <6vk4ao$jjb@dfw-ixnews3.ix.netcom.com>

Yes, there is no problem at all, as long as all the current online redo log files are in place.

There is another situation where the timestamp of the datafile will be out of sync. When the tablespace is read-only, the timestamp of that datafile(s) will be different from the rest and that is perfectly okey in time of recovery too.

Winnie

Violin wrote in message <3627797b.10660682_at_news.twsc.pouchen.com.tw>...
>On Fri, 09 Oct 1998 02:37:22 GMT, violin.hsiao_at_mail.pouchen.com.tw
>(Violin) wrote:
>
>>I found the time of log1orcl.dbf is different from other files.
>>Here is the list of d:\backup:
>>
>>ctl1orcl.ora 230K 1998/10/8 PM 10:00
>>log1orcl.ora 200K 1998/10/8 PM 01:36
>>log2orcl.ora 200K 1998/10/8 PM 10:00
>>rbs1orcl.ora 5,122K 1998/10/8 PM 10:00
>>sys1orcl.ora 10,242K 1998/10/8 PM 10:00
>>sys2orcl.ora 30,722K 1998/10/8 PM 10:00
>>tmp1orcl.ora 7,170K 1998/10/8 PM 10:00
>>usr1orcl.ora 13,314K 1998/10/8 PM 10:00
>>usr2orcl.ora 102,402K 1998/10/8 PM 10:00
>>
>>Only log1orcl.ora update time is different.
>
> Did it because a log switch happen at pm 01:36
> from log1orcl.ora to log2.orcl?
> If YES,all files in d:\backup is OK for recovery,right?
>
> Violin.
Received on Thu Oct 08 1998 - 23:48:59 CDT