Forum Discussion

Arshad_Khateeb's avatar
Arshad_Khateeb
Level 5
7 years ago

Oracle database restore fail

We are trying to restore oracle database from one server to another. It all starts well but this is where it stuck. Error bpbrm (pid=11257) cannot get server's peername on client rome_pres-bu Error...
  • Arshad_Khateeb's avatar
    Arshad_Khateeb
    7 years ago

    And here is the fix that worked.....

    After plenty of troubleshooting it was found that the DBA were not using same dbid as of source client in the restore script on destination client. Also the SID was incorrect. The restore is running smooth at the moment.

    The DBA is moving to Oracle 12c and proposing to do backups their own instead of using NetBackup so that they can have control on their own on backup/restore. They are little nervous with the restore issue but it's completely due to their poor script.

    What are the benefits of using NetBackup for Database backups (to tape/disk) against DBA doing their own? This will help me talk about NetBackup in our upcoming meeting with them.

Marianne's avatar
Marianne
Level 6

We are still waiting to see bprd log.... 

Arshad_Khateeb's avatar
Arshad_Khateeb
Level 5
7 years ago

And here is the fix that worked.....

After plenty of troubleshooting it was found that the DBA were not using same dbid as of source client in the restore script on destination client. Also the SID was incorrect. The restore is running smooth at the moment.

The DBA is moving to Oracle 12c and proposing to do backups their own instead of using NetBackup so that they can have control on their own on backup/restore. They are little nervous with the restore issue but it's completely due to their poor script.

What are the benefits of using NetBackup for Database backups (to tape/disk) against DBA doing their own? This will help me talk about NetBackup in our upcoming meeting with them.

  • Marianne's avatar
    Marianne
    Level 6
    7 years ago

    Please get proof of all these mistakes when you go into your meeting.
    We all agree that they are trying to blame NetBackup for their mess-ups.
    The outcome would be no different if they restored from disk backup.

    I guess with 'own backup' they want to use disk instead of NBU sbt_tape.

    My issues with that: 

    The additional space needed for this.
    The additional task to keep an eye on disk usage and manual cleanup of older backups.
    Backing up to disk followed by file-level backup to NBU will take twice as long.
    Scheduling becomes an issue as disk backup must be finished before file-level backup can start.
    If disk backup has been removed and restore from NBU is needed, the restore will take twice as long because of the 2-step process.

    Just one more thing - you really need to upgrade NBU.
    If anything goes wrong on NBU side, you cannot log Support calls with Veritas.
    As you have experienced, we do not have the time and in-depth experience to assist here on VOX.
    Highest level logs and insight into the Oracle side is needed, which we here on VOX simply do not have the time for.

    All the best for your meeting!

  • Arshad_Khateeb's avatar
    Arshad_Khateeb
    Level 5
    7 years ago

    thanks Marianne for your inputs. you are right, they don't want NetBackup as mediator between their database and backup target. they want to use rman to backup to disk.

    yesterday's restore surprised them with taking just 6hrs for approx 9TB with 4 channels running at a time. The reason we used 4 channels is due to the same number of channels are configured in rman backup script. so here is the question and we are planning to test,

    Question1-Does rman restore script need to have same number of channels as like rman backup script? If not then i think we can restore in less time.

    Question2( Includes 3 questions :) )-All channels completed but parent failed with status code 6. DBA find a successfull restore and applied archives. Failing parent restore job doesn't make any difference? Is it considered as success? Or should i try restore (as test) restore from another date?

    yeah, i have the notes what happended before. DBA were not even using dbid in the previous rman restore scripts.

    we may upgrade and have datadomain too.

  • Amol_Nair's avatar
    Amol_Nair
    Level 6
    7 years ago
    It is usually recommended to use the same number of channels while performing restore that was used at the time
    of backup.. If you increase or decrease the number of channels it would highly impact performance of the rman restores..

    Parent stream failure means that there was a non zero exit status returned from rman side after the child stream completed successfully some rman command that ran returned a failure.. dba need to check and tell which command reported an error.. could be some channel trying to search for some archive log sequence was the one that reported error..

    btw the main issue where uid and gid was not the same is kind of the pre-requisite for alternate client restore with rman.. If the dba does not want this then while taking backups they need to use “BKUP_IMAGE_PERM=ANY”

    With this parameter set the images backed up to nbu would kind of have 777 permission. this will not change the permissions on the existing oracle files. but would still kind of be a security breach because any user or group would get permission to go with the restore

    you can refer to the below link for details that can be used this variable
    https://www.veritas.com/support/en_US/doc/16226115-126559565-0/v33480652-126559565

    If the DBA wants his own command just like the way he would take a backup to disk to be implemented in the environment I could suggest the NBU copilot dump and sweep method.. This would give the DBA the choice to take rman backups to local disk and then nbu would also take a sbt_tape backup.. probably you could read through this and see if this could be implemented in your environment.. You do require nbu appliance inorder to configure copilot backups..