Ask the Expert

Trying to restore a hot backup

We are using ARCserve 2000 sp 4 with the Oracle backup agent. We are backing up an Oracle 8.1.7 database in "hot" or "online" backup mode. We are unable to restore that backup set to any node other than the one we created the backup from. We want to refresh a test environment with production data and because of the issue above, the only way we can do it at the moment is to shut down and do a cold backup of the database.

Any solutions greatly appreciated. Source node: Windows 2000 sp 2 cluster. Destination Node: Windows 2000 sp 2.


    Requires Free Membership to View

You should be able to restore a hot backup to another location. I'd have to see what the errors were to advise you more. The techniques in the Oracle backup chapter of Unix Backup & Recovery are actually quite helpful, even if this is a Windows environment.

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .bphAaR2qhqA^0@/searchstorage>discussion forums.


This was first published in November 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: