Oracle英文版培训课件之Data Guard Administration：L13_Workshop

WorkshopObjectivesAfter completing this lesson,you should be able to do the following:Explain the workshop methodologyExplain the workshop setupWorkshop PremiseYou are the DBA of a growing company that has decided to implement Oracle Data Guard to protect its Oracle database.You use Enterprise Manager and SQL commands to manage your Data Guard configuration.Workshop FlowIn this workshop,you perform the following tasks:Create one or more standby databases.Verify the configurations.Change the protection mode.Retrieve information from the standby database.Perform failovers.Workshop ScenariosThe workshop comprises the following scenarios:1.Creating a Data Guard configuration to ensure high availability,data protection,and disaster recovery2.Verifying the configuration and the operation of log transport and apply services3.Verifying that the automatic gap detection and resolution feature is working properly4.Changing the protection mode to meet stated requirementsWorkshop Scenarios5.Configuring the feature that will ensure you will not need to re-create the primary database after failover6.Adding a data file to your primary database7.Configuring the standby database so that users can use it for reporting 8.Adding a standby database that will support reporting9.Verifying that the automatic gap detection and resolution feature is working properlyWorkshop Scenarios10.Configuring SQL Apply so that specified DML statements are not executed on the logical standby database11.Creating a new view on the logical standby database12.Performing a failover operation13.Adding your original primary database back into the configuration14.Returning to your original Data Guard configurationSummaryIn this lesson,you should have learned:The flow of the workshopThe setup that is used for the workshopSome hints that will help you through the workshop