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

Home -> Community -> Usenet -> c.d.o.server -> ARCHIVE on Oracle 8.1.7.2

ARCHIVE on Oracle 8.1.7.2

From: Donna <dhoffman0917_at_yahoo.com>
Date: 17 Feb 2002 15:20:54 -0800
Message-ID: <79808a91.0202171520.296b73fb@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 Sun Feb 17 2002 - 17:20:54 CST

Original text of this message

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