.

 Exadata  Oracle Exadata Smart Flash Cache * Exadata cell -> Flash LUN -> Cell Disk -> Flash Cache/Flash Log  * CELL_FLASH_CACHE - – DEFAULT (LRU), KEEP, NONE * ALTER TABLE <TABLE_NAME> STORAGE(FLASH_CACHE [NONE|DEFAULT|KEEP]) * ALTER INDEX <INDEX NAME> STORAGE(FLASH_CACHE [NONE|DEFAULT|KEEP]) Smart Flash Cache Mode: 1. Write Through Flash Cache Mode (Default):  Write on Disk -> Copy to Flash Cache  * excellent for absorbing repeated random reads  * commonly found in OLTP applications. * dcli -g cell_servers -l celladmin cellcli -e "list cell attributes flashcachemode" * Steps to enable Write-Through Mode CellCLI> ALTER FLASHCACHE ALL FLUSH CellCLI> DROP FLASHCACHE CellCLI> ALTER CELL SHUTDOWN SERVICES CELLSRV CellCLI> ALTER CELL flashCacheMode=WriteThrough CellCLI> ALTER CELL STARTUP SERVICES CELLSRV CellCLI> CREATE FLASHCACHE ALL 2. Write Back Flash Cache Mode:  Write on Flash -> Copy to Disk  * best ...

  Oracle GolgeGate Uses: 1. Data Replication 2. Data Migration 3. Business Continuity and High Availability 4. Data Warehousing 5. Reporting and Analytics 6. Distributed Databases 7. Data Consolidation 8. Zero Downtime Upgrades and Migrations 9. Real-time Data Integration 10. Data Transformation and Filtering GoldenGate Processes  Manager: * controller process  * Control all other processes like extract, pump and replicate.  * allocates port numbers * Perform trail file management. * Start GoldenGate processes including dDynamic pProcesses. * Start the collector process. DYNAMICPORTLIST : specify the ports that Manager can dynamically allocate to Collector and Replicat processes and to GGSCI sessions. Extract:  * runs on source database  * extracts all changes for relevant tables and write to the local trail files. Pump:  * a secondary extract process  * run on source database.  * Read the extracted data from extracted trail file in source da...

 ZDM (Zero Downtime Migration)  Different migration types * Offline/Online  * Physical (RMAN/DataGuard) / Logical (GG/ Datapump)  * Direct/Indirect Connection  Target DB:  * Base Database Service (BaseDB) -Logical/Physical Migration  * Exadata Database Service (ExaDB-D) -Logical/Physical Migration  * Exadata Cloud@Customer (ExaDB-C@C) -Logical/Physical Migration  * Exadata On-Prem -Logical/Physical Migration  * Exadata Cloud@Customer (ADB-C@C) -Logical Migration * Autonomous Database Shared (ADB-S) -Logical Migration * Autonomous Database Dedicated (ADB-D) -Logical Migration   Logical/Physical Migration  * OCI Database Migration (DMS) -Logical Migration Only * Zero Downtime Migration (ZDM) -Software, Logical/Phyiscal Migration * Native tools -DataGuard, DataPump, RMAN, PDB-Unplug/plug, Remote Clone, Relocate, Golden Gate, SQL*Loader, DBLink CTAS,  DBMS_CLOUD, Rest API, SQLcl,...

  ZDLRA (Zero Data Loss Recovery Appliance) ZDLRA: Enrolling Database  1. Create policy:  dbms_ra.create_protection_policy  protection_policy_name=ZDLRA_WEBINAR storage_location_name=DELTA guarantee_copy=no  allow_backup_deletion=no  2. Create VPC (Virtual Private Catalog) user. This defines the catalog name for RMAN   In ZDLRA server node, create vpc user as root user  /opt/oracle.RecoveryAppliance/bin/racli add vpc_user --user_name=vpcwebi  3. Add database  ** link the vpc user with the policy  ** Defines the reserved space for database inside the delta storage   exec dbms_ra.add_db(db_unique_name=> 'ORCL18C', protection_policy_name=> 'ZDLRA_WEBINAR', reserved_space=>'5G');  exec dbms_ra.grant_db_access(db_unique_name=> 'ORCL18C', username=>'vpcwebi'); 4. Client Configuration  (a) Library Installation (ra_linux64.zip)  Download, unzip and copy to $ORACLE_HOME/lib  (b) Wallet and c...