Home » RDBMS Server » Backup & Recovery » re-store offline backup
re-store offline backup [message #326597] Thu, 12 June 2008 01:47 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Dear All,

I made a cold backup. The destination paths is not the same as production database. What shall I do with the control files?



Thank you,
Dirish
Re: re-store offline backup [message #326605 is a reply to message #326597] Thu, 12 June 2008 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recreate it.

Regards
Michel
Re: re-store offline backup [message #326613 is a reply to message #326605] Thu, 12 June 2008 02:09 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
1. re-store all the offline files, redo log files in new path

2. in old server ALTER DATABASE BACKUP CONTROLFILE TO TRACE

3. edit control file (with new paths, dbf, control, logfile) in new server (control.sql)

4. startup mount

5. @control.sql
Re: re-store offline backup [message #326622 is a reply to message #326613] Thu, 12 June 2008 02:18 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is a way to do it.

Regards
Michel
Previous Topic: Copy part of database to a new database
Next Topic: selective data transfer from old to new database
Goto Forum:
  


Current Time: Fri Dec 09 11:46:37 CST 2016

Total time taken to generate the page: 0.19519 seconds