Forum Discussion

raj555551's avatar
raj555551
Level 3
10 years ago

Oracle Backup and Restore parameters

Hi All,

Thanks for your support.....

We have netbackup as a backup tool.We have differenet rman backup policy.

Backup script contains below lines.I have doubt about parameters.

allocate channel ch1 type 'sbt_tape' parms='ENV=(NB_ORA_SERV=utsx45,NB_ORA_CLIENT=utsx19,NB_ORA_POLICY=utsx19_ALM_ora_hot,NB_ORA_SCHED=prod_weekly)';
allocate channel ch2 type 'sbt_tape' parms='ENV=(NB_ORA_SERV=utsx45,NB_ORA_CLIENT=utsx19,NB_ORA_POLICY=utsx19_ALM_ora_hot,NB_ORA_SCHED=prod_weekly)';

When we restore the backup,Should i mention all the above parameters or only one parameter ( NB_ORA_CLIENT ) is enough.

Thanks,

AIX
Backup and Recovery
NetBackup
  • Nicolai's avatar
    Nicolai
    10 years ago

    Take a look in the Netbackup Administrative guide page 121

    http://www.symantec.com/docs/DOC6481

    It say in step 2 :

    Do one of the following:
    ■ On UNIX, set the NB_ORA_CLIENT environment variable to the source client.
    ■ On Windows, use the rman parms option to set the NB_ORA_CLIENT environment variable to the source client.

    This mean you should do somthing like

    # NB_ORA_CLIENT=utsx19

    # export NB_ORA_CLIENT

     

  • Nicolai's avatar
    Nicolai
    Moderator
    10 years ago

    Take a look in the Netbackup Administrative guide page 121

    http://www.symantec.com/docs/DOC6481

    It say in step 2 :

    Do one of the following:
    ■ On UNIX, set the NB_ORA_CLIENT environment variable to the source client.
    ■ On Windows, use the rman parms option to set the NB_ORA_CLIENT environment variable to the source client.

    This mean you should do somthing like

    # NB_ORA_CLIENT=utsx19

    # export NB_ORA_CLIENT

     

  • raj555551's avatar
    raj555551
    Level 3
    10 years ago

    Hi,

    Thanks for your support,

     

    It's different server.

     

    Thanks

     

  • Marianne's avatar
    Marianne
    Level 6
    10 years ago

    I can cleary remember your 1st post in the NetBackup forum a week ago:

    Oracle Netbackup parameter 

    In the reply to your question, Nicolai referred you to the NBU for Oracle Admin Guide.

    I then added:
     For restores to a different Oracle host, look in same manual for 'Redirecting a restore to a different client'. 

    This question here tells me that you probably have not yet had a look at the manual, right?

    The answers are there.
    REALLY.