| create a database from offline backup [message #375759] |
Sun, 14 December 2008 04:39  |
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 #375762 is a reply to message #375759] |
Sun, 14 December 2008 05:16  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
