Restore 10g database [message #197567] |
Wed, 11 October 2006 18:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jim20852
Messages: 2 Registered: October 2006
|
Junior Member |
|
|
We have 10g database on Redhat
I want to restore the database as of end of Aug 2006 for auditors.
We do have system backup files.
How do I do this? What all files do I need from the backup?
|
|
|
|
Re: Restore 10g database [message #197720 is a reply to message #197569] |
Thu, 12 October 2006 07:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jim20852
Messages: 2 Registered: October 2006
|
Junior Member |
|
|
Thanks for the reply Mahesh.
I am the DBA and has not done this earlier.
I know I have to get datafiles, log files and control files and init.ora.
Is there any file I am missing?
|
|
|
Re: Restore 10g database [message #197758 is a reply to message #197720] |
Thu, 12 October 2006 09:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
You still have not answered any of my questions.
It seems that you are using/having a cold backup.
In that case, get all the datafiles,logfiles, controlfiles , initsid etc ( in 10g, you must be using spfile.ora instead intsid.ora)
To do this, you also need a traced (textfile) controlfile ( using alter database backup control file to trace).
Please Search the board for cold copy.
You get many examples
[Updated on: Thu, 12 October 2006 09:50] Report message to a moderator
|
|
|