This is a multi-part message in MIME format.
------=_NextPart_000_0015_01C5D4E4.40C547F0
Content-Type: text/plain;
charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable
-----Original Message-----
From: Mike L. Varney [mailto:mlv03 AT healthresearch DOT org]=20
Sent: Wednesday, October 19, 2005 7:33 PM
To: Asiye.Yigit AT gantek DOT com
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Sybase backup error
We can take this iscussion off-list. But the error is in your
syb_MNANOMC1_dump SQL script - - you're referring to a database in your
Sybase server that doesn't exist.
If you need more help, you can email me that script directly and we'll
continue this discussion off-list.
-- M
=20
Asiye Yi=F0it
<Asiye.Yigit@gant
ek.com>
To=20
Sent by: "'Mike L. Varney'"
veritas-bu-admin@ <mlv03 AT healthresearch DOT org>
mailman.eng.aubur
cc=20
n.edu
<veritas-bu AT mailman.eng.auburn DOT edu>=20
=20
Subject=20
RE: [Veritas-bu] Sybase backup
10/19/2005 12:24 error
PM
=20
=20
Please respond to
<Asiye.Yigit@gant
ek.com>
=20
=20
Hi Mike,
We are all confused about the namse???
In the script file,
SYBSERVER=3DMNANOMC1 <------------ what should it be? How can I verify
the name?
DATABASE_NAME=3DMNANOMC1 <-------------what should it be? How can I =
verify
the name?
-----Original Message-----
From: Mike L. Varney [mailto:mlv03 AT healthresearch DOT org]
Sent: Wednesday, October 19, 2005 7:16 PM
To: Asiye.Yigit AT gantek DOT com
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Sybase backup error
My apologies... I misread the error.
It's complaining that you're telling it to use a database that doesn't
exist. Check your "syb_MNANOMC1_dump" file for the "use" command and
make sure you're specifying a database name and not the server name.
You can email me that syb_MNANOMC1_dump file if you'd like and I can
look at it.
-- M
Asiye Yi=F0it
<Asiye.Yigit@gant
ek.com>
To
"'Mike L. Varney'"
10/19/2005 12:11 <mlv03 AT healthresearch DOT org>
PM
cc
<veritas-bu AT mailman.eng.auburn DOT edu>
Subject
Please respond to RE: [Veritas-bu] Sybase backup
<Asiye.Yigit@gant error
ek.com>
Hi mike,
It seems to be okay.
The value in the interfaces file is MNANOMC1.
Regards,
Asiye
-----Original Message-----
From: Mike L. Varney [mailto:mlv03 AT healthresearch DOT org]
Sent: Wednesday, October 19, 2005 7:01 PM
To: Asiye.Yigit AT gantek DOT com
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Sybase backup error
On the command line of your ISQL session:
/opt/sybase/OCS-12_0/bin/isql -Uxxxxxxxx -Pxxxxxxxx
-I/opt/sybase/interfaces -SMNANOMC1 < ./syb_MNANOMC1_dump Msg 911, Level
11, State 2: Server 'MNANOMC1', Line 1: Attempt to locate entry in
sysdatabases for database 'MNANOMC1' by name failed - no entry found
under that name. Make sure that name is entered properly.
-SMNANOMC1 is where you're telling ISQL to connect to MNANOMC1. That
has to match what you have in the interfaces file, including case
sensitivity.
-- M
Asiye Yi=F0it
<Asiye.Yigit@gant
ek.com>
To
"'Mike L. Varney'"
10/19/2005 11:38 <mlv03 AT healthresearch DOT org>
AM
cc
<veritas-bu AT mailman.eng.auburn DOT edu>
Subject
Please respond to RE: [Veritas-bu] Sybase backup
<Asiye.Yigit@gant error
ek.com>
Hi Mike,
Where can I see "-S" flag?
-----Original Message-----
From: Mike L. Varney [mailto:mlv03 AT healthresearch DOT org]
Sent: Wednesday, October 19, 2005 6:06 PM
To: Asiye.Yigit AT gantek DOT com
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Sybase backup error
The server name is case sensitive for Sybase's ISQL. Make sure that the
case for your -S flag is correct.
For SYBACKUP_SERVER you have it in lower case, but your -S flag has it
in upper case.
-- Mike Varney / HRI
Asiye Yi=F0it
<Asiye.Yigit@gant
ek.com>
To
Sent by:
<veritas-bu AT mailman.eng.auburn DOT edu>
veritas-bu-admin@
cc
mailman.eng.aubur
n.edu
Subject
[Veritas-bu] Sybase backup error
10/19/2005 10:49
AM
Please respond to
<Asiye.Yigit@gant
ek.com>
Hi all,
We have nb 4.5 MP6 on solaris 8 box. The system is both media and master
server. The version of sybase is 12.0. we are trying to back up sybase
with nb sybase agent. It gives the following error. I would appreciate
if you help us.
Regards,
Started Wed Oct 19 14:55:31 EEST 2005
SYBACKUP_SERVER =3D mnanmas1o
SYBACKUP_POLICY =3D sybase_bckp
SYBACKUP_SCHED =3D sybase_bckp_db
SYBACKUP_CLIENT =3D mnanmas1o
SYBACKUP_SCHEDULED =3D 1
SYBACKUP_USER_INITIATED =3D 0
/opt/sybase/OCS-12_0/bin/isql -Uxxxxxxxx -Pxxxxxxxx
-I/opt/sybase/interfaces -SMNANOMC1 < ./syb_MNANOMC1_dump Msg 911, Level
11, State 2: Server 'MNANOMC1', Line 1: Attempt to locate entry in
sysdatabases for database 'MNANOMC1' by name failed - no entry found
under that name. Make sure that name is entered properly. bpbackup -c
sybase_bckp /opt/sybase/scripts Finished Wed Oct 19 14:55:31 EEST 2005
exit 0
Started Wed Oct 19 15:19:14 EEST 2005
SYBACKUP_SERVER =3D mnanmas1o
SYBACKUP_POLICY =3D sybase_bckp
SYBACKUP_SCHED =3D sybase_bckp_db
SYBACKUP_CLIENT =3D mnanmas1o
SYBACKUP_SCHEDULED =3D 1
SYBACKUP_USER_INITIATED =3D 0
/opt/sybase/OCS-12_0/bin/isql -Uxxxxxxxx -Pxxxxxxxx
-I/opt/sybase/interfaces -SMNANOMC1 < ./syb_MNANOMC1_dump CT-LIBRARY
error:
ct_connect(): network packet layer: internal net library
error:
Net-Library operation terminated due to disconnect
bpbackup -c sybase_bckp /opt/sybase/scripts
Finished Wed Oct 19 15:19:15 EEST 2005
exit 255
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
------=_NextPart_000_0015_01C5D4E4.40C547F0
Content-Type: text/plain;
name="syb_dumptxt.txt"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="syb_dumptxt.txt"
mnanmas1o{root} #: pwd
/sybase_scripts
mnanmas1o{root} #: ls
syb_MNANOMC1_dump sybase_MNANOMC1_backup sybase_MNANOMC1_load =
sybase_MNANOMC1_restore
mnanmas1o{root} #: more syb_MNANOMC1_dump=20
dump TRANSACTION FMADB_1_1 to "sybackup::-SERV -CLIENT -POL -SCHED =
sybase_bckp_db"
go
mnanmas1o{root} #: isql -Usa -Psybase11 < syb_MNANOMC1_dump
Msg 911, Level 11, State 2:
Server 'MNANOMC1', Line 1:
Attempt to locate entry in sysdatabases for database 'FMADB_1_1' by name =
failed
- no entry found under that name. Make sure that name is entered =
properly.
mnanmas1o{root} #:=20
------=_NextPart_000_0015_01C5D4E4.40C547F0
Content-Type: text/plain;
name="backup script.txt"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="backup script.txt"
mnanmas1o{root} #: more sybase_MNANOMC1_backup=20
#!/bin/sh
# sybase_mydb_backup $Revision: 1.10 $
#bcpyrght
#************************************************************************=
***
#* $VRTScprght: Copyright 1993 - 2002 VERITAS Software Corporation, All =
Rights Reserved $ *
#************************************************************************=
***
#ecpyrght
#************************************************************************=
***
# Replace /usr/sybase12 below with the actual Sybase home directory=20
#************************************************************************=
***
SYBASE=3D/opt/sybase
LD_LIBRARY_PATH=3D$LD_LIBRARY_PATH:/opt/sybase/lib
export LD_LIBRARY_PATH
. $SYBASE/SYBASE.sh
#************************************************************************=
***
# Replace SYBASE12 below with the actual name of the SQL Server
#************************************************************************=
***
SYBSERVER=3DMNANOMC1
#************************************************************************=
***
# Replace SYB_DB below with the actual name of your Sybase database
#************************************************************************=
***
DATABASE_NAME=3DMNANOMC1
#************************************************************************=
***
# Replace syb_files below with your actual name of the NetBackup=20
# server Policy to be used to backup the directory with Sybase script =
files
#************************************************************************=
***
SYB_FILES_POLICY=3Dsybase_bckp
#************************************************************************=
***
# Replace /usr/sybase12/scripts below with your actual path of the =
Sybase files=20
#************************************************************************=
***
SYB_FILES_DIR=3D/opt/sybase/scripts
#************************************************************************=
***
# Determine the SYBASE_ASE and SYBASE_OCS env variables for Sybase 12.x
#************************************************************************=
***
OCS_QUAL=3D
if [ -f "${SYBASE}"/SYBASE.csh ] ; then
SYBASE_ASE=3D`grep "setenv SYBASE_ASE" "${SYBASE}"/SYBASE.csh | =
cut -f3 -d" " | sort -u | head -1`
SYBASE_OCS=3D`grep "setenv SYBASE_OCS" "${SYBASE}"/SYBASE.csh | =
cut -f3 -d" " | sort -u | head -1`
export SYBASE_ASE
export SYBASE_OCS
OCS_QUAL=3D/$SYBASE_OCS
elif [ -f "${SYBASE}"/SYBASE.sh ] ; then
SYBASE_ASE=3D`grep "SYBASE_ASE=3D" "${SYBASE}"/SYBASE.sh | cut =
-f2 -d"=3D" | sort -u | head -1`
SYBASE_OCS=3D`grep "SYBASE_OCS=3D" "${SYBASE}"/SYBASE.sh | cut =
-f2 -d"=3D" | sort -u | head -1`
export SYBASE_ASE
export SYBASE_OCS
OCS_QUAL=3D/$SYBASE_OCS
fi
echo "Started `date`"
SYBASE=3D$SYBASE; export SYBASE
# These environment variables are set by NetBackup=20
echo "SYBACKUP_SERVER =3D $SYBACKUP_SERVER"
echo "SYBACKUP_POLICY =3D $SYBACKUP_POLICY"
echo "SYBACKUP_SCHED =3D $SYBACKUP_SCHED"
echo "SYBACKUP_CLIENT =3D $SYBACKUP_CLIENT"
echo "SYBACKUP_SCHEDULED =3D $SYBACKUP_SCHEDULED"
echo "SYBACKUP_USER_INITIATED =3D $SYBACKUP_USER_INITIATED"
RETURN_STATUS=3D0
#************************************************************************=
***
# Replace "database_dump" below with your actual NetBackup schedule name
# which is used for a full backup of the Sybase database.
#************************************************************************=
***
if [ "${SYBACKUP_SCHED}" =3D "sybase_bckp_db" ]
then
############# NetBackup has started a "database_dump" backup =
##############
DUMP_TYPE=3DDATABASE
else
############# NetBackup has started a "transaction log" backup =
##############
DUMP_TYPE=3DTRANSACTION
fi
#************************************************************************=
***
# Replace "Default-Application-Backup" below with your actual NetBackup=20
# Application Backup type schedule name for the Sybase database.=20
#************************************************************************=
***
echo dump $DUMP_TYPE $DATABASE_NAME to \"sybackup::-SERV =
$SYBACKUP_SERVER -CLIENT $SYBACKUP_CLIENT -POL $SYBACKUP_POLIC
Y -SCHED sybase_bckp_db\" > ./syb_${DATABASE_NAME}_dump
#************************************************************************=
**
# Remove the '#' from the beginning of the line below if you are going =
to
# use multiple stripes for the backup. Repeat this line for each stripe.
# Replace "Default-Application-Backup" below with your actual NetBackup
# Application Backup type schedule name for the Sybase database.
# =
*************************************************************************=
*
echo stripe on \"sybackup::-SERV $SYBACKUP_SERVER -CLIENT =
$SYBACKUP_CLIENT -POL $SYBACKUP_POLICY -SCHED sybase_bckp_db\" >> ./
syb_${DATABASE_NAME}_dump=20
echo go >> ./syb_${DATABASE_NAME}_dump
#************************************************************************=
***
# Log the isql command. This line may appear in NetBackup log files.
# Do NOT replace "xxxxxxxx" with a user id or password.
#************************************************************************=
***
echo "$SYBASE$OCS_QUAL/bin/isql -Uxxxxxxxx -Pxxxxxxxx =
-I$SYBASE/interfaces -S$SYBSERVER < ./syb_${DATABASE_NAME}_dump"
#************************************************************************=
***
# Replace "sa" with your Sybase server Administrator's login name.
# Replace "manager" with your Sybase server Administrator's password.
#************************************************************************=
***
$SYBASE$OCS_QUAL/bin/isql -Usa -Psybase11 -I$SYBASE/interfaces =
-S$SYBSERVER < ./syb_${DATABASE_NAME}_dump
RETURN_STATUS=3D$?
if [ "${DUMP_TYPE}" =3D "DATABASE" ]
then
# Initiate a backup of any file related to the Sybase database, =
such as script files.
echo "bpbackup -c $SYB_FILES_POLICY $SYB_FILES_DIR"
/usr/openv/netbackup/bin/bpbackup -c $SYB_FILES_POLICY =
$SYB_FILES_DIR
BPBACKUP_STATUS=3D$?
if [ "$BPBACKUP_STATUS" -ne 0 ]
then
echo ""
echo "bpbackup of $SYB_FILES_DIR returned =
$BPBACKUP_STATUS"
fi
fi
echo "Finished `date`"
echo "exit $RETURN_STATUS"
echo ""
exit $RETURN_STATUS
------=_NextPart_000_0015_01C5D4E4.40C547F0--
|
