04-19-2017 05:44 AM
Hi,
We're using OIP for our daily level0 backup which took approximately 3.5-4hrs. As per checking the log generated by the backup in the console, there was only one channel allocated. Is it possible to increase the channel used by OIP? Thank you
# ----------------------------------------------------------------- # RMAN command section # ----------------------------------------------------------------- RUN { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1'; SEND 'NB_ORA_CLIENT=proddb01.domain.com,NB_ORA_SID=PRODDB,NB_ORA_SERV=prodvnb.domain.com,NB_ORA_POLICY=PRODDB_PROD_DB_BKP,NB_ORA_PARENT_JOBID=42853,NB_ORA_SCHED=PRODDB_Daily_Full_Schedule'; BACKUP INCREMENTAL LEVEL=0 FORMAT 'bk_d%d_u%u_s%s_p%p_t%t' DATABASE; RELEASE CHANNEL ch00; # Backup Archived Logs sql 'alter system archive log current'; ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1'; SEND 'NB_ORA_CLIENT=proddb01.domain.com,NB_ORA_SID=PRODDB,NB_ORA_SERV=prodvnb.domain.com,NB_ORA_POLICY=PRODDB_PROD_DB_BKP,NB_ORA_PARENT_JOBID=42853,NB_ORA_SCHED=PRODDB_Daily_Full_Schedule'; BACKUP FORMAT 'arch_d%d_u%u_s%s_p%p_t%t' ARCHIVELOG ALL DELETE INPUT; RELEASE CHANNEL ch00; # Control file backup ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1'; SEND 'NB_ORA_CLIENT=proddb01.domain.com,NB_ORA_SID=PRODDB,NB_ORA_SERV=prodvnb.domain.com,NB_ORA_POLICY=PRODDB_PROD_DB_BKP,NB_ORA_PARENT_JOBID=42853,NB_ORA_SCHED=PRODDB_Daily_Full_Schedule'; BACKUP FORMAT 'ctrl_d%d_u%u_s%s_p%p_t%t' CURRENT CONTROLFILE; RELEASE CHANNEL ch00; }
Note: Apologies if this thread might appear duplicate. I've created same thread earlier but I can't find the original one. I'm not sure if I posted/created it successfully.
Solved! Go to Solution.
04-19-2017 05:56 AM
Increase the Number of parallel streams on the Oracle Tab
04-19-2017 05:56 AM
Increase the Number of parallel streams on the Oracle Tab
04-19-2017 07:35 AM
Hi Sir,
Thank you for the response. You mean the "Number of parallel streams"?
04-19-2017 07:38 AM
That is EXACTLY what Riaan said....
04-19-2017 08:02 AM
Thank you Marianne for the confirmation.. :)
04-21-2017 11:14 AM - edited 04-21-2017 11:15 AM
Thanks for the backup Marianne