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

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close