Re: ARCHIVE on Oracle 8.1.7.2

In your step 5), did u perform a "alter database rename file 'old_location' to 'new_location';" ?
And have u modify the control file, for it to contain the new locations of datafiles?
that's all I see to help you, in addition of what Mladen said!

Regards.

"Donna" <dhoffman0917_at_yahoo.com> a écrit dans le message news: 79808a91.0202171520.296b73fb_at_posting.google.com...
> What could cause a production datafile to request media
> recovery and apply *.arc logfiles after taking it offline
> to move it to a different disk?
>
> Steps and Results:
> 1) Took Hot Backup of production datafile;
> 2) Took production datafile offline; (Feb. 17)
> 3) Removed OS link used to point to old device location;
> 4) mv datafile to new location;
> 5) Created new link used to point to new device location;
> 6) alter database datafile '.......' ONLINE; (Did not need to
> change location in database because symbolic link path did
> not change in database)
> 7) ** At this point, database requested all archive logs from
> 3 days prior (Feb. 14) to current time (Feb. 17);
> 6) Second alternative was to restore datafile (from backup taken
> right before step 1, which would be current); But database
> still requested applied logs from Feb. 14(same as before);
>
> Can anyone suggest situations or parameter settings that could
> cause this?
>
> Thanks
Received on Mon Feb 18 2002 - 10:25:54 CST