Re: Cannot start 2 instances of OnLine 7.x

Erik A. Widholm wrote: > > June Tong wrote: > > > Erik A. Widholm (ewidholm@moody.edu) wrote: > > : Until recently, we ran our test database on OL 7.x and our production > > : database on OL 5.x with no memory conflicts. Then I upgraded the 5.x to > > : 7.x (dbexport, dbimport, etc.), and got it running. During the upgrade, [SNIP] > *) When I do a ontape -r to restore from tape (from a backup I made just previous > to bringing the production engine on-line) and stop the restore somewhere in > midpoint (by accident today), I can access all loaded tables and run the engine > with no trouble. > > !) When I allow ontape -r to go until completion, that is when I cannot bring up > the engine. This occurs with any of the four or so most recent backups I have (I > haven't gone any further back yet). AAAAAAHHHHHHHHHH!!!!!!!!!!!!!!! You are overwriting the production engine's data everytime you restore! You are creating reserved pages for the test instance in the test instance's rootdb space but then the engine reads the reserved pages that were dumped from the tape and begins to write data read from the tape onto the chunks descibed in the newly dumped reserved pages not the ones you so carefully tried to create after the oninit -i. These are the production chunks! THERE IS NO WAY TO RESTORE AN ARCHIVE FROM ONE INSTANCE ONTO ANOTHER INSTANCE ON THE SAME MACHINE WITHOUT TRASHING THE ORIGINAL INSTANCE! If you want to create a test instance be restoring an archive from the production instance you must restore onto another machine. Art S. Kagel