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
Related Q&A from Brian Peasland
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