Oracle Backup and Restore parameters

[raj555551]

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,

[RiaanBadenhorst]

If you're restoring to the same server you should not need any of the options.

[Nicolai · Accepted solution]

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]

Hi,

Thanks for your support,

It's different server.

Thanks

[Marianne]

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.