You can run a backup from an active Fault-Tolerant Secondary SpectroSERVER and load it on the primary in a case where you don't have an available or viable backup from the primary.
We ran into this during a recent upgrade. One of our Primary SpectroSERVERs crashed (core dump) right after upgrading, and Spectrum refused to load the backup we ran just before the upgrade. We ended up dumping a backup from the Fault-Tolerant Secondary server, and loading that on the primary. I'm guessing support probably wouldn't be happy with this, but it seemed like a better option than downgrading (which is typically unsupported, thank you CA), importing the backup, and then upgrading again. I wouldn't recommend it except as a last resort, but It Worked For Us (tm). -- Christopher Cashell Enterprise Systems Engineer West Corporation -----Original Message----- From: James Wiedel [mailto:wie...@usc.edu] Sent: Sunday, February 28, 2016 2:33 PM To: spectrum <spectrum@listserv.unc.edu> Cc: spectrum <spectrum@listserv.unc.edu> Subject: Re: :[spectrum] load db from secondary server on primary after crash. Hi Jon, There should be a viable backup that was used to send to the secondary system from the last automated online backup unless something happened to it in the meantime. If the file is still there, reload the database from the control panel and initialize the database when that question pops up. Once it reloads the database successfully you should be able to start the Spectroserver normally. Make SURE you are talking to the primary system! If the primary's backup database is damaged or missing you can try this: (I've never tried this but it should work) On the secondary system do an online backup (via OneClick). When that is finished you can FTP the backed up database to the primary server putting it in the same directory that the normal online backups are going (default is the SS-DB-Backup directory or something close to that). Then reload the database on the primary system via the control panel. Say yes to the initialize question. Once reloaded you should be able to restart SpectroSERVER via the control panel. If for some reason you can't make the secondary do an online database save you will need to stop the secondary SpectroSERVER then manually do the backup with the command line utility SSDbsave located in the SS-Tools directory. Then FTP the resultant save to the primary and reload it there. I hope some of this helps! James Sent from my iPhone > On Feb 28, 2016, at 1:58 AM, Jon Magnus Dullerud <dulle...@gmail.com> wrote: > > Hi. > My primary ss vent down last night, so I am running an the failover. > The backup in the primary doesn't load either when I try to load it it says: > ERROR: This application has been started using a Spectrum db with was not > GRACEFULLY CLOSED. > The application > will now shut down to allow you to load a previously saved good db. > > Since the failover is running it´s not a big problem for now. We are also in > the progress of setting up a new environment so I dont want to use to much > time on this old one. > My question is: is there a way to load the db on the failover on the primary, > I will have to load it on the primary with a precedence lover than it runs on > the failover. > Is it doable? > > Best Regards > Jon magnus Dullerud > --- > To unsubscribe from spectrum, send email to lists...@unc.edu with the body: > unsubscribe spectrum wie...@usc.edu --- To unsubscribe from spectrum, send email to lists...@unc.edu with the body: unsubscribe spectrum cpcash...@west.com --- To unsubscribe from spectrum, send email to lists...@unc.edu with the body: unsubscribe spectrum arch...@mail-archive.com
