cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Netbackup parameter

raj555551
Level 3

Hi All,

 

I am new bee to netbackup tool.

We have oracle databases 10g/11g on Unix ( Aix,Sun Solaris,HP Unix & Red hat ).

 

The below one is backup script.

run {
allocate channel ch1 type 'sbt_tape' parms='ENV=(NB_ORA_SERV=utsx73,NB_ORA_CLIENT=u365,NB_ORA_POLICY=u365_ANDP_ora_cold,NB_ORA_SCHED=prod_weekly)';
allocate channel ch2 type 'sbt_tape' parms='ENV=(NB_ORA_SERV=utsx73,NB_ORA_CLIENT=u365,NB_ORA_POLICY=u365_ANDP_ora_cold,NB_ORA_SCHED=prod_weekly)';
backup  incremental level 0 filesperset 10 database format 'inc0_%d_2014-11-08_20-59-47_s%s_p%p_t%t';
backup  current controlfile format 'ctl_%d_2014-11-08_20-59-47_s%s_p%p_t%t';
sql "create pfile=''/u01/app/oracle/admin/ANDP/backup/init_ANDP_2014-11-08_20-59-47'' from spfile";
sql "alter database backup controlfile to ''/u01/app/oracle/admin/ANDP/backup/controlfile_ANDP_2014-11-08_20-59-47''";
sql "alter database backup controlfile to trace as ''/u01/app/oracle/admin/ANDP/backup/cre_controlfile_ANDP_2014-11-08_20-59-47''";
release channel ch1;
release channel ch2;
}

Just i want to know the parameter  whar does it.

NB_ORA_POLICY=
NB_ORA_SCHED=
NB_ORA_CLIENT=
NB_ORA_SERV=
 

I am asked to start restoration from prod to test.

 

What information i have to include in rman script?

 

Thanks,

 

1 ACCEPTED SOLUTION

Accepted Solutions

Nicolai
Moderator
Moderator
Partner    VIP   

The parameters can be found in the NBU oracle guide - including restore instruction.

Symantec NetBackup 7.5 for Oracle Administrator's Guide

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

View solution in original post

3 REPLIES 3

CraigV
Moderator
Moderator
Partner    VIP    Accredited

...moved to the correct forum!

Thanks!

Nicolai
Moderator
Moderator
Partner    VIP   

The parameters can be found in the NBU oracle guide - including restore instruction.

Symantec NetBackup 7.5 for Oracle Administrator's Guide

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

Marianne
Level 6
Partner    VIP    Accredited Certified

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

If you are not the Oracle DBA - don't try to do this on your own.

I have shared my view of Oracle backup/restore over here:

NBU7.5 oracle RMAN backup integration prerquisites