oracle_link script? I know that the libobk.so.1 library is linked from
$ORACLE_HOME/lib.
The real issue with rman/Oracle Agent for NetBackup not working was I had to
update and specifically supply the hostname on the master server. Although
the servers were both using DNS and both servers could resolve each others'
addresses, I was later informed that because of Oracle's agent needing to do
a reverse lookup, or maybe this is a function of Netbackup. Either way, I
got bogus errors or the script would simply hang and not run until I added
the client name and ip-address to the master/media server's hosts file.
Other side notes when getting this to work are that the
/usr/openv/netbackup/logs directories such as user_ops and dbclient need to
have permissions open so that the oracle user can write to these
directories.
It is also suggested that CLIENT_CONNECT_TIMEOUT and CLIENT_READ_TIMEOUT are
updated in the bp.conf on the master server. I know it is suggested to
increase these from the defaults and when you are dealing with a large
database it becomes more critical to increase these values. I also was
prompted to add the REQUIRED_INTERFACE to the bp.conf on the client's
bp.conf file because the client had multiple interfaces. I think the backup
would still work without this addtional setting, however.
Linking Oracle libraries didn't seem to make a difference. I noticed that
with different versions of Oracle that re-linking the libraries are
sometimes accomplished differently and there is a lot of data out there on
metalink and some on veritas' web site about linking the oracle libraries.
In our case this process neither helped nor hurt our backups.
The short of it is that a simple /etc/hosts file update corrected the
problem, even though both the servers could ping and resolve each other's
addresses through DNS. The key was that the bpclntcmd -pn resolved two
addresses the short and fully qualified name. The two addresses need to
match, and updating the hosts file accomplished that.
Dan Sixbury
-----Original Message-----
From: Jeffrey Barber
To: 'Sixbury, Dan'; 'veritas-bu AT mailman.eng.auburn DOT edu'
Cc: 'Darnold, Mike'
Sent: 6/22/01 11:55 PM
Subject: RE: [Veritas-bu] rman /Oracle NBU agent not working
Have you ran the oracle_link script that was put into the netbackup/bin
directory? The Netbackup AdminGuide for Oracle Unix states this script
needs to run. Also this pdf docuement explains how the format string in
the rman script needs to be unique.
Hope this helps a bit
-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[ mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu
<mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu> ]On Behalf Of Sixbury,
Dan
Sent: Wednesday, June 20, 2001 8:24 PM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Cc: Darnold, Mike
Subject: [Veritas-bu] rman /Oracle NBU agent not working
I have a 3.2 Solaris server running solaris 7. The oracle database and
repository are 8.1.6. We have installed the oracle agent for netbackup
version 3.2. on the master server and the database server.
We have been using the supplied backup scripts that come with Netbackup
and
modifying the necessary environment variables.
The problem is that although we have tested rman to disk, the backups to
tape are not working. I have linked the library libobk.so to
netbackups'
libobk.so.1 library. The errors are something to the effect of cannot
write
to sequential file.
** Oracle's metalink has a copy of information exactly related to my
error
message and points their finger at Veritas. ** Note below.
Any help would be much appreciated.
Thank you.
Dan
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19506: failed to create
sequential
file
, name="bk_21_1_424368445", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: sbtbackup: Failed to open for backup.
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECRE
ATE
From: Oracle, Helen Schoone 20-Mar-01 17:53
Subject: Re : RMAN - Failed to create sequential file
Hi. The key error is:
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: sbtbackup: Failed to open for backup.
NetBackup (sbtbackup) returned the error reported in the ORA-19511. At
this
point, you need to contact Veritas support for assistance in determining
why
the backup piece cannot be opened.
Other users of the forum who may have encountered similiar errors are
welcome to provide input.
Regards,
Helen
Oracle Support Services
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu>
|