Oralce Rman restore database to different host

Posted on 2009-04-28
Last Modified: 2013-12-18
Need to restore current offline RMAN backup to new server/host.  New machine has the identical directory structure.  I have used "sftp" to transfer the RMAN backup sets to the new machine.  When attempting restore get errors complaining cannot read backup file, consequently it cannot create files on new machine.  Using this same technique I have tested RMAN backup and restore to same machine successfully.  
Question by:sdruss
    LVL 19

    Expert Comment

    are the permissions ok?

    did the file copy ok?
    LVL 1

    Author Comment

    Yes, all permissions are correct and it appears the "sftp" copy was successful.  I am getting this error:  

    ORA-19870:  error reading backup piece /tmp/database/ora99/GSxx_backup_Level0_7853911111.bus
    ORA-19504:  failed to create file "/xxxxx/xxxx/xxx/xx.dbf"
    LVL 19

    Accepted Solution


    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
    Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

    728 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

    17 Experts available now in Live!

    Get 1:1 Help Now