Please read the business requirement/scenario below.
The company has four Oracle databases. They're located in Toronto, Vancouver, Winnipeg, and Calgary.
As a policy, each location has a local backup that only backs up the data for that day and every hour of that day. Every 7 days each location makes a full backup of their database and sends it to a remote location for archival.
When a database needs to be restored because of disruption, one location that was not affected by the disruption, creates, runs, and maintains that database until the disrupted location is up and running.
A winter storm hits Winnipeg resulting in them losing all the data in their database. All that they have is the incremental backups from the last 3 days.
1. Analyze the business scenario provided above.
2. Create a report (separate WORD document) include the following three sections. You will need to do some ‘googling’ to find ideas but as the company’s DBA, you need to prepare this set of proposals for management. Modules 9, 10 and 11 discuss this subject as well.
1. Backup strategy – how should the company’s data be backed up to prevent / minimize data loss (include such ideas as offsite storage, etc.
2. Disaster Planning -- list your ideas on how to quickly and effectively restore database operations in the event of a ‘disaster’ such as the scenario above
3. Business Continuity Plan -- explain your ideas for a new Business Continuity Plan and if relevant, what roles (who) should be responsible for some of the steps. What planning, activities, communications, and assessments should be done to prepare for a disaster and to carry out during a disaster?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here