Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / April 2006

Tip: Looking for answers? Try searching our database.

ontape restore help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gary Quiring - 27 Apr 2006 16:18 GMT
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!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.