Skip to Main Content
Read-only clones for reporting

About This Workshop

Youtube Video

About This Workshop
Refreshable bidirectional read-only clones at the pluggable database level and cross-container operations can be used for data replication and reporting purposes. This workshop use case has two sites, Site A and Site B, but these principles can be applied to a multi-site configuration. Data in local pluggable databases can be updated, and data from read-only refreshable clones can be used for reporting. These clones can be used in read/write mode for testing purposes, too, and re-created when finished because it's not possible to turn them back into refreshable read-only clone mode.

Workshop Info

2 hours

• Prepare cloning environments
Task 1: Create a Virtual Cloud Network
Task 2: Provision Database System
Task 3: Setup workshop environment
Task 4: Prepare application data
Task 5: Create clone administrator

• Deploy cloning configuration 
Task 1: Deploy refreshable clone
Task 2: Configure auto-refresh mode
Task 3: Create global application user
Task 4: Perform cross containers operations
Task 5: Implement two-way site cloning
Task 6: Provide read/write clones to developers

• Access to Oracle Cloud Infrastructure
• Basic understanding of the Oracle Base Database Service
• Basic Oracle Database administration experience

Other Workshops you might like

Other Workshops you might like Cards