Oracle Agent of Veritas Netbackup 6.5

[Anish]

                     I am looking for information on How Oracle Agent of Veritas Netbackup 6.5 works? And how it is different over normal RMAN backup in oracle 10g. Pls share any good document where i can find these details.
Soon we are going to install and Veritas Netbackup Oracle agent on Oracle DB. If you know a good doucment of installing oracle agent in solaris 10 environment pls share that also.


IS anybody using this in your environment? How will be Backup window if i wanted to backup 4TB of data using oracle Agent?  

Your valuable inputs are higly appreciable in this regard.

Thanks & Regards,
Anish

[Marianne · Accepted solution]

The NBU agent simply provides a plugin to Oracle RMAN to do media management and centralized scheduling.
You still need to use RMAN.

Installation and configuration is explained in this NBU for Oracle manual:

ftp://exftpp.symantec.com/pub/support/products/NetBackup_Enterprise_Server/290216.pdf


Backup window / backup speed depends on a lot of things: network speed, client ability to generate data streams, disk I/O (to read datastreams),  RMAN tuning (number of channels, filesperset, etc.. etc....), etc...

[Anish]

Thanks Marianne 

I will go through this document if require any further help will post the details.

Thank you once Again!

Anish

[Anish]

Hi

I am trying to configure RMAN backup.

Followed below mentioned steps:

1. Created Backup policy on master server for RMAN backup--- Shell script path is mentioned in Backup selection.  And selected traget unit as LTO3 tape drive.

2. Shell script is prepared on client for RMAN backup

But still I am getting Error (6).

Sharing the script fyi:

ORACLE_HOME=/oracle/product/10.2.0/db_1
PATH=$ORACLE_HOME/bin:$PATH
ORACLE_SID=crm
export ORACLE_HOME PATH ORACLE_SID
rman << EOF

connect target sys/sys
run
{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
configure controlfile autobackup on;
configure controlfile autobackup format for device type 'SBT_TAPE' ;
backup database plus archivelog;
BACKUP CURRENT CONTROLFILE ;
release channel ch00;
}

EOF

The problem here is this script run with oracle login perfectly and failed when trying to tun through backup policy.

Also sharing logs i found in /usr/openv/netbackup/logs/bphdb

cat obk_stdout.090610

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Sep 6 14:31:07 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

RMAN>
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges

RMAN> 2> 3> 4> 5>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "clear, to"
RMAN-01007: at line 5 column 68 file: standard input

RMAN>

Starting backup at 06-SEP-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 09/06/2010 14:31:08
RMAN-06171: not connected to target database

RMAN>
Starting backup at 06-SEP-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/06/2010 14:31:08
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06171: not connected to target database

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: ch00
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 21 file: standard input

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 1 file: standard input

RMAN>
RMAN>

Recovery Manager complete.

and
cat log.090610
14:31:07.247 [22299] <2> logparams: -sb -rdbms oracle -S backupmaster -to 1500 -c ORACLE-RMAN -s Full -clnt backupmedia01 -FULL -kl 28 -b backupmedia01_1283763604 -jobid 21671
14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_POLICY=ORACLE-RMAN
14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_CLIENT=backupmedia01
14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_MODE=B
14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_POLICY=ORACLE-RMAN
14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_SCHED not defined.
14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_PC_SCHED=Full
14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_SERV=backupmaster
14:31:07.251 [22299] <4> bphdb main: INF - NB_ORA_PC_BTYPE not set
14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_FULL=1
14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_INCR=0
14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_CINC=0
14:31:07.251 [22299] <4> bphdb main: INF - setenv NB_ORA_SCHEDULED=1
14:31:07.252 [22299] <4> bphdb sync_server: INF - BACKUP START
14:31:07.319 [22299] <4> bphdb sync_server: INF - CONTINUE BACKUP message received.
14:31:07.319 [22299] <2> bphdb get_filelist: INF - Read filename: </oracle/script/FULLBKP-CRM.sh>
14:31:07.319 [22299] <2> bphdb get_filelist: INF - Read filename: <CONTINUE>
14:31:07.319 [22299] <4> bphdb do_backup: INF - Processing /oracle/script/FULLBKP-CRM.sh
14:31:07.322 [22299] <4> bphdb keepalive_timeout: INF - bphdb still working.
14:31:07.322 [22299] <2> bphdb keepalive_timeout: INF - bphdb- Sending a keepalive.
14:31:07.323 [22299] <4> bphdb do_backup: INF - Keepalives will be sent every 750 seconds.
14:31:07.323 [22299] <4> bphdb do_backup: INF - Waiting for the child status.
14:31:07.325 [22301] <4> bphdb do_backup: INF - Child executing /oracle/script/FULLBKP-CRM.sh
14:31:08.753 [22299] <16> bphdb do_backup: ERR - Script exited with status = 1 <the requested operation was partially successful>
14:31:08.765 [22299] <16> bphdb Exit: ERR - bphdb exit status = 6: the backup failed to back up the requested files
 

14:31:08.765 [22299] <4> bphdb Exit: INF - EXIT STATUS 6: the backup failed to back up the requested files

Pls post your valuable input.

Thanks & Regards,

[Andy_Welburn]

You should really start a new discussion for this as the original discussion was for info & has since been marked as solved.