Ok...

But where does the load balancer actually run. Does load balancer main run on AWS, and load balancer backup on Oracle?

also these things don't go down THAT often... well aws, not some others. More uptime that you probably had before. even the stock market takes a few days off every decade. Just ask W.