Home » RDBMS Server » Server Administration » closed backup restoration
closed backup restoration [message #249053] Tue, 03 July 2007 03:22 Go to next message
khawish
Messages: 12
Registered: May 2007
Junior Member

Hi,
I want to restore the database from closed bkup. Do have a look at the following
steps , are they good enough to restore successfully.. at last i want to apply the
archives , wht will be the solution.


1. Install Oracle Software on new server.
2. Create database with exact name which you have backed up from some
other Server (Optional).
3. If you have created a new database with exact name then shutdown the database.
4. copy all datafiles,online redo logs, control files (which you have
backuped up from othere server) to the newly created server in ORADATA
folder, you can delete existing files in that location which correnponds
to the new database which you have created.

5. copy spfile (if you backed up from previous database) to
$ORACLE_HOME/database folder and change parameter control_files if
needed.

6. startup mount the database.

7. rename data , online logs if the location is not same as it was in
previous server.

8. Open the database.

9. If you have not created database (as described in step 2) then you
will have to create a service via oradim.
10. create/copy parameter file to the new machine/server.
11. copy all datafile to the new server in the location which you want.
12. startup mount
13. rename datafiles,online redo logs if location is not the same as it
was in previous server.
14. open the database.


And that's all.

oradim -new -sid sid -startmode auto -pfile file


****************

suppose i take a close bkup of the database after shifting the db to archivelog mode.
now i want to restore the dbase after one week (let saY).. so wht i want to know is
when and where to apply the archvies of the database.. to get the full image until
last entry.

*******************
Re: closed backup restoration [message #249058 is a reply to message #249053] Tue, 03 July 2007 03:31 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://dbataj.blogspot.com/2007/03/shiftoracleserverfromonemachinetoanothe.html

Re: closed backup restoration [message #249177 is a reply to message #249058] Tue, 03 July 2007 10:20 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
suppose i take a close bkup of the database after shifting the db to archivelog mode.
now i want to restore the dbase after one week (let saY).. so wht i want to know is
when and where to apply the archvies of the database.. to get the full image until
last entry.



You cant apply archiveslog on cold backup.
Re: closed backup restoration [message #249199 is a reply to message #249053] Tue, 03 July 2007 11:05 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Note:271916.1 - How to roll forward after coldbackup
Previous Topic: Multi Language
Next Topic: Informix to Oracle conversion
Goto Forum:
  


Current Time: Sat Dec 10 12:55:00 CST 2016

Total time taken to generate the page: 0.09819 seconds