I have a question concerning data restoration for you. I have just installed Oracle 9i (9.2.0) into a Windows XP...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Server. Everything went smoothly so this is not an issue. I have to restore the DBF files. How am I going to restore the data to the database? Using RMAN? Actually these DBF files were copied from another XP server. I have stopped the Oracle services and zipped up the file and moved it to the new XP server. I have three copies of the control files and init.ora file.
I'm kind of stuck here so would really appreciate some form of help. Maybe you can give me some guidelines on how to restore the data? Many thanks.
How you restore the data all depends on how you backed it up. If you used RMAN to create your backup, then you will want to use RMAN to perform the restore.
It appears from your description that you just copied files from another database on another server. You cannot just copy a datafile from one database to another and access the data. For that, you'll have to use the Transportable Tablespace method, which involves a few extra steps:
- Make the tablespace(s) READ ONLY.
- Verify the tablespace(s) is a self-contained set by running the DBMS_TTS.TRANSPORT_SET_CHECK supplied procedure.
- Use the exp utility to create a metadata file describing the contents of the tablespace(s). The following is an example:
exp file=tts.dmp tablespaces=TS1,TS2 transport_tablespace=Y
- Copy the tablespace(s) datafiles and the dump file created above to the destination server.
- Plug in the tablespace with the imp utility similar to the following:
imp file=tts.dmp tablespaces=TS1,TS2 transport_tablespace=Y datafiles='/directory/file1','/directory/file2'
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.