Q
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close