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.
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.