Problem with restoring with ontape -r

Ask a Question related to Informix, Design and Development.

  1. #1

    Default Problem with restoring with ontape -r

    Situation:

    In order to install a testsystem a backup has been created of our
    Informix database with ontape -s -L 0. The tape to which the data is
    backuped has a potential of about 130 GB but the TAPESIZE was limited
    to 80 GB.

    Our total database however is about 180 GB and the backup, as result,
    took 3 tapes. So far so good. Now we want to restore these tapes to
    our test system.
    I used ontape -r which seemed to work fine. With onstat -Dr I could
    monitor the progress of the restore.

    Problem:
    The 80 GB of data of the first tape has been restored. The "onstat
    -Dr" command showes no further action from the restore. However the
    system doesn't ask for tape nr. 2. I don't know wether or not the
    process is still active or sort of sleeping. The online.log last entry
    is 20 hours ago. What to do? Should I just insert tape nr. 2 and hope
    the process continues ?

    Thanks in advance for your help.

    Danny
    Danny Guest

  2. Similar Questions and Discussions

    1. Backing up and restoring a database with the SELinux pg_user problem.
      Joseph Kiniry <kiniry@acm.org> writes: Sure, just run the CREATE VIEW command executed by initdb; it's in the initdb shell script. Note that all...
    2. Clarification about restoring from disk using ontape please, ( even more confused).
      I've got the same problem. I have an HDR setup and I'm trying to recover the Secondary using ontape -l. It prompts me to roll forward with log...
    3. ontape -r and CKPT REQ
      Hello, I am trying to do a cold restore for all DBSpaces from one Server to another(both Linux 7.0). I did an ontape -r I mounted the tape...
    4. ontape -r error
      We are running IDS 9.30.UC1 on Solaris 8 --- We do a level zero archive twice a week to disk, gzip the file and retain two versions. The archive...
    5. Restoring / partition problem
      I would like to ask how I can restore / partition in Linux. I dump and restore other partition successfully (ext2 and ext3) I tired with an HP...
  3. #2

    Default Problem with restoring with ontape -r

    Situation:

    In order to install a testsystem a backup has been created of our
    Informix database with ontape -s -L 0. The tape to which the data is
    backuped has a potential of about 130 GB but the TAPESIZE was limited
    to 80 GB.

    Our total database however is about 180 GB and the backup, as result,
    took 3 tapes. So far so good. Now we want to restore these tapes to
    our test system.
    I used ontape -r which seemed to work fine. With onstat -Dr I could
    monitor the progress of the restore.

    Problem:
    The 80 GB of data of the first tape has been restored. The "onstat
    -Dr" command showes no further action from the restore. However the
    system doesn't ask for tape nr. 2. I don't know wether or not the
    process is still active or sort of sleeping. The online.log last entry
    is 20 hours ago. What to do? Should I just insert tape nr. 2 and hope
    the process continues ?

    Thanks in advance for your help.

    Danny
    Danny Guest

  4. #3

    Default Re: Problem with restoring with ontape -r

    Depending on the OS you can use truss or similar to see what the
    process is doing/not doing. Are the tape parameters the same for
    both systems, is the tape still running, has the job been backgrounded
    and then brought forward and you've missed the message to change the
    tape



    Danny wrote:
    >
    > Situation:
    >
    > In order to install a testsystem a backup has been created of our
    > Informix database with ontape -s -L 0. The tape to which the data is
    > backuped has a potential of about 130 GB but the TAPESIZE was limited
    > to 80 GB.
    >
    > Our total database however is about 180 GB and the backup, as result,
    > took 3 tapes. So far so good. Now we want to restore these tapes to
    > our test system.
    > I used ontape -r which seemed to work fine. With onstat -Dr I could
    > monitor the progress of the restore.
    >
    > Problem:
    > The 80 GB of data of the first tape has been restored. The "onstat
    > -Dr" command showes no further action from the restore. However the
    > system doesn't ask for tape nr. 2. I don't know wether or not the
    > process is still active or sort of sleeping. The online.log last entry
    > is 20 hours ago. What to do? Should I just insert tape nr. 2 and hope
    > the process continues ?
    >
    > Thanks in advance for your help.
    >
    > Danny
    --
    Paul Watson #
    Oninit Ltd # Growing old is mandatory
    Tel: +44 1436 672201 # Growing up is optional
    Fax: +44 1436 678693 #
    Mob: +44 7818 003457 #
    [url]www.oninit.com[/url] #
    Paul Watson Guest

  5. #4

    Default Re: Problem with restoring with ontape -r

    It looks like system is waiting for tape change. If using unix, use fg to
    bring job in foreground. You might get some prompt for tape change. I would
    not run this in background.

    "Danny" <dvh@leolux.nl> wrote in message
    news:7dd24be9.0310290003.37240820@posting.google.c om...
    > Situation:
    >
    > In order to install a testsystem a backup has been created of our
    > Informix database with ontape -s -L 0. The tape to which the data is
    > backuped has a potential of about 130 GB but the TAPESIZE was limited
    > to 80 GB.
    >
    > Our total database however is about 180 GB and the backup, as result,
    > took 3 tapes. So far so good. Now we want to restore these tapes to
    > our test system.
    > I used ontape -r which seemed to work fine. With onstat -Dr I could
    > monitor the progress of the restore.
    >
    > Problem:
    > The 80 GB of data of the first tape has been restored. The "onstat
    > -Dr" command showes no further action from the restore. However the
    > system doesn't ask for tape nr. 2. I don't know wether or not the
    > process is still active or sort of sleeping. The online.log last entry
    > is 20 hours ago. What to do? Should I just insert tape nr. 2 and hope
    > the process continues ?
    >
    > Thanks in advance for your help.
    >
    > Danny

    Hari Gupta Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139