Backing up and Restoring/Recovering an Oracle 9i Database
568775May 23 2007 — edited May 24 2007I am fairly new at this and have been tasked with managing off site backups for customer data on a 9i database.
I am carrying out a user managed backup of the following data files to the offsite data centre.
User File
USERS01.DBF
Control File
CONTROL01.CTL
Redo Log Files
REDO01.LOG
REDO02.LOG
REDO03.LOG
Index File
INDX01.DBF
SPFile
SPFILEBCS.ORA
To test the success of the back up I have created a fresh install of 9i on a new machine with the file structure replicating that of the original.
My questions are;
1) Are these all the files required to be backed up in order to carry out a restore?
2) What are the steps that I need to carry out to restore/recover the database using the above files?
Any help or ‘user friendly’ resources for beginners would be greatly appreciated
Regards
Toby