Home » RDBMS Server » Backup & Recovery » Restore 10g database
Restore 10g database [message #197567] Wed, 11 October 2006 18:41 Go to next message
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 #197569 is a reply to message #197567] Wed, 11 October 2006 18:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>How do I do this?
Question is,
what kind of backup you have.
Obviously, you are talking about restoring the production database to a freeze/test database for auditing.
If you have your month-end backup as cold backup, just restore all the files.
If you use RMAN, do a point-in-time duplication.

>> What all files do I need from the backup?
Talk to your DBA.

Re: Restore 10g database [message #197720 is a reply to message #197569] Thu, 12 October 2006 07:21 Go to previous messageGo to next message
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
Mahesh Rajendran
Messages: 10672
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

Previous Topic: DB is very slow
Next Topic: Dropped System Scheam
Goto Forum:
  


Current Time: Sun Dec 11 06:07:06 CST 2016

Total time taken to generate the page: 0.08601 seconds