Backup & Restore problems with ontape -r

[Pasquina]

I make the backup with 'ontape -s' command, but I can't restore it with the 'ontape -r' command.
The output error is 'Physical restore failed - Cannot warm restore ROOT DBspace'

/home/informix> ontape -r

Please mount tape 1 on /home/informix/config/almpru.tap and press Return to cont
inue ...

Archive Tape Information

Tape type: Archive Backup Tape
Online version: Informix Dynamic Server Version 7.31.UC5
Archive date: Wed Jan 15 03:00:12 2003
User id: root
Terminal id: ?
Archive level: 0
Tape device: /home/informix/config/almpru.tap
Tape blocksize (in k): 16
Tape size (in k): 2000000
Tape number in series: 1
Continue restore? (y/n)y

Spaces to restore:1 [rootdbs ]
Physical restore failed - Cannot warm restore ROOT DBspace


Program over.

Can I restore the tape in other way ?

 

[szabogabor]

Hi,

ontape -s makes a full archive of your dbms instance.
ontape -r would make a cold restore of your full instance.
You can only start a cold restore when your instance is not
running, so you have to shut it down with "onmode -ky" before
trying to restore it.

The root dbspace is the most important space of an Informix instance. You have a number of administrative information here, such as what other dbspaces this instance have, what databases you have and so on.
There is the possibility to restore a dbspace where you store only database data in online mode -while your instance is running (this is called a warm restore)- but not for critical dbspaces like the root dbspace and dbspaces that store the physical log and the logical logs.

Gabor

 

[Pasquina]

I take Informix offline with 'onmode -ky' and the new error is:
Physical restore failed - restore reserved pages failed

----ontape -r log ------
/home/informix> ontape -r

Please mount tape 1 on /home/informix/config/almpru.tap and press Return to cont
inue ...

Archive Tape Information

Tape type: Archive Backup Tape
Online version: Informix Dynamic Server Version 7.31.UC5
Archive date: Wed Jan 15 15:14:12 2003
User id: informix
Terminal id: /dev/pts/tb
Archive level: 0
Tape device: /home/informix/config/almpru.tap
Tape blocksize (in k): 16
Tape size (in k): 2000000
Tape number in series: 1

Spaces to restore:1 [rootdbs ]

Archive Information

Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
Initialization Time 01/15/2003 14:14:04
System Page Size 2048
Version 6
Archive CheckPoint Time 01/15/2003 15:14:13

Dbspaces
number flags fchunk nchunks flags owner name
1 1 1 1 N informix rootdbs


Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 262144 191090 PO- /home/informix/config/rootdbs

Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
Physical restore failed - restore reserved pages failed


Program over.
----------------------------------------------
Where is the problem ?

 

[alamb]

just as a precaution measure shutdown your server and restart it again, follow the steps as follows :

1. set the environment
2. why u want to restore ? Is any chunks got down?? if yes, then first u hv to create the chunks with the same name & size as of earlier. if your chunks were down due to bad pages in the HDD then your ontape -r will failed to restore, unless you have not defined the dbspaces/chunks which were down.


3. ontape -r will not create any dbspace / chunks, this will simply restore all the dbspace & chunks which were backed-up only when if it founds all the dbspace/chunks in working condition.

4.if you are having informix crash and not be able to up your informix engine, then first you have to install the informix properly and then setup your physical log, logical log, rootdbs and all other dbspace / chunks according to previous setup, dbspace / chunks name, size must be same.

5. I am having a experience cold restore as well as warm restore on my live server as well as I did the same task before migrating to new unix server, and got it successfully.


Rgds
Alam Badre Alam Badre
Informix Certified Professional

 

[breizhti]

Are you sure that the file /home/informix/config/rootdbs
exist and has the good permissions :
Owner and group = informix
permissions : 644

 

[Pasquina]

I've been trying yours solutions, but I have the same problem.
Can I make a copy of database with other comand ?
I have to make a hot copy of database (while working), and I would like to recover the database on disaster problem (disk error,...).

 

[fra1975]

I've tryed to transport a database sited on a SUN ultra to a intel suse 8 with the same no luck.

on boot the pagesize is 2k my error is :

ontape -r

Please mount tape 1 on /home/informix/tape and press Return to continue ...
Physical restore failed - function read archive backup failed code -1 errno 0
Restore a level 0 archive (y/n) y
Ready for level 0 tape
[code]

is it possible that is because I do it on a file?