ontape -r -D dbspace leaves inconsistent dbspace/chunk...

This is a multi-part message in MIME format. ------=_NextPart_000_006D_01BF980D.AFB2F140 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Listers, [Denmark Weatherburn] I've inserted screen output below of an ontape restore for one dbspace only. Please tell me if I'm not doing something correctly. I restored with IDS online. This dbspace has one database. However, It might also have some indexes from another database in another dbspace that was online. Although there was no activity on this database. bbankbz{spsusr}/export/home/SXXICORE/spsusr>ontape -r -D sxxicoredbs DBspace 'sxxicoredbs' is online; restoring 'sxxicoredbs' will bring all chunks comprising the DBspace OFFLINE and will terminate all active transactions and queries accessing the DBspace. OK to continue?y Please mount tape 1 on /export/home/informix/Backups/ontape and press Return to continue ... Archive Tape Information Tape type: Archive Backup Tape Online version: Informix Dynamic Server Version 7.30.UC3 Archive date: Mon Mar 27 13:48:16 2000 User id: sxxiop Terminal id: ? Archive level: 0 Tape device: /export/home/informix/Backups/ontape Tape blocksize (in k): 16 Tape size (in k): 3000000 Tape number in series: 1 Continue restore? (y/n)y Spaces to restore:1 [sxxicoredbs ] Restore a level 1 archive (y/n) Restore a level 1 archive (y/n) n Do you want to restore log tapes? (y/n)n Partial system restore is incomplete. Program over. bbankbz{spsusr}/export/home/SXXICORE/spsusr>onstat - Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 02:26:00 -- 42272 Kb ytes bbankbz{spsusr}/export/home/SXXICORE/spsusr>onstat -d Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 02:26:10 -- 42272 Kb ytes Dbspaces address number flags fchunk nchunks flags owner name b9e6150 1 1 1 1 N informix rootdbs b9e6ca0 2 1 2 1 N informix physdbs b9e6d60 3 1 3 1 N informix logsdbs b9e6e20 4 1 4 1 N informix sxxigldbs b9e6ee0 5 401 5 1 NP informix sxxicoredbs b9e6fa0 6 2001 6 1 N T informix tempdbs1 b9e7060 7 2001 7 1 N T informix tempdbs2 b9e7120 8 2001 8 1 N T informix tempdbs3 b9e71e0 9 2001 9 1 N T informix tempdbs4 b9e72a0 10 2001 10 1 N T informix tempdbs5 b9e7360 11 2001 11 1 N T informix tempdbs6 11 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname b9e6210 1 1 0 25000 22419 PO- /dev/rootdbs b9e63e0 2 2 0 15000 14447 PO- /dev/physdbs b9e64c0 3 3 0 50000 24947 PO- /dev/logsdbs b9e65a0 4 4 0 1000000 839415 PO- /dev/sxxigldbs b9e6680 5 5 0 1000000 922833 PI- /dev/sxxicoredbs b9e6760 6 6 0 25000 24947 PO- /dev/tempsdbs b9e6840 7 7 25001 25000 24947 PO- /dev/tempsdbs b9e6920 8 8 50001 25000 24947 PO- /dev/tempsdbs b9e6a00 9 9 75001 25000 24947 PO- /dev/tempsdbs b9e6ae0 10 10 100001 25000 24947 PO- /dev/tempsdbs b9e6bc0 11 11 125001 25000 24947 PO- /dev/tempsdbs 11 active, 2047 maximum bbankbz{spsusr}/export/home/SXXICORE/spsusr>onspaces -s sxxicoredbs -p /dev/sxxi coredbs -o 0 -O The chunk specified is already online. bbankbz{spsusr}/export/home/SXXICORE/spsusr>onstat - Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 02:32:12 -- 42272 Kb ytes bbankbz{spsusr}/export/home/SXXICORE/spsusr>onstat -d Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 02:32:18 -- 42272 Kb ytes Dbspaces address number flags fchunk nchunks flags owner name b9e6150 1 1 1 1 N informix rootdbs b9e6ca0 2 1 2 1 N informix physdbs b9e6d60 3 1 3 1 N informix logsdbs b9e6e20 4 1 4 1 N informix sxxigldbs b9e6ee0 5 401 5 1 NP informix sxxicoredbs b9e6fa0 6 2001 6 1 N T informix tempdbs1 b9e7060 7 2001 7 1 N T informix tempdbs2 b9e7120 8 2001 8 1 N T informix tempdbs3 b9e71e0 9 2001 9 1 N T informix tempdbs4 b9e72a0 10 2001 10 1 N T informix tempdbs5 b9e7360 11 2001 11 1 N T informix tempdbs6 11 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname b9e6210 1 1 0 25000 22419 PO- /dev/rootdbs b9e63e0 2 2 0 15000 14447 PO- /dev/physdbs b9e64c0 3 3 0 50000 24947 PO- /dev/logsdbs b9e65a0 4 4 0 1000000 839415 PO- /dev/sxxigldbs b9e6680 5 5 0 1000000 922833 PI- /dev/sxxicoredbs b9e6760 6 6 0 25000 24947 PO- /dev/tempsdbs b9e6840 7 7 25001 25000 24947 PO- /dev/tempsdbs b9e6920 8 8 50001 25000 24947 PO- /dev/tempsdbs b9e6a00 9 9 75001 25000 24947 PO- /dev/tempsdbs b9e6ae0 10 10 100001 25000 24947 PO- /dev/tempsdbs b9e6bc0 11 11 125001 25000 24947 PO- /dev/tempsdbs 11 active, 2047 maximum bbankbz{spsusr}/export/home/SXXICORE/spsusr> Thanks in advance for your help. Denmark W. ------=_NextPart_000_006D_01BF980D.AFB2F140 Content-Type: application/msword; name="dbsrestore.doc" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="dbsrestore.doc" 0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAALgAAAAAAAAAA EAAAMAAAAAEAAAD+////AAAAAC0AAAD///////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////s pcEANyAJBAAA8BK/AAAAAAAAEAAAAAAABAAAvxgAAA4AYmpialUWVRYAAAAAAAAAAAAAAAAAAAAA AAAJBBYAIiYAADd8AAA3fAAAvxQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD//w8AAAAA AAAAAAD//w8AAAAAAAAAAAD//w8AAAAAAAAAAAAAAAAAAAAAAGwAAAAAAKgAAAAAAAAAqAAAAKgA AAAAAAAAqAAAAAAAAACoAAAAAAAAAKgAAAAAAAAAqAAAABQA

"Denmark B. Weatherburn" wrote: > This is a multi-part message in MIME format. > > ------=_NextPart_000_006D_01BF980D.AFB2F140 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: 7bit > > Hi Listers, > > [Denmark Weatherburn] > > I've inserted screen output below of an ontape restore for one dbspace only. > Please tell me if I'm not doing something correctly. You did not roll forward the logical logs. In the dbspace table on the server is recorded the logical log number and position needed to bring that dbspace to a consistent state. Your archive began on an earlier log number and so when the restore completed the engine marked the dbspace to state 'I' inconsistent. If you are recovering from user error, rather than some disk failure, and do not want the logs rolled forward you have to contact tech support now to force the chunk to be online. Otherwise start the restore all over again and this time roll the logs forward. Art S. Kagel > > I restored with IDS online. This dbspace has one database. > However, It might also have some indexes from another database in another > dbspace that was online. Although there was no activity on this database. > > bbankbz{spsusr}/export/home/SXXICORE/spsusr>ontape -r -D sxxicoredbs > DBspace 'sxxicoredbs' is online; restoring 'sxxicoredbs' will bring all > chunks > comprising the DBspace OFFLINE and will terminate all active > transactions and queries accessing the DBspace. > > OK to continue?y > > Please mount tape 1 on /export/home/informix/Backups/ontape and press Return > to > continue ... > > Archive Tape Information > > Tape type: Archive Backup Tape > Online version: Informix Dynamic Server Version 7.30.UC3 > Archive date: Mon Mar 27 13:48:16 2000 > User id: sxxiop > Terminal id: ? > Archive level: 0 > Tape device: /export/home/informix/Backups/ontape > Tape blocksize (in k): 16 > Tape size (in k): 3000000 > Tape number in series: 1 > Continue restore? (y/n)y > > Spaces to restore:1 [sxxicoredbs ] > Restore a level 1 archive (y/n) > Restore a level 1 archive (y/n) n > Do you want to restore log tapes? (y/n)n > Partial system restore is incomplete. > > Program over. > bbankbz{spsusr}/export/home/SXXICORE/spsusr>onstat - > > Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 02:26:00 -- > 42272 Kb > ytes > > bbankbz{spsusr}/export/home/SXXICORE/spsusr>onstat -d > > Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 02:26:10 -- > 42272 Kb > ytes > > Dbspaces > address number flags fchunk nchunks flags owner name > b9e6150 1 1 1 1 N informix rootdbs > b9e6ca0 2 1 2 1 N informix physdbs > b9e6d60 3 1 3 1 N informix logsdbs > b9e6e20 4 1 4 1 N informix sxxigldbs > b9e6ee0 5 401 5 1 NP informix sxxicoredbs > b9e6fa0 6 2001 6 1 N T informix tempdbs1 > b9e7060 7 2001 7 1 N T informix tempdbs2 > b9e7120 8 2001 8 1 N T informix tempdbs3 > b9e71e0 9 2001 9 1 N T informix tempdbs4 > b9e72a0 10 2001 10 1 N T informix tempdbs5 > b9e7360 11 2001 11 1 N T informix tempdbs6 > 11 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > b9e6210 1 1 0 25000 22419 PO- /dev/rootdbs > b9e63e0 2 2 0 15000 14447 PO- /dev/physdbs > b9e64c0 3 3 0 50000 24947 PO- /dev/logsdbs > b9e65a0 4 4 0 1000000 839415 PO- /dev/sxxigldbs > b9e6680 5 5 0 1000000 922833 PI- /dev/sxxicoredbs > b9e6760 6 6 0 25000 24947 PO- /dev/tempsdbs > b9e6840 7 7 25001 25000 24947 PO- /dev/tempsdbs > b9e6920 8 8 50001 25000 24947 PO- /dev/tempsdbs > b9e6a00 9 9 75001 25000 24947 PO- /dev/tempsdbs > b9e6ae0 10 10 100001 25000 24947 PO- /dev/tempsdbs > b9e6bc0 11 11 125001 25000 24947 PO- /dev/tempsdbs > 11 active, 2047 maximum > > bbankbz{spsusr}/export/home/SXXICORE/spsusr>onspaces -s sxxicoredbs -p > /dev/sxxi > coredbs -o 0 -O > The chunk specified is already online. > bbankbz{spsusr}/export/home/SXXICORE/spsusr>onstat - > > Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 02:32:12 -- > 42272 Kb > ytes > > bbankbz{spsusr}/export/home/SXXICORE/spsusr>onstat -d > > Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 02:32:18 -- > 42272 Kb > ytes > > Dbspaces > address number flags fchunk nchunks flags owner name > b9e6150 1 1 1 1 N informix rootdbs > b9e6ca0 2 1 2 1 N informix physdbs > b9e6d60 3 1 3 1 N informix logsdbs > b9e6e20 4 1 4 1 N informix sxxigldbs > b9e6ee0 5 401 5 1 NP informix sxxicoredbs > b9e6fa0 6 2001 6 1 N T informix tempdbs1 > b9e7060 7 2001 7 1 N T informix tempdbs2 > b9e7120 8 2001 8 1 N T informix tempdbs3 > b9e71e0 9 2001 9 1 N T informix tempdbs4 > b9e72a0 10 2001 10 1 N T informix tempdbs5 > b9e7360 11 2001 11 1 N T informix tempdbs6 > 11 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > b9e6210 1 1 0 25000 22419 PO- /dev/rootdbs > b9e63e0 2 2 0 15000 14447 PO- /dev/physdbs > b9e64c0 3 3 0 50000 24947 PO- /dev/logsdbs > b9e65a0 4 4 0 1000000 839415 PO- /dev/sxxigldbs > b9e6680 5 5 0 1000000 922833 PI- /dev/sxxicoredbs > b9e6760 6 6 0 25000 24947 PO- /dev/tempsdbs > b9e6840 7 7 25001 25000 24947 PO- /dev/tempsdbs > b9e6920 8 8 50001 25000 24947 PO- /dev/tempsdbs > b9e6a00 9 9 75001 25000 24947 PO- /dev/tempsdbs > b9e6ae0 10 10 100001 25000 24947 PO- /dev/tempsdbs > b9e6bc0 11 11 125001 25000 24947 PO- /dev/tempsdbs > 11 active, 2047 maximum > > bbankbz{spsusr}/export/home/SXXICORE/spsusr> > > Thanks in advance for your help. > > Denmark W. > > ------=_NextPart_000_006D_01BF980D.AFB2F140 > Content-Type: application/msword; > name="dbsrestore.doc" > Content-Transfer-Encoding: base64 > Content-Disposition: attachment; > filename="dbsrestore.doc" > > 0

You can only bring back a dbspace on-line (O) if you have backed up the logical log files and give it to ontape when you restore the dbspace. Otherwise the restore will leave the dbspace in Incompatible state. YES, this behaviour is perhaps too strict in some situation. > > bbankbz{spsusr}/export/home/SXXICORE/spsusr>ontape -r -D sxxicoredbs > DBspace 'sxxicoredbs' is online; restoring 'sxxicoredbs' will bring all > chunks > comprising the DBspace OFFLINE and will terminate all active > transactions and queries accessing the DBspace. > > OK to continue?y > > Please mount tape 1 on /export/home/informix/Backups/ontape and press Return > to > continue ... > > Archive Tape Information > > Tape type: Archive Backup Tape > Online version: Informix Dynamic Server Version 7.30.UC3 > Archive date: Mon Mar 27 13:48:16 2000 > User id: sxxiop > Terminal id: ? > Archive level: 0 > Tape device: /export/home/informix/Backups/ontape > Tape blocksize (in k): 16 > Tape size (in k): 3000000 > Tape number in series: 1 > Continue restore? (y/n)y > > Spaces to restore:1 [sxxicoredbs ] > Restore a level 1 archive (y/n) > Restore a level 1 archive (y/n) n > Do you want to restore log tapes? (y/n)n > Partial system restore is incomplete. > > Program over.