Page History

...

We propose to switchover to the new oracle databases sometime during the period April 8-11on Monday April 14. We will perform the following steps

Starting midnight Sunday

1. full backup of glast-oracle01 (to NFS disk)Restore into glast-oracle03

Starting 8am Monday

1. Shutdown glast applications
2. Shutdown glast-oracle01 database. <b>All glast database access will be lost at this time.</b>
3. Restore into glast-oracle04oracle03
4. Start Brief (20 min) shutdown to make glast-oracle01 a "primary" server (may not be necessary)as primary databse
5. Switch glast-oracle01 to be a DNS alias Make glast-oracle03 physical standby for glast-oracle01oracle03Make
6. Backup glast-oracle04 physical standby for glast-oracle01
7. Shutdown Glast-apps
8. Shutdown glast-oracle01.
9. Make glast-oracle03 primary and change glast-oracle04 to be standby to glast-oracle02
10. Repoint glast-oracle01 to glast-oracle03
    • POINT OF NO RETURN
11. Restart Glast apps

...

1. oracle03 to NFS disk

Approximately 8pm Monday

1. glast database access restored. <b>glast application can be restarted.</b>
2. Restore backup to glast-oracle04
3. Bring up glast-oracle04 as physical standby to glast-oracle03

Tuessday 8am

1. Short DB outage to switch glast-oracle03 to max availability mode