Creating a Logical Standby Database by Using Enterprise Manager

- Creating a Logical Standby Database by Using Enterprise Manager.
- Explain when to use a logical standby database.
- Create a logical standby database by using Enterprise Manager.
- Benefits of Implementing a Logical Standby Database.
- Reduces workload on the primary database by.
- offloading the following workloads to a logical standby database.
- Primary database corruptions not propagated.
- Securing Your Logical Standby Database.
- Preparing to Create a Logical Standby Database.
- Perform the following steps on the primary database before creating a logical standby database:.
- Check for unsupported data types..
- Verify that the primary database is configured for ARCHIVELOG mode..
- Enable supplemental logging..
- Log apply services automatically exclude unsupported objects when applying redo data to the logical standby database..
- Tables with unsupported data types (see list on next page).
- Unsupported Data Types.
- Log apply services automatically exclude tables with unsupported data types when applying redo data to the logical standby database..
- Unsupported data types:.
- Checking for Tables with Unsupported Data Types.
- Query DBA_LOGSTDBY_UNSUPPORTED on the primary database for tables with unsupported data types:.
- Query DBA_LOGSTDBY_NOT_UNIQUE on the primary database to find tables without a unique identifier:.
- Supplemental Logging.
- Enabling Supplemental Logging.
- Manually enable full supplemental logging before you create your logical standby:.
- Verify the values for the following initialization parameters on the primary database.
- Creating a Logical Standby Database with Enterprise Manager.
- Using the Add Standby Database Wizard.
- Select “Create a new logical standby database.”.
- Step 4: Specifying the Standby Database File Locations Access Method.
- Step 4: Specifying the Standby Database File Locations File Locations.
- Step 5: Specifying Standby Database Configuration Parameters.
- Standby Database Creation Processing.
- Logical standby database Redo.
- logs from primary database.
- Explain the advantages of a logical standby database.
- Decide when to use a logical standby database.
- Create a logical standby by using Enterprise Manager.
- Creating a logical standby database using the Add Standby Database Wizard

Xem thử không khả dụng, vui lòng xem tại trang nguồn
hoặc xem Tóm tắt