Results 1 to 4 of 4

Thread: LOAD Database

  1. #1
    Join Date
    Feb 2005
    Posts
    19

    Unanswered: LOAD Database

    Can i restore the database dump taken on Wndows 2000 onto a Solaris Server. I am facing problems i get following error

    Backup Server session id is: 44. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
    Backup Server: 6.66.2.1: Volume validation error: illegal volume change, device /server/data/sybase/SV0016_2K/db_dump_dev/cerd.dmp: volume mounted out of order, expected volume 0001, got volume 16777216.
    Backup Server: 6.36.2.4: Header labels of rejected volume:
    Backup Server: 6.34.2.4:
    VOL1 0 7
    HDR1TRIAL050350ADBF 
    HDR2F
    Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
    Backup Server: 6.32.2.3: /server/data/sybase/SV0016_2K/db_dump_dev/cerd.dmp: volume not valid or not requested (server: , session id: 44.)
    Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
    Error encountered by Backup Server. Please refer to Backup Server messages for details.

    can someone help

  2. #2
    Join Date
    Aug 2004
    Posts
    38
    Afraid that you cannot load a Win 2000 dump onto Solaris. I think that Sybase are working on this and it will possibly be available in a later release. It's only in the very lastest relase that you can move dumps between Unix platforms (e.g. AIX to Solaris).

    If you want to move the database you'll have to do a logical move, i.e. copy out the schema and then bcp the data.

    Not very helpful, I know.

  3. #3
    Join Date
    Aug 2004
    Posts
    38
    Looks like they've now done this after all:

    http://www.sybase.com/content/103362...DL_1253_WP.pdf

    In which case it looks like to way to do this is to upgrade the Solaris Sybase server to 12.5.3 before running the load, assuming that this is possible.

    HTH
    Last edited by KevR; 02-04-05 at 12:11.

  4. #4
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255

    There have always been other more appropriate methods ...

    Just in case it you are not aware ...

    1. The Sybase dump file (and subsequent load) is o/s platform and 32/64 bit specific. It is a 'fast' operation intended for use on the same or similar (within reason) Sybase ASE server and limited to that o/s platform. It is what you may call a PHYSICAL backup of the database. It was not intended for cross-platform database migration, and certainly not declared to be so.

    2. For migration of databases (objects and data) across platforms and across ASE server versions (and also for proper repositioning and resizing of databases), you will need to:
    - migrate the database objects (using any number of object-definition handling tools: PowerDesigner; DBArtisan; sybmigrate; etc)
    - resolve any issues due to ASE versions, etc
    - a LOGICAL backup of the data. This consists of:
    --- bcp-out all tables in char mode (not native mode)
    --- transfer the files from source platform to target platform (or share)
    --- bcp-in all tables (in the correct sequence as per RI constraints)
    - (of course, backup [dump] the database as soon as the database is completely loaded)

    3. As a very recent ASE enhancement, ASE 12.5.3 (only) now reads any backup file dumped by ASE 11.9.2 or later from any o/s platform. This is interesting, and possibly useful to people with small databases, but will not be used by those of us who have large databases and have (2) in place. (In any case, there are limitations [which (2) does not have], and some work to be done [based on how good your standards and operating procedures are]).
    Last edited by DerekA; 02-05-05 at 22:58.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •