Hi, Secondary SS should have ArchiveManager disable, so there is not DDM tables on it.
Depending on how your tables are corrupt you can try to recover them. If they are badly corrupted, the only way will be recover them from a backup (ddm_load -i and ddm_load -l <backup_file>. In the knowledge base there is a technical billeting that describe the process (I can't remember the TB number, but here you have a copy): >From a shell or bash shell: If Archive Manager is runninguse mysqlcheck: $ cd $SPECROOT/mysql $ bin/mysqlcheck -uroot -proot ddmdb or $ bin/mysqlcheck --auto-repair -uroot -proot ddmdb <-- if an error is found during the check, automatically fix it after all tables are checked if errors are found: $ bin/mysqlcheck -r -uroot -proot ddmdb <-- repair If Archive Manager isn't runningyou can run myisamchk: $ cd $SPECROOT/mysql $ bin/myisamchk -m data/ddmdb/*.MYI <-- medium check - supposed to catch 99.9% of errors If errors are found: $ bin/myisamchk -r data/ddmdb/*.MYI <-- to recover/repair $ bin/myisamchk -o data/ddmdb/*.MYI <-- old recovery mechanism You can also use a GUI tool to do the same (MySQL GUI Tools 5.0 from mySql web site). It's easier but you need to grant permissions to ddm database in order to be able to connect from a remote location. Good luck. Regads. James. On Sat, Apr 9, 2011 at 9:52 AM, Cristi Mitrana <[email protected]> wrote: > > ["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] > --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
