Home » RDBMS Server » Backup & Recovery » create a database from offline backup (Oracle10g,Linux)
create a database from offline backup [message #375759] Sun, 14 December 2008 04:39 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I have taken offline backup from my database.
I have a restore this offline backup to newly created database.

How can resolve this sceanrio?

Please provides a steps

Thanks,
Michael.
Re: create a database from offline backup [message #375760 is a reply to message #375759] Sun, 14 December 2008 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't restore to a newly created database.
You restore the database you backed up.

Regards
Michel
Re: create a database from offline backup [message #375762 is a reply to message #375759] Sun, 14 December 2008 05:16 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I have searched detail regarding restore offline backup in a newly created database.

steps:

Oracle Database Migration
Two ways to move a database:
1. For a small database.
1. Do an Export.
2. Create a new empty database.
3. Do an Import.

2. For a large database (in the old system):
1. svrmgrl>alter database backup controlfile to trace.
2. Take a Cold Backup.
For a large database (in the new system):
3. Restore on the new system (all the datafiles and redo log files). Modified file name if necessary.
4. Create New initSID file.
5. Modify the trace file from step 1 to reflect changes in file names and change the database name if desired.
6. Set the ORACLE_SID to the new SID.
7. Run the sql from step 1
8. Open the database

I need more specfic points for s large database migration.

Thanks,
Michael
Re: create a database from offline backup [message #375771 is a reply to message #375762] Sun, 14 December 2008 06:08 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Way 1 is not a cold backup

What do you mean "I need more specfic points for s large database migration"? More specific than all the steps?

Regards
Michel
Previous Topic: Move the datafile to another database
Next Topic: USERS01.DBF issue
Goto Forum:
  


Current Time: Sat Dec 10 13:01:18 CST 2016

Total time taken to generate the page: 0.07183 seconds