Problem solve
Get help with specific problems with your technologies, process and projects.
What files need to be backed up under 9i for a cold backup?
What files need to be backed up under 9i for a cold backup?
What files need to be backed up under 9i for a cold backup? I believe they are all the V$datafiles. Should I also back up the control file and perform a trace of the control file and a copy of the init.ora and config.ora files located under the $ORACLE_HOME/dbs directory?
To perform a cold backup, I query V$DATAFILE for all of the database datafiles, V$CONTROLFILE for all of the control files and V$LOGFILE for all of the online redo log files. I also back up the parameter files as well as the password file. Optionally, I create a binary backup of the control file as well as dump the contents of the control file to a trace file as you have indicated above.
The only files you missed in your question are the online redo log files.
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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments