Oracle Backup/Restore with Backup Exec on separate servers

Posted on 2011-10-11
Medium Priority
Last Modified: 2012-06-22
I have install of oracle on windows 2008 on 2 servers (prod and test)

After running a full and increment backups from production, those files were moved to the test server.

Attempting to restore the prod backup using the backupexec at the test server, however in the selection of resources, the backup files/media are not visible; how do I apply the backup from one oracle instance to be restore on another oracle server (both server uses the same exact oracle sid and the oracle install are on the same exact drive letter in both location).
Question by:ITDeptAtPCS
  • 2
  • 2
LVL 29

Expert Comment

ID: 36955197

Please explain how you did the backup using backup exec?
Was it a "cold" backup (database shutdown)?
On what "media" did you create the backup files?


Author Comment

ID: 36955685
The backup was a hot backup (db is active) and uses backup-to-disk media that generated .bkf backup files to a local disk that is then copied to the test server.
LVL 29

Accepted Solution

MikeOM_DBA earned 1500 total points
ID: 36968091

Your backup may be unrecoverable if you did not set the database in "backup mode" before taking the backup with external (non-oracle) utility.

Perhaps it would be better to use "rman" to do a hot backup and then restore the database to another server or set database in backup mode and backup the files or do a cold backup.

Check out the fine Oracle® Database Backup and Recovery User's Guide for instructions on doing rman backups.

Good luck!


Author Comment

ID: 36981413
Thanks, the db was in "backup mode"; however the issue appears to be with backup exec itself not recognizing oracle files that is been restored if that db was not native to the location where the backup was taken. Basically, it would not it restore without an issue on the same prod server if it goes down, but not to another location.

We've been using native oracle backup and export to  manage the test env and would probably discard the usage of backup exec oracle agent. Would still like to keep backup exec oracle agent as a third option, possibly.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month15 days, 14 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question