Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Unanswered: dump to two tapes and load from one not working

    According to Sybase documents, you can "Using fewer devices to load than to dump". I tested on my system but it is not working

    My server info:
    SQL Server/11.0.3.3/P/DEC AXP/OpenVMS V6.2/SWR 8706

    Command to dump
    dump database my_db to "mag1"
    stripe on "mag2"

    command to restore
    dump database my_db from "mag1"

    After I executed the restore statement, I got the following error message:

    ----omitted sth here
    Backup Server: 4.58.1.1: Database my_db: 8667392 kilobytes LOADed.
    Jul 13 14:51:04 2004:
    Backup Server: 4.58.1.1: Database my_db: 8869122 kilobytes LOADed.
    Jul 13 14:51:50 2004:
    Backup Server: 4.58.1.1: Database my_db: 9042178 kilobytes LOADed.
    Jul 13 14:52:36 2004:
    Backup Server: 4.58.1.1: Database my_db: 9216000 kilobytes LOADed.
    Jul 13 14:52:36 2004:
    Backup Server: 6.32.2.2: mag2:: volume not valid or not requested (server: , ses
    sion id: 132.)
    Jul 13 14:52:36 2004:
    Backup Server: 1.14.2.3: Unrecoverable I/O or volume error. This DUMP or LOAD s
    ession must exit.
    Jul 13 14:52:36 2004:
    Backup Server: 6.32.2.3: mag1:: volume not valid or not requested (server: , ses
    sion id: 132.)
    Jul 13 14:52:36 2004:
    Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD s
    ession must exit.

    By the way, I can restore from two tapes successfully using
    load database my_db from "mag1"
    stripe on "mag"

    My testing purpose is for loading database from two tapes backup. Sometimes, we can restore from one tape if the other is broken.

    Can someone point out what's the reason for that? I have no three tapes on my host, so I cannot test that case.

    I tested to dump two disk with stripe on option , ie,
    dump database my_db to "/dev/my_db.dump1"
    stripe on "/dev/my_db.dump2"

    when you want to restore using
    load database my_db from "/dev/my_db.dump1".
    The server will give you below warining:

    Jul 13 15:18:36 2004: Backup Server: 6.28.1.1: Dumpfile name 'test041950D73E ' section number 1 mounted on disk file /dev/my_db.dmp1'
    Jul 13 15:18:36 2004: Backup Server: 4.54.2.1: The load command specifies too few devices of type 'disk file': expected 2, got 1.
    Jul 13 15:18:36 2004: Backup Server: 6.32.2.3: /dev/my_db.dmp1: volume not valid or not requested (server: , session id: 9.)
    Jul 13 15:18:36 2004: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.

    So I know that it is not suitable for disk file dumps.

    Your help is highly appreciated.

    Allen

  2. #2
    Join Date
    Jun 2002
    Location
    Argentina
    Posts
    78

    Exclamation

    You have a backup in two files, "mag1" and "mag2" :

    dump database my_db to "mag1"
    stripe on "mag2"
    go

    When you restore the backup you must restore all the files,
    so this statement is wrong:

    load database my_db from "mag1"
    go

    You must use:

    load database my_db from "mag1"
    stripe on "mag2"
    go

    When you say "According to Sybase documents, you can "Using fewer devices to load than to dump"",
    that mean that you can load a backup from a databases like this:

    create database mydb on mydev1 = 100
    log on mydev2 = 100
    go
    alter database mydb on mydev3 = 100
    go
    alter database mydb on mydev4 = 100
    go
    alter database mydb on mydev5 = 100
    go

    To this database:

    create database mydb on mydev1 = 100
    log on mydev2 = 100
    go
    alter database mydb on mydev3 = 300
    go

    Like you see "fewer devices" but same or more spaces.
    Bye bye

    Sebastian

  3. #3
    Join Date
    Jul 2004
    Posts
    3

    Using fewer devices to load than to dump

    Hi, Sebastian
    Thanks for your input.

    <<<<<You have a backup in two files, "mag1" and "mag2" :
    <<<<<
    <<<<<dump database my_db to "mag1"
    <<<<<stripe on "mag2"
    <<<<<go

    Yes.You are right. I do use this command to compete my dump to tapes and I succeeded.

    <<<<<When you restore the backup you must restore all the files,
    <<<<<so this statement is wrong:
    <<<<<
    <<<<<load database my_db from "mag1"
    <<<<<go

    Sorry. You are incorrect here. I do use command:
    load database my_db from "mag1"
    to restore. The syntax is correct because backup server is working after I executed this command.

    <<<<<
    <<<<<You must use:
    <<<<<
    <<<<<load database my_db from "mag1"
    <<<<<stripe on "mag2"
    <<<<<go

    If I use this command, yes, it will work all right. But what I am testing is "Using fewer devices to load than to dump", which means I have a backup consist of two tapes, when I want to do a restore on another machine which only one tape driver there.

    <<<<<
    <<<<<When you say "According to Sybase documents, you can "Using fewer devices to load than to dump"",
    <<<<<that mean that you can load a backup from a databases like this:
    <<<<<
    <<<<<create database mydb on mydev1 = 100
    <<<<<log on mydev2 = 100
    <<<<<go
    <<<<<alter database mydb on mydev3 = 100
    <<<<<go
    <<<<<alter database mydb on mydev4 = 100
    <<<<<go
    <<<<<alter database mydb on mydev5 = 100
    <<<<<go
    <<<<<
    <<<<<To this database:
    <<<<<
    <<<<<create database mydb on mydev1 = 100
    <<<<<log on mydev2 = 100
    <<<<<go
    <<<<<alter database mydb on mydev3 = 300
    <<<<<go
    <<<<<
    <<<<<Like you see "fewer devices" but same or more spaces.
    <<<<<Bye bye

    Your example is incorrect. Please see Sysadm document , chaper 27, refer to section "Using fewer devices to load than to dump". You will understand what I am testing now.

    Thanks.

    Allen

  4. #4
    Join Date
    Jun 2002
    Location
    Argentina
    Posts
    78
    You are right, I didn't know about this feature, I will try to use and see what happens.
    Thank you,

    Sebastian

Posting Permissions

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