Q

Restoring DBF files

I have just installed Oracle 9i into a Windows XP Server. 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 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:

  1. Make the tablespace(s) READ ONLY.
  2. Verify the tablespace(s) is a self-contained set by running the DBMS_TTS.TRANSPORT_SET_CHECK supplied procedure.
  3. 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
    
  4. Copy the tablespace(s) datafiles and the dump file created above to the destination server.
  5. 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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close