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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: