Oracle Backup/Restore with Backup Exec on separate servers

Posted on 2011-10-11
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
    LVL 29

    Expert Comment


    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?

    LVL 1

    Author Comment

    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


    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!

    LVL 1

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now