Database_Move




Project Start:
Project Finish: 		Tue 1:00 PM
Wed 7:50 PM


Tasks

ID
Task Name
DurationStartFinishResource Names% Complete
1
Add Archive log files to DB template
30 minsTue 4:00 PMTue 4:30 PMMaarten100%
2
Create space on pharm
10 minsTue 4:00 PMTue 4:10 PMMaarten100%
3
Test writing to NEWDB
30 minsTue 4:00 PMTue 4:30 PMMarguerite100%
4
Stop DAQ + monitoring
20 minsWed 7:00 AMWed 7:20 AMAndrei100%
5
Stop DV Jobs
10 minsWed 6:50 AMWed 7:00 AMMarguerite100%
6
Stop CatWeb
10 minsWed 6:50 AMWed 7:00 AMMaarten100%
7
Stop DataMover
10 minsTue 8:30 PMTue 8:40 PMBurt100%
8
Stop Radmon
5 minsWed 7:00 AMWed 7:05 AMAndrei100%
9
Shutdown OLDDB
5 minsWed 7:05 AMWed 7:10 AMBolek100%
10
Disable listener on OLDDB (address .65.6)
5 minsWed 7:10 AMWed 7:15 AMBolek100%
11
Startup OLDDB in restricted mode
5 minsWed 7:15 AMWed 7:20 AMBolek100%
12
Do export others.dmp
18 minsWed 7:20 AMWed 7:38 AMBolek100%
13
Do export phoffline.dmp
277 minsWed 7:38 AMWed 12:15 PMBolek100%
14
FTP others.dmp to phast
2 minsWed 7:38 AMWed 7:40 AMBolek100%
15
FTP phoffline.dmp to phast
40 minsWed 12:15 PMWed 12:55 PMMaarten100%
16
Insert new backup tape in OLDDB
15 minsWed 7:20 AMWed 7:35 AMBurt,Andrei100%
17
Start Cold Backup on OLDDB
3.5 hrsWed 2:25 PMWed 5:55 PMBolek0%
18
Create NEWDB
30 minsTue 3:00 PMTue 3:30 PMMaarten100%
19
Backup NEWDB
5 hrsTue 3:30 PMTue 8:30 PMMaarten100%
20
Disable archive log
10 minsTue 8:30 PMTue 8:40 PMMaarten100%
21
Disable listener on .65 on NEWDB
15 minsTue 8:40 PMTue 8:55 PMMaarten100%
22
Start NEWDB in restricted mode
15 minsTue 8:55 PMTue 9:10 PMMaarten100%
23
Start Import others.dmp
38 minsWed 7:40 AMWed 8:18 AMMaarten100%
24
Start Import phoffline.dmp
5 hrsWed 12:55 PMWed 5:55 PMMaarten0%
25
Enable archive log
10 minsWed 5:55 PMWed 6:05 PMMaarten0%
26
Shutdown NEWDB
5 minsWed 6:05 PMWed 6:10 PMMaarten0%
27
Label .65 cable of NEWDB
15 minsTue 4:00 PMTue 4:15 PMBurt100%
28
Find out which clients use .65 addres
30 minsTue 4:00 PMTue 4:30 PMBurt,Andrei75%
29
Update TNSNAMES.ORA for CH clients to new .65 address (phonl2)
1 hrWed 9:30 AMWed 10:30 AMBurt,Andrei100%
30
Disconnect .64 network cable from OLDDB (labeled phdb.phobos.bnl.gov)
5 minsWed 12:55 PMWed 1:00 PMBurt100%
31
Change IP .64 addres on OLDDB
10 minsWed 6:40 PMWed 6:50 PMBolek0%
32
Set NEWDB .64 IP address to phdb.phobos.bnl.gov
10 minsWed 6:10 PMWed 6:20 PMMaarten0%
33
Update NEWDB config files with new host name
10 minsWed 6:20 PMWed 6:30 PMMaarten0%
34
Startup NEWDB in restricted mode
10 minsWed 6:30 PMWed 6:40 PMMaarten0%
35
Test access as sys
15 minsWed 6:40 PMWed 6:55 PMMaarten,Bolek0%
36
Startup NEWDB in production mode
10 minsWed 6:55 PMWed 7:05 PMMaarten0%
37
Test access as webuser/phobdisk
15 minsWed 7:05 PMWed 7:20 PMMaarten,Bolek0%
38
Update Label on .64 OLDDB cable
10 minsWed 12:55 PMWed 1:05 PMBurt0%
39
Reconnect OLDDB .64 cable
10 minsWed 6:55 PMWed 7:05 PMBurt0%
40
Start DAQ + monitoring
15 minsWed 7:20 PMWed 7:35 PMAndrei0%
41
Start DV jobs
15 minsWed 7:35 PMWed 7:50 PMMarguerite0%
42
Start CatWeb
15 minsWed 7:20 PMWed 7:35 PMMaarten0%
43
test DV job
15 minsWed 7:20 PMWed 7:35 PMMarguerite0%
44
test CatWeb operation
15 minsWed 7:35 PMWed 7:50 PMMaarten0%
45
test PhobosWeb
15 minsWed 7:20 PMWed 7:35 PMBolek0%

Resources

IDNameGroupMax UnitsPeak Units
1Maarten 100%100%
2Bolek 100%200%
3Marguerite 100%100%
4Burt 100%200%
5Andrei 100%100%
6Iouri 100%0%

Assignments

Task IDTask NameResource NameWorkStartFinish% Work Complete
1Add Archive log files to DB templateMaarten0.5 hrsTue 4:00 PMTue 4:30 PM100%
2Create space on pharmMaarten0.17 hrsTue 4:00 PMTue 4:10 PM100%
3Test writing to NEWDBMarguerite0.5 hrsTue 4:00 PMTue 4:30 PM100%
4Stop DAQ + monitoringAndrei0.33 hrsWed 7:00 AMWed 7:20 AM100%
5Stop DV JobsMarguerite0.17 hrsWed 6:50 AMWed 7:00 AM100%
6Stop CatWebMaarten0.17 hrsWed 6:50 AMWed 7:00 AM100%
7Stop DataMoverBurt0.17 hrsTue 8:30 PMTue 8:40 PM100%
8Stop RadmonAndrei0.08 hrsWed 7:00 AMWed 7:05 AM100%
9Shutdown OLDDBBolek0.08 hrsWed 7:05 AMWed 7:10 AM100%
10Disable listener on OLDDB (address .65.6)Bolek0.08 hrsWed 7:10 AMWed 7:15 AM100%
11Startup OLDDB in restricted modeBolek0.08 hrsWed 7:15 AMWed 7:20 AM100%
12Do export others.dmpBolek0.3 hrsWed 7:20 AMWed 7:38 AM100%
13Do export phoffline.dmpBolek4.62 hrsWed 7:38 AMWed 12:15 PM100%
14FTP others.dmp to phastBolek0.03 hrsWed 7:38 AMWed 7:40 AM100%
15FTP phoffline.dmp to phastMaarten0.67 hrsWed 12:15 PMWed 12:55 PM100%
16Insert new backup tape in OLDDBBurt0.25 hrsWed 7:20 AMWed 7:35 AM100%
16Insert new backup tape in OLDDBAndrei0.25 hrsWed 7:20 AMWed 7:35 AM100%
17Start Cold Backup on OLDDBBolek3.5 hrsWed 2:25 PMWed 5:55 PM0%
18Create NEWDBMaarten0.5 hrsTue 3:00 PMTue 3:30 PM100%
19Backup NEWDBMaarten5 hrsTue 3:30 PMTue 8:30 PM100%
20Disable archive logMaarten0.17 hrsTue 8:30 PMTue 8:40 PM100%
21Disable listener on .65 on NEWDBMaarten0.25 hrsTue 8:40 PMTue 8:55 PM100%
22Start NEWDB in restricted modeMaarten0.25 hrsTue 8:55 PMTue 9:10 PM100%
23Start Import others.dmpMaarten0.63 hrsWed 7:40 AMWed 8:18 AM100%
24Start Import phoffline.dmpMaarten5 hrsWed 12:55 PMWed 5:55 PM0%
25Enable archive logMaarten0.17 hrsWed 5:55 PMWed 6:05 PM0%
26Shutdown NEWDBMaarten0.08 hrsWed 6:05 PMWed 6:10 PM0%
27Label .65 cable of NEWDBBurt0.25 hrsTue 4:00 PMTue 4:15 PM100%
28Find out which clients use .65 addresBurt0.5 hrsTue 4:00 PMTue 4:30 PM75%
28Find out which clients use .65 addresAndrei0.5 hrsTue 4:00 PMTue 4:30 PM75%
29Update TNSNAMES.ORA for CH clients to new .65 address (phonl2)Burt1 hrWed 9:30 AMWed 10:30 AM100%
29Update TNSNAMES.ORA for CH clients to new .65 address (phonl2)Andrei1 hrWed 9:30 AMWed 10:30 AM100%
30Disconnect .64 network cable from OLDDB (labeled phdb.phobos.bnl.gov)Burt0.08 hrsWed 12:55 PMWed 1:00 PM100%
31Change IP .64 addres on OLDDBBolek0.17 hrsWed 6:40 PMWed 6:50 PM0%
32Set NEWDB .64 IP address to phdb.phobos.bnl.govMaarten0.17 hrsWed 6:10 PMWed 6:20 PM0%
33Update NEWDB config files with new host nameMaarten0.17 hrsWed 6:20 PMWed 6:30 PM0%
34Startup NEWDB in restricted modeMaarten0.17 hrsWed 6:30 PMWed 6:40 PM0%
35Test access as sysMaarten0.25 hrsWed 6:40 PMWed 6:55 PM0%
35Test access as sysBolek0.25 hrsWed 6:40 PMWed 6:55 PM0%
36Startup NEWDB in production modeMaarten0.17 hrsWed 6:55 PMWed 7:05 PM0%
37Test access as webuser/phobdiskMaarten0.25 hrsWed 7:05 PMWed 7:20 PM0%
37Test access as webuser/phobdiskBolek0.25 hrsWed 7:05 PMWed 7:20 PM0%
38Update Label on .64 OLDDB cableBurt0.17 hrsWed 12:55 PMWed 1:05 PM0%
39Reconnect OLDDB .64 cableBurt0.17 hrsWed 6:55 PMWed 7:05 PM0%
40Start DAQ + monitoringAndrei0.25 hrsWed 7:20 PMWed 7:35 PM0%
41Start DV jobsMarguerite0.25 hrsWed 7:35 PMWed 7:50 PM0%
42Start CatWebMaarten0.25 hrsWed 7:20 PMWed 7:35 PM0%
43test DV jobMarguerite0.25 hrsWed 7:20 PMWed 7:35 PM0%
44test CatWeb operationMaarten0.25 hrsWed 7:35 PMWed 7:50 PM0%
45test PhobosWebBolek0.25 hrsWed 7:20 PMWed 7:35 PM0%


Microsoft Home Page
Microsoft Project Home Page