 Oracle Hot Backup Procedure [message #115630] |
Wed, 13 April 2005 05:19  |
nainkin
Messages: 1
Registered: April 2005
|
Junior Member |
|
|
Hi,
Can anyone detail the steps for me for doing a Oracle Hot Back and restore and to roll forward to current point in time.
I am using BrightStor's Arcserve v11.1.
I would like to restore to an alternate server with a differnet dirve letter path as well. This is a diasaster recovery scenario.
I have set up a database shell on new server with exact same SID.
What next... Have my backup on tape.. ?
Please assist
Thank you
|
|
|
|
| Re: Oracle Hot Backup Procedure [message #115651 is a reply to message #115630] |
Wed, 13 April 2005 08:17  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Can anyone detail the steps for me for doing a Oracle Hot Back and restore and to roll forward to current point in time.
Unfortunately that is beyond the scope of any forum.
I fear you need to spend some quality time in reading documentation.
http://www.oracle.com/pls/db92/db92.docindex?remark=homepage
the above URL takes you to oracle 9i docs.
Please look into Recovery Manager docs ( RMAN).
If you have any specifc questions / issues please post them with your oracle version, OS , exact error message etc.
The outline would be.
configure RMAN in catalog / nocatalog mode.
perform backup routinely.
Do maintainence on catalog / control file.
>>I am using BrightStor's Arcserve v11.1.
I am not aware of this particular product.
>>I would like to restore to an alternate server with a differnet dirve letter path as well. This is a diasaster recovery scenario.
It is possible with RMAN.
You backup your source datbase prod ( called TARGET ).
You those backupsets ( results of backup) to restore / recover the database to another machine( optionally point-in-time or part of database) . This is called duplication or cloning. we do it all times.
>>I have set up a database shell on new server with exact same SID.
>>What next... Have my backup on tape.. ?
This might be a different case with a simple solution.
If you already have the second Database all set(precreated the tablespaces / users as in firstDB) in another machine and volume of data in first database is low, you can just export the data from firstDB and import it back to secondDB.
Please look into export / import options
In documentation, UTILITIES manual provides all information regarding this.
This works great if the volume of data is Less ( oracle 10g has datapump, which is supposed to handle more volume). It just take a considerable time to export and into import because it a very serial process.
[Updated on: Wed, 13 April 2005 08:18] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
