Urgent: Restore a database with the RMAN full backup of another database on disk
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Urgent: Restore a database with the RMAN full backup of another database on disk

Hybrid View

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    Urgent: Restore a database with the RMAN full backup of another database on disk

    DBAs.,

    I have an urgent task.
    The task is refresh the db2 with db1., who are on different box.
    The db2 was completely wiped off and in in nomount mode.

    Originally I used the following way to do:
    1) made a full backup of dbq1 to tape
    2) duplicate

    The problem is that the rman backup on tape of db1 cannot be accessed by db2.
    The UNIX admin needs to do something. But all of them are gone.

    The option left for me is :
    I1) I have a full rman backup of db1 on disk on the box where db1 resides

    Is the following method doable:
    1) ftp the disk rman backup of db1 to db2 box
    2) restore the db2 using the rman backup of db1

    If it is doable, would you please outline the procedure?

    If it is not donable, what is the best way for me to finish this task?

    Thank you very much!

    Lily

  2. #2
    Join Date
    Jan 2007
    Posts
    231
    Try this.,

    you can use ftp (or) scp

    eg:

    scp /mnt/db/disk1 orcl@ :/mnt/db/disk2

    Restore and recover the whole database
    RMAN> STARTUP FORCE MOUNT;
    RMAN> RESTORE DATABASE;
    RMAN> RECOVER DATABASE;
    RMAN> ALTER DATABASE OPEN;

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you say it doesnt work - but dont say what the error is

  4. #4
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Thanks for replies.

    The error message is as follows:

    ORA-19870: error reading backup piece FULL_MKEXQ_3mimfnu8
    ORA-19507: failed to retrieve sequential file, handle="FULL_MKEXQ_3mimfnu8", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: Error received from media manager layer, error text:
    Failed to process backup file
    ORA-19870: error reading backup piece FULL_MKEXQ_3kimfnu8
    ORA-19507: failed to retrieve sequential file, handle="FULL_MKEXQ_3kimfnu8", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: Error received from media manager layer, error text:
    Failed to process backup file
    ORA-19870: error reading backup piece FULL_MKEXQ_3limfnu8
    ORA-19507: failed to retrieve sequential file, handle="FULL_MKEXQ_3limfnu8", parms=""
    ORA-27029: skgfrtrv: sbtrestore returned error
    ORA-19511: Error received from media manager layer, error text:
    Failed to process backup file

  5. #5
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    My case is like this:

    1.Source db1 on client1, target db2 on client2, both use rman to backup to tape using netbackup, The netbackup sever is the same server.

    2.On source box the oracle OS owner is different from the target box.
    Here, using the ora as the oracle’s os users.

  6. #6
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    Anyone has the experience with using rman duplicate function to
    refresh one db to another db in new host with netbackup as media management?

    If so, would you please share the experience how to set up this
    whatever fom dba side or netbackup team side?

    Thanks,

    Lily

  7. #7
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    As long as you can connect to the target, catalog and auxiliary at the same time, the process is fairly straight forward.
    Assistance is Futile...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width