Networker

Re: [Networker] Timestamps for recovered Oracle files?

2006-10-19 19:24:12
Subject: Re: [Networker] Timestamps for recovered Oracle files?
From: Darren Dunham <ddunham AT TAOS DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 19 Oct 2006 16:22:40 -0700
> 
> Hi,
> 
> We're using RMAN and NMO to test backup/recovery of an Oracle test database.
> I notice that when we use an RMAN script to recover data files, or even 
> the control file (we recover that to a different location), they
> all get recovered with the current time (i.e. the time of the recover) 
> and not their original times.
> Recovery of non_Oracle data, however, always preserves the original time 
> stamp.  I'm thinking the time SHOULD change when
> dealing with database files in order to keep things consistent? Maybe 
> this is reasonable and merely a function of Oracle, or is the NMO
> purposely doing this because it knows Oracle will want the current
> time?

Timestamps are associated with a file.  I don't think that information
is stored (or recovered) by RMAN.  Oracle does not require any timestamp
information in the file because it has its own information within the
data.

-- 
Darren Dunham                                           ddunham AT taos DOT com
Senior Technical Consultant         TAOS            http://www.taos.com/
Got some Dr Pepper?                           San Francisco, CA bay area
         < This line left intentionally blank to confuse you. >

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu 
if you have any problems
wit this list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER