Question Locked

Oracle 9i Database Restore

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have been sent a collection of .ctl, .dbf and log files from an Oracle 9i database and would like to know how to get them up and running on the Oracle 9i database I have installed on my Windows XP Machine.

Any suggestion??

2 replies

by marv732

As you can not use these files directly in your current database.
If you can get the person who sent them to you to set up the datafiles as transportable tablespaces then you will be able to import them into your current database.
You may be able to set up the files as a new database (assuming they came from an XP machine). It would be easiest if you could setup a directory structure exactly the same as the original machine and place the files in their respective locations.
You would also have to setup your listener process and the Windows Service for the new database.
Oracle TechNet is a good reference ( http://www.oracle.com/technology ) and access is free.

Greg

This discussion is closed to new replies.