I am trying my first ontape restore (no emergency just learning).
Steps:
level 0 ontape -s
dropped my database and dbspace that the database was on
Set the tape to /dev/null and used ontape -s
Set the tape back to /dev/rmt/0
ontape -r but it said the dbspace did not exist. I recreated the
dbspace with the exact same size as before.
ontape -r -D cdi
Archive Tape Information
Tape type: Archive Backup Tape
Online version: IBM Informix Dynamic Server Version 9.40.UC7
Archive date: Thu Apr 27 07:30:18 2006
User id: root
Terminal id: /dev/pts/1
Archive level: 0
Tape device: /dev/rmt/0
Tape blocksize (in k): 512
Tape size (in k): 500000000
Tape number in series: 1
Continue restore? (y/n)y
Spaces to restore:1 [cdi
]
Physical restore failed - Archived 'cdi' is a different space from the
current 'cdi'. Only physical restores of
existing spaces are allowed.
onstat -d:
address number flags fchunk nchunks flags owner name
8a1127e8 1 0x20001 1 1 N informix
rootdbs
8ad0be60 2 0x42001 2 1 N TB informix dbtmp
8ad0c018 3 0x1 3 1 N informix
dbplog
8ad0c178 4 0x40001 4 1 N B informix dblogs
8ad0c2d8 5 0x60005 5 1 ND B informix cdi
5 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags
pathname
8a112948 1 1 0 250000 247308 PO--
/dev/informix/rootdb
8ad0b840 2 2 0 7500000 7499947 PO-B
/dev/informix/dbtmp
8ad0b9c8 3 3 0 500000 199947 PO--
/dev/informix/dbplog
8ad0bb50 4 4 0 4000000 2997447 PO-B
/dev/informix/dblogs
8ad0bcd8 5 5 0 200000000 0 PD-B
/dev/informix/cdi
5 active, 32766 maximum
Expanded chunk capacity mode: enabled
What am I doing wrong?
Thanks
Gary Quiring
Gary Quiring - 27 Apr 2006 19:08 GMT
Doh!!! It works much better when the engine is not running!!!