To find your control files, issue the following command:
SELECT name FROM v$controlfile;To find your online redo log files, issue the following command:
SELECT member FROM v$logfile;To find your database datafiles, issue the following command:
SELECT file_name FROM dba_data_files;The database must be opened for all of the above to run successfully, so perform these queries before you shut down the database.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.