["Cutting, Jeremiah" -- Sat 09 Apr 2011 02:20:26 AM EEST]
Has anyone had to rebuild a ddm database before? We’re running Spectrum 9.1 on Solaris. A hardware crash killed the drives in our system, so we had to restore from backup. Of course the spectrum/root/mysql/data directory was not restored properly. So we’re missing the ddm and built-in mysql tables. Does anyone know if it’s possible to rebuild these? We’re currently running the archive manager on our failover server, so there might be a way to export or backup that database and restore on the primary. Any suggestions?
For rebuilding the DDM, there is a parameter for 'ddm_load' to initialize it with the proper LH and empty the tables. Otherwise, I think copying the DDM tables (the whole folder from the 'data') from the secondary and running 'ddm_load' again (with initialization) could do the trick.
Cristi Mitrana --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
