You can edit the location of controlfile(s) directly in the pfile.
If you restored the spfile, you have to perform CREATE PFILE='...' FROM
SPFILE; once logged in, and then start the instance with the modified
pfile (you can create the new spfile later).
Mount the DB, and perform ALTER DATABASE RENAME FILE '...' TO '...'; for
both datafiles and logfiles.
Be careful about archived log parameters before using the db.

Maurizio Canali

-----Messaggio originale-----
Da: Yves
[mailto:oracledba-ezmlmshield-x92987415.[Email address protected]
Inviato: venerdì 3 giugno 2005 15:05
A: LazyDBA Discussion
Oggetto: Moving a saved instance


6 months ago I've created an test instance in 10g to convert our current
production database 8i. I've saved all files prior to importing the
data(so that I could redo it when the application was fully tested).

Since then, we've moved to a SAN and of course the directories are not
the same.

How can I restore this 'saved instance' and change the location of the
datafiles, redos, ... at the same time.


Merci / Thanks
Yves Leonard,
Chef de Projet / Project Leader,
DDS / SDD,
RH Coats, 13-I
Téléphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page