Backing up and Restoring/Recovering an Oracle 9i Database [message #239795] |
Wed, 23 May 2007 05:46 |
t.summerfield
Messages: 39 Registered: March 2007 Location: UK
|
Member |
|
|
I 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
|
|
|
|
|
|
|
Re: Backing up and Restoring/Recovering an Oracle 9i Database [message #240269 is a reply to message #240228] |
Thu, 24 May 2007 08:57 |
t.summerfield
Messages: 39 Registered: March 2007 Location: UK
|
Member |
|
|
I agree with your comment that you can't beat the more comprehensive documentation, but your blog is very useful for someone like myself with very little experience in this area.
So referring back to your blog, I have sucessfully followed it up to step 6. I am now stumped by a problem with step 7 (opening the database), When using the command alter database open it returns the following
ERROR at line 1:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: 'O:\BCS\INDX3.ORA'
I have tried locating the DBWR trace file, but have had no luck. Is it somewhere in the oraclehome directory under a different name?
Any help or thoughts you have on this would be greatly appreciated.
Regards
Toby
|
|
|
|