NOV 2008 MAR
1. Created query for DiamondIP to find inconsistant IP addresses between IPAM and DNS. This query will be run before and after Mark imports IPAM data to make sure the data is consistant. 2. Created query for Kenon to disable constraints, truncate tables and reenable everything on the ITSBAR backup database. Kenon will run this procedure monthly. 3. Cleaned up VCMS database. The clean up included the purge scripts from VCMS and Oracle DDL to shrink tables and indexes. Number of Task data is purged : 14963 VPX_EVENT_ARG: 3768335 rows deleted VPX_EVENT: 1505999 rows deleted Number of Stats data is purged : 2726089 6274.922 secs to index VPXI_HIST_STAT: allocated 5GB of free space 8519.012 secs to index VPXII_HIST_STAT: allocated 4GB of free space 3949.399 secs to table VPX_HIST_STAT 12 tables and indexes where altered to shrink space altogether. 4. BMC Service Desk had a problem. Users would receive a fetch error. The forms folder was corrupted. Deleted the forms folder, IISRESET to fix the problem. 5. Created standby database for VCMS. 6. Upgraded VCMS database and application to 2.5. I worked with Kendra on this. This was the process: 1. Export production The whole process took about 17 hours. The database upgrade alone took 11 hours.
7. Upgraded RHN-db from 9.2.0.5 to 9.2.0.8. RHN now allows for any 9i version. RHN is not compatabile with 10G yet. 8. Patched RHN-db with the CPUOCT2008 security patch.
2. Move export to test server
3. Import into test server
4. Upgrade test database
5. Export test database6. Export backup copy of production database
7. Move export to production
8. Import database into production – SERVICE DOWNTIME
9. Upgrade application to point to upgraded database –SERVICE DOWNTIME
10. Backup new database – no downtime