Before you upgrade any of our products. After you take a backup reindex.
SQL server
EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 80)”
postgres
find -name psql
bin/reindexdb -d VCDB -U postgres
Before you upgrade any of our products. After you take a backup reindex.
SQL server
EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 80)”
postgres
find -name psql
bin/reindexdb -d VCDB -U postgres
From the postgres binaries
find -name psql
/opt/vmware/vpostgres/9.1/bin/psql
cd /opt/vmware/vpostgres/9.1/bin
./pg_dump -U secureall -t gss_false_vxlan > gss_false_vxlan.bak
./psql -U secureall -f gss_false_vxlan.bak
Application logs showing
double register of key xxx
ERROR: invalid page in block x of relation pg_tblspc/x/x/x/x
ERROR: missing chunk number * for toast value * in pg_toast_*
checksum mismatch: disk has 0, should be xxx
DETAIL could not open file “$psql/pg_clog/####”: No such file or directory
cp: cannot stat `pg_xlog/
Error “MultiXactId has not been created yet — apparent wraparound”
Yvonne Murphy. Oracle Certified Master. VMware Certified Professional, Member of the Office of the Chief Technical Ambassador VMware.
My role in VMware is to support customers running any Oracle product in a VM. But in all honestly Oracle do a great job of this so that doesn’t keep me busy.
There’s a lot of opportunities for a DBA to make herself useful in GSS though. I’m like a ninga. I go into those black boxes and I do some tricks in the database. Most of the blogs here are those scripts I use.
Do remember a bunny dies everytime you make a chance on one of these databases. so backup first!