Ask a Question related to Informix, Design and Development.
-
Danny #1
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
-
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... -
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... -
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... -
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... -
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... -
Danny #2
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
-
Paul Watson #3
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
-
Hari Gupta #4
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



Reply With Quote

