I have a question concerning data restoration for you. I have just installed Oracle 9i (9.2.0) into a Windows XP 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'
This was first published in February 2006