Free cookie consent management tool by TermsFeed

IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

Active Data Guard and redo compression

Posted on May 30, 2011, updated on July 14, 2015 by Yannick Jaquier

Table of contents

  • Preamble
  • Active Data Guard
  • Redo Compression

Continue reading

Oracle Data Guard Leave a comment

Data Guard Broker configuration with failover and switchover testing

Posted on May 27, 2011, updated on June 17, 2014 by Yannick Jaquier

Table of contents

  • Preamble
  • Data Guard Broker configuration
  • Switchover
  • Failover
  • References

Continue reading

Oracle Data Guard 3 Comments

Data Guard hands-on with a physical standby database creation

Posted on May 25, 2011, updated on November 12, 2015 by Yannick Jaquier

Table of contents

  • Preamble
  • Prepare primary database
  • Prepare standby database
  • SQL*Net configuration
  • RMAN duplication
  • References

Continue reading

Oracle Data Guard 3 Comments

Oracle restart and listener configuration

Posted on May 24, 2011, updated on January 26, 2016 by Yannick Jaquier

Table of contents

  • Preamble
  • Oracle restart configuration
  • Testing
  • References

Continue reading

Oracle Real Application Clusters (RAC), SQL*Net 4 Comments

GoldenGate hands-on in one hour

Posted on May 11, 2011, updated on March 20, 2023 by Yannick Jaquier

Table of contents

  • GoldenGate installation
  • Manager processes
  • Initial loading
    • Definition file
    • Replication process on source server
    • Replication process on target server
  • Data synchronization
    • Capture and stage processes
    • Apply process
  • Testing
  • Error correction
    • Missing archived log file
    • Archived log in ASM
    • Figures not present in target table
  • References

Continue reading

Oracle GoldenGate 16 Comments

RMAN convert optimization

Posted on April 8, 2011, updated on June 25, 2015 by Yannick Jaquier

When converting a database from one operating system to another one (to phase out your Itanium infrastructure for example) you may be tempted to play with parallelism parameter when converting your tablespaces (having one datafile in our example). This RMAN convert phase is obviously needed when your destination platform endian format is not he same:

Continue reading

Oracle RMAN, Tuning Leave a comment
  • Page 37 of 44
  • « First
  • ‹ Previous
  • 35
  • 36
  • 37(current)
  • 38
  • 39
  • Next ›
  • Last »

Search

Certifications

Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA)
Microsoft Azure Fundamentals Microsoft Azure Solutions Architect Expert

Tags Cloud

Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (42) Ambari (1) Application Continuity (AC) (1) Automatic Data Optimization (ADO) (1) Automatic Diagnostic Repository (ADR) (1) Automatic Memory Management (AMM) (2) Automatic Segment Space Management (ASSM) (1) Automatic Shared Memory Management (ASMM) (4) Automatic SQL Plan Management (ASPM) (1) Automatic SQL Tuning Sets (ASTS) (1) Automatic Storage Management (ASM) (2) Automatic Workload Repository (AWR) (3) Backup (7) Benchmark (7) Bug (1) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Container (4) Database Links (1) Database Migration Assistant for Unicode (DMU) (2) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (9) Data Recovery Advisor (2) Data Redaction (1) DBMS_REDEFINITION (1) Development (12) Directory Naming (3) Docker (4) Edition-Based Redefinition (EBR) (1) Exadata (1) Fast Application Notification (FAN) (1) Fast Connection Failover (FCF) (1) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) Galera (3) GATHER_STATS_JOB (1) GoldenGate (6) Grid Control (4) Grub (1) Health Monitor (2) Heat Map (1) High Availability (35) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) In-Memory (1) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) JSON (1) Kafka (3) Machine Learning (1) Multi-Master Replication Manager (MMM) (1) Multitenant (5) Non-Uniform Memory Access (NUMA) (3) OpenStack (2) OpenView Performance Agent (OVPA) (1) Oracle Configuration Manager (OCM) (1) Oracle Label Security (OLS) (1) oradebug (1) Patch (2) PL/SQL (1) Polymorphic Table Functions (PTF) (1) Privilege Analysis (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (5) Real Application Testing (RAT) (2) Recovery (2) Redo Log (2) Resource Governor (1) RMAN (5) Security (27) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (36) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (2) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (2) SQL Profile (1) SQL Trace (1) SQL Tuning Advisor (STA) (5) SQL Tuning Set (STS) (1) Streams (3) System Global Area (SGA) (1) Tivoli Data Protection for Oracle (TDPO) (2) Tivoli Storage Manager (TSM) (1) Transactional Event Queues (TxEventQ) (1) Transaction Guard (TG) (1) Transparent Application Continuity (TAC) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (54) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

  • AIX (2)
  • Couchbase (2)
  • Databricks (5)
  • Hadoop (21)
  • HPUX (6)
  • Linux (30)
  • MariaDB (20)
  • MongoDB (1)
  • MySQL (30)
  • Oracle (156)
  • PostgreSQL (8)
  • Python (3)
  • SQL Server (11)

Recent Comments

  • SQL Access Advisor and SQL Tuning Advisor in 11gR2 on SQL Access Advisor versus SQL Tuning Advisor
  • Adaptive Query Optimization in action on Cardinality feedback to automatically improve query plans
  • MySQL Utilities versus Master High Availability Manager (MHA) on MySQL Replication with Global Transaction Identifiers (GTID) hands-on
  • geek on SQL Server on Linux – Availability Groups – part 3
  • sai sumanth on SQL Server on Linux – Availability Groups – part 3

Blogroll

  • Ask Tom
  • Kevin Closson’s Oracle Blog
  • Official Pythian Blog
  • Oracle Optimizer
  • Oracle Scratchpad
  • Percona Database Performance Blog
  • Richard Foote’s Oracle Blog
  • Tanel Poder's blog

Visitors

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
IT World Proudly powered by WordPress