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?
To perform a cold backup, I query V$DATAFILE for all of the database datafiles, V$CONTROLFILE for all of the control...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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