cancel
Showing results for 
Search instead for 
Did you mean: 

sybase Database Backup

Former Member
0 Kudos

Dear Expert,

I am using Sybase Database 15.0 with unix, as i new to Sybase please me  how to take backup of Sybase Database.

i get the below error

1> dump database pubs2 to 'd:\dump'

2> go

Msg 7205, Level 17, State 2:

Server 'BHAVANIPC', Line 1:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE

boot directory.

Msg 7205, Level 18, State 3:

Server 'BHAVANIPC', Line 1:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE

boot directory.

Also we opened the backup server

Thanks & Regards,

Akhila

Accepted Solutions (0)

Answers (2)

Answers (2)

SybDBA
Participant
0 Kudos

Hi Akhila,

can you please share interface file under $SYBASE directory??

I have some solution in this context.

---

Pankaj

former_member207908
Participant
0 Kudos

Hi

Getting the same kind of error while running dump command.

1> dump transaction XXX using config = 'XXXLOG'

1> use master

2> go

1> dump transaction XXX using config = 'XXXLOG'

2> go

Msg 7205, Level 17, State 2:

Server 'PJ2', Line 1:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.

Msg 7205, Level 18, State 3:

Server 'PJ2', Line 1:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.

Msg 3220, Level 17, State 3:

Server 'PJ2', Line 1:

Could not establish communication with Backup Server 'SYB_BACKUP'.  Please make sure that there is an entry in Sysservers for this server, and that the correct server is running.

interface file entries

XXX
        master tcp ether xxxxxx 4901
        query tcp ether xxxxxx 4901


XXX_BS
        master tcp ether xxxxxx 4902
        query tcp ether xxxxxx 4902


XXX_JSAGENT
        master tcp ether xxxxxx 4903
        query tcp ether xxxxxx 4903

ASE SP122 on AIX 7.1

Let me know if you need further information

Let the steps provided in

http://infocenter.sybase.com/archive/index.jsp?topic=/com.sybase.39996_1250/html/svrtsg/svrtsg227.ht...

find the attached backup server errorlog for your reference

Apprecate any help

Regards,

Rajesh

former_member188958
Active Contributor
0 Kudos

Your backupserver errorlog is showing the error

Feb  9 15:00:01 2015: Backup Server: 2.24.2.1: The host '10.3.5.61' is not authorized to connect to this Backup Server.

Feb  9 15:00:01 2015: Backup Server: 5.40.2.1: Login host authentication has failed.

This is a symptom of a bug with a security feature that was introduced in 15.7 SP100

Remote Dump Host Control.  This feature was not supposed to interfere with local dumps, but in some cases such as hosts with multiple network interfaces, it did.

The error can usually be resolved by adding entries for the local server's network interfaces to the hosts.allow file.

luc_vanderveurst
Participant
0 Kudos

There was a 'feature' introduced in sp110/sp50 to increase security.

Your backupserver logs contains the following lines :

Feb  9 18:08:41 2015: Backup Server: 1.88.1.1: The hosts authentication file used by the backup server is '/sybase/PJ2/hosts.allow'.

The host '10.3.5.61' is not authorized to connect to this Backup Server.

Feb  9 14:00:01 2015: Backup Server: 5.40.2.1: Login host authentication has failed.

What is the content of '/sybase/PJ2/hosts.allow' ?

Add a line :

10.3.5.61 +

if it doesn't contain it yet, or replace the ip address by the hostname.

HTH,

Luc.

former_member207908
Participant
0 Kudos

HI Luc,

Appreciate your prompt response.

There is no hosts.allow file at that location. Please advice further.

% pwd

/sybase/PJ2

% ls h*

No match.

%

Regards,

Rajesh

luc_vanderveurst
Participant
0 Kudos

Create the file, and add line

10.3.5.61 +

or change the ip address by the hostname.

You can then restart the backupserver to be sure, but I don't think it's necessary.

former_member207908
Participant
0 Kudos

Do you mean simply the content should be 10.3.5.61 + ..??

former_member188958
Active Contributor
0 Kudos

Yes.

The details of the file format are in the documentation I referenced before: Remote Dump Host Control.

Extracting from the examples there, a simple entry would look like:

Example:

# Example of hosts.allow file

# Development machine imetsol1 allows access from everywhere

imetsol1 +


An ip address can be substituted for the logical host name.

-bret

former_member207908
Participant
0 Kudos

Hi Bret,

Getting the following error when I issued dump database command

Msg 7205, Level 17, State 2:

Server 'PJ2', Line 1:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.

Msg 7205, Level 18, State 3:

Server 'PJ2', Line 1:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.

Msg 3220, Level 17, State 3:

Server 'PJ2', Line 1:

Could not establish communication with Backup Server 'SYB_BACKUP'.  Please make sure that there is an entry in Sysservers for this server, and that the correct server is running.

tried substituting IP adress and logical hostname and restarted the backup server. pls advice further.

Rajesh

former_member188958
Active Contributor
0 Kudos

Is there any corresponding error in the backupserver errorlog?

Does "showserver" show the backupserver running?

-bret

former_member207908
Participant
0 Kudos

Yes, backup server is up and running

No errors found in the backup server errorlog but in dataserver errorlog and the same has been attached for you reference.

luc_vanderveurst
Participant
0 Kudos

The select on sysservers doesn't show enough information, you shoud add column srv_netname, so :

select srvid, srvname, srvnetname from sysservers.

or

select srvnetname from sysservers where srvname = 'SYB_BACKUP'.

Does that return the name of your backup server ?

Luc.

former_member207908
Participant
0 Kudos

Hi Luc,

Please find the output.

1> select srvnetname from sysservers where srvname = 'SYB_BACKUP'

2> go

srvnetname                                                                                                                                                            

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SYB_BACKUP

Pls advice further

Rajesh

luc_vanderveurst
Participant
0 Kudos

While trying to find a solution, you must have dropped the backupserver and added it again without its physical name.

Execute:

sp_dropserver SYB_BACKUP

go

sp_addserver SYB_BACKUP, null, PJ2_BS

go

That should fix the 'server not found in interfaces file' error.

Luc.

former_member207908
Participant
0 Kudos

Hi Luc,

Please find the attachment for your reference.

Current status: backup server up and running

Error found only in backup server errorlog: The host '10.3.5.61 is notauthirized to connect to this backup server

I have tried adding 10.3.5.61 + and server's logical name in "hosts.allow" file

Pls advice

Rajesh

luc_vanderveurst
Participant
0 Kudos

Please post the output of :

ls -l /sybase/PJ2/hosts.allow

cat /sybase/PJ2/hosts.allow

uname -a

cat /sybase/PJ2/ASE-15_0/install/RUN_PJ2_BS

cat /sybase/PJ2/ASE-15_0/install/PJ2_BS.log

former_member207908
Participant
0 Kudos

Hi

PFA for the output

Rajesh

luc_vanderveurst
Participant
0 Kudos

Remove all comments from hosts.allow, and also remove all empty lines.

The only 2 lines in the file should be :

pj2ci1 +

10.3.5.61 +

so wc -l hosts.allow should show 2 lines.

use vi or a unix editor to create the file.

If this still gives errors, then post the output of :

od -bc hosts.allow

(assuming the od (octal dump) commanda also exists on aix).

former_member207908
Participant
0 Kudos

Dear Luc

Thank you for your valuable inputs

Now there is only one error when i run the dump command

Msg 7221, Level 14, State 2:

Server 'PJ2', Line 1:

Login to site 'SYB_BACKUP' failed.

FYI

% wc -l hosts.allow
       2 hosts.allow


% od -bc hosts.allow

0000000  160 152 062 143 151 061 040 053 012 061 060 056 063 056 065 056
           p   j   2   c   i   1       +  \n   1   0   .   3   .   5   .
0000020  066 061 040 053 012
           6   1       +  \n
0000025

-- Backup server is up and running

--No errors in dataserver errorlog

--Error in the backup server log:

The host '10.3.5.61' is not authorized to connect to this Backup Server.

Login host authentication has failed.

Regards

Rajesh

former_member207908
Participant
0 Kudos

Dear  Luc,

Your idea at one of the SCN post worked

You said "

Ok, i solved my problem.

The IP Address (syslisteners) of my server is different from the host ip address.

I added the ASE server's IP Address  to the hosts.allow file and then the dataserver can connect to the backupserver.

The backupserver error message is misleading. It shows the ip address of the host machine and not the ip address of the server while it's the last one that is necessary in the hosts.allow file.

Luc."

I've checked syslisteners and found the following

1> select * from master..syslisteners

2> go

net_type         address_info            spare nodeid

-----------------------------------------------------------------------------

tcp                 egapj2db   4901              0   NULL

Instead of using "%hostname" I thought, lets give a try with "egapj2db ".

Restarted the backup server and ran the dump command and is ........successful.

Thank you Luc.

I want to award you the points you deserve.

Regards,

Rajesh

former_member207908
Participant
0 Kudos

Received following page verification errors in the backup server errorlog.

What are they actually indicating?

What is action need to be taken?

Feb 11 11:12:17 2015: D00: Attempting direct I/O for device '/sybase/PJ2/sybsystem/sybmgmtdb.dat'
Feb 11 11:12:17 2015: Backup Server: 4.188.1.1: Database sybmgmtdb: 6324 kilobytes (8%) DUMPED.
Feb 11 11:12:18 2015: Backup Server: 4.188.1.1: Database sybmgmtdb: 42310 kilobytes (30%) DUMPED.
Feb 11 11:12:18 2015: Backup Server: 4.188.1.1: Database sybmgmtdb: 62648 kilobytes (62%) DUMPED.
Feb 11 11:12:18 2015: D00: Page Verification Error: Object id wrong: alloc page=6912 extent id=6968 page#=6972 ptnid in ext=8 ptnid in page=1712006099.
Feb 11 11:12:18 2015: D00: Page Verification Error: Object id wrong: alloc page=6912 extent id=6968 page#=6973 ptnid in ext=8 ptnid in page=1712006099.
Feb 11 11:12:18 2015: D00: Page Verification Error: Object id wrong: alloc page=6912 extent id=6968 page#=6974 ptnid in ext=8 ptnid in page=1712006099.
Feb 11 11:12:18 2015: D00: Page Verification Error: Object id wrong: alloc page=6912 extent id=6968 page#=6975 ptnid in ext=8 ptnid in page=1712006099.
Feb 11 11:12:18 2015: D00: SYBMULTBUF WARNING: One or more errors have been reported while performing consistency checks on the pages being dumped. The

affected pages will be reread in an attempt to discard spurious errors.
Feb 11 11:12:18 2015: D00: SYBMULTBUF WARNING: After rereading the pages, the consistency check has continued to report one or more errors.
Feb 11 11:12:18 2015: Backup Server: 4.188.1.1: Database sybmgmtdb: 81450 kilobytes (100%) DUMPED.
Feb 11 11:12:18 2015: Backup Server: 3.43.1.1: Dump phase number 1 completed.

Regards,

Rajesh

luc_vanderveurst
Participant
0 Kudos

Take a look at thread :

http://scn.sap.com/thread/3555002

That's a similar story.

You can also dump the transaction log,

see if the error is persistant : redo the dump to see if the errors still occur,

run some dbcc check commands.

Luc.

former_member207908
Participant
0 Kudos

Thanks a ton Luc!

Former Member
0 Kudos

You mentioned 'Sybase Database 15.0 with unix' on you post,

so you must make sure your backup server was started and working ok by following method:

  • under unix command line, issue 'showserver' command to list servers online, and grep 'backupserver' only 

          $showserver |grep backupserver

  

          Example:

              

/data/ase1570 > showserver |grep backupserver

0 S sybase   19210 19209  0  80   0 -  5788 -      Aug01 ?        00:00:00 /data/ase1570/ASE-    15_0/bin/backupserver -SSYB_BACKUP -e/data/ase1570/ASE-15_0/install/SYB_BACKUP.log -N25 -C20 -    M/data/ase1570/ASE-15_0/bin/sybmultbuf

  • isql to connect to ASE15 server, and issue 'sp_helpserver SYB_BACKUP' to check if SYB_BACKUP server host is available ?

         

          $isql -Usa -Psa_pwd -SASE15

          1> sp_helpserver SYB_BACKUP

          2> go

          

          Example:

             

1> sp_helpserver SYB_BACKUP

2> go

name       network_name   security_mechanism   server_principal   class      

status                                                                  

id cost

---------- -------------- -------------------- ------------------ ------------

-------------------------------------------------------------------------

-- ----

SYB_BACKUP SYB_BACKUP     NULL                 NULL               ASEnterprise

timeouts, no net password encryption, writable , enable login redirection

1 NULL

  • isql to connect to ASE15 server, and issue 'SYB_BACKUP...sp_who' to test connection from ASE to Backup server is OK !!

         

           $isql -Usa -Psa_pwd -SASE15 

          1> SYB_BACKUP...sp_who

          2> go

          Example:

1> SYB_BACKUP...sp_who

2> go

spid        status     loginame                       hostname     blk

cmd             

----------- ---------- ------------------------------ ------------ -------------------

     1      sleeping   NULL                           NULL         0 

CONNECT HANDLER 

     2      sleeping   NULL                           NULL         0 

DEFERRED HANDLER

     3      runnable   NULL                           NULL         0 

SCHEDULER       

    11      runnable   NULL                           ASE1570      0 

SITE HANDLER    

    12      running    sa                             sgsinvm0256  0 

NULL           

if the above checking is all ok, then you should be able to dump database without problem !!

BTW, you must notice you are using SAP Sybase ASE 15.0 with Unix , so the dump directory should be Unix filesystem format such as '/backdir/pubs2.dmp' rather than Windows filesystem format such as 'd:\pubs2.dmp' !!

HTH ! Thanks !!

Regards,

Robert

Former Member
0 Kudos

Dear ROBERT,

I am using SYBASE Database 15.0 with AIX 7.0. I am also getting the same error mentioned above in this thread  while performing database backup at OS Level.

Please find the error below ...

1> sp_helpserver SYB_BACKUP

2> go

name

         network_name

         security_mechanism

         server_principal

         class

         status

         id       cost

SYB_BACKUP

         VES_BS

         NULL

         NULL

         NULL

         timeouts, no net password encryption, writable , enable login redirecti

         on

          1       NULL

(return status = 0)

1> SYB_BACKUP...sp_who

2> go

Msg 7205, Level 17, State 2:

Server 'VES', Line 1:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE

boot directory.

Msg 7205, Level 18, State 3:

Server 'VES', Line 1:

Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE

boot directory.

Looking forward for your reply...

Thanks & Regards,

   Ram

luc_vanderveurst
Participant
0 Kudos

Hello,

sp_helpserver shows that the fysical name of the backupserver is VES_BS.

Most likely the server is not running.

On unix systems the startup script can be found in $SYBASE/$SYBASE_ASE/install.

The default name is RUN_VER_BS.

It can be started with :

cd $SYBASE$SYBASE_ASE/install

startserver -f RUN_VER_BS

The environment variables used above should point to the directory in which your ASE software is installed. If they don't seem to have the right values, you can set them with :

cd <your sybase install directory>

. SYBASE.sh

if you are using sh/ksh/bash as your unix shell.

(source SYBASE.csh if you're using a c-shell.)

Best Regards,

Luc.