| Restore 10g database [message #197567] |
Wed, 11 October 2006 18:41  |
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  |
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 |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
