Q
Manage Learn to apply best practices and optimize your operations.

How to attach Oracle database backup files to existing server

My client provided backup files of the Oracle database. I know how to import from normal database backups (.dmp) but am still ignorant of attaching data files to the existing server.

I had asked my client to provide the backup of his Oracle database. He provided me the following files.
  1. WH1_DATA_01.ora
  2. WH1_INDEX_01.ora
  3. WH1_TEMPDATA_01.ora
I know how to import from normal database backups (.dmp) but am still ignorant of attaching data files to the existing server. It would be so nice if you can give me some direction on this.
The above files are not enough. The above are datafiles, but not all of the datafiles you need to start the database. Most importantly, you are missing the SYSTEM tablespace's datafile(s). Have your client do the following queries:
SELECT name FROM v$controlfile;
SELECT member FROM v$logfile;
SELECT file_name FROM dba_data_files;
The client should shut down their database and then copy all files returned from the three queries above. In addition, they should also send you the parameter file. You'll need all of these to get the database up and running.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close