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: 232
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

Report message to a moderator

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: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recreate it.

Regards
Michel

Report message to a moderator

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: 232
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

Report message to a moderator

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: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is a way to do it.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 15:46:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.