Skip to Content
avatar image
Former Member

Restore procedure of Sybase

Dear Experts,

I am very new to sybase database. I am not able to understand the architecture of sybase, the process flow, tablespace (like in oracle) etc.

I am following the sybase infocenter but if anyone of you could help me understand it better (with document), will be really helpful.

Also, if anyone has performed a restore of the Sybase database on AIX please let me know. Shall help me a lot

Thanks,

Harikrishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 18, 2013 at 03:14 PM

    This is a very basic and very simplified explanation, I hope it will help you to start working with Sybase ASE easier.

    ASE dataserver is an equivalent of Oracle instance. It consists of one or more OS processes. Starting form ASE 15.7 it will usually use a single OS process, which spawns many threads behind the scenes. You can connect to the dataserver using a host/port combination, the listener is built-in inside ASE, no dedicated OS process is required. The dataserver is also responsible for memory allocation.

    The dataserver always contains a number of databases (master, sybsystemprocs, tempdb), which can be considered "system" databases and they are always present. You will create one or more user databases to store your data. The database is allocated on ASE devices, which are similar to Oracle datafiles and created by "disk init" command. Each database contains data (tables, indexes) and transaction log. In most of the cases, you will allocate data and log on different ASE devices. A database can allocate space for either data or log on multiple ASE devices.

    To backup or restore a database (dump and load in ASE terminology), an additional process called backupserver is required. Backupserver is implemented as a separate OS process and may serve a number of ASE dataservers. You can perform a full database backup using "dump database" command, the dump is performed online and doesn't require any downtime. The full database restore is performed using "load database" command. Dump and load commands are executed on the dataserver.

    In addition, you can dump and load transaction log of the database using "dump transaction" and "load transaction" respectively. This allows to perform the restore up to the last committed transaction, or point-in-time restore.

    The next step should be reading the ASE documentation on the Infocenter, as already recommended by others.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 17, 2013 at 07:53 PM

    I strongly recommend reading the Sybase ASE System Administration Guide, since it explains everything you mention, and much more. Start at chapter 1, volume1: http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc31654.1570/pdf/sag1.pdf

    Backup & restore are described in chapter 12 & 13 of volume #2: http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc31644.1570/pdf/sag2.pdf

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2013 at 08:27 PM

    Dear Sharma,

    Information on backup and recovery of an SAP system on SAP Sybase ASE:

    SAP Note 1611715 -SYB: How to restore an SAP Sybase ASE database server (Windows) and

    SAP Note 1618817 -SYB: How to restore an SAP Sybase ASE database server (UNIX)

    Additionally you can also refer the links for better understanding :

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

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

    Thanks

    Asim

    Add comment
    10|10000 characters needed characters exceeded