By
Published: 11 Apr 2007
I had asked my client to provide the backup of his Oracle database. He provided me the following files.
- WH1_DATA_01.ora
- WH1_INDEX_01.ora
- 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
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Continue Reading