Capabilities for Oracle

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on Oracle. For more information about the requirements, access privileges, and other features of HVR when using Aurora MySQL for replication, see Requirements for Oracle.

Capture

HVR supports the following capabilities on Oracle:

  • Capture changes from location (Oracle version 9.2 and above)
  • Log-based capture (capture from DBMS logging system) (Oracle version 9.2 and above)
  • Log-based capture of tables without a primary key (Oracle version 10.0 and above)
  • Direct access to logs on a file system (Oracle version 9.2 and above)
  • Access to logs using SQL interface (Oracle version 9.2 and above, since HVR 5.3.1/12)
  • Log-based capture with /LogReadMethod param (Oracle version 9.2 and above)
  • Log-based capture of tables with LOB column (Oracle version 10.0 and above)
  • Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId) (Oracle version 9.2 and above)
  • Rewind log-based capture to specific time (hvrinit option -i) (Oracle version 9.2 and above)
  • Rewind log-based capture to the beginning of currently active oldest transaction (Oracle version 10.0 and above)
  • Rewind log-based capture to the beginning of currently active oldest transaction for a specific list of tables (Oracle version 10.0 and above)
  • Online refresh using accurate LSN/SCN (Oracle version 10.0 and above)
  • Online refresh skips capture log records early in scanner (Oracle version 10.0 and above)
  • Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions (Oracle version 9.2 and above)
  • Log-based capture of truncate table statements (Oracle version 9.2 and above)
  • Multiple log-based capture jobs can capture from same database (Oracle version 9.2 and above)
  • Capture from tables with basic compression (Oracle version 11.2.0.4 and above)
  • Capture from tables with compress for all operations' or 'create index ... compress (Oracle version 11.2.0.4 and above)
  • Capture from tables with lob(...) store as securefile ( deduplicate compress ) (Oracle version 11.2.0.4 and above)
  • Log-based capture checkpointing (action Capture /CheckpointingFrequency) (Oracle version 9.2 and above)
  • hvrlogrelease to preserve journal/archives (Oracle version 9.2 and above)
  • Read archives from an alternative directory (Capture /ArchiveLogPath) (Oracle version 10.0 and above)
  • Trigger-based capture (action Capture /TriggerBased) (Oracle version 9.2 and above)
  • Capture /QuickToggle (Oracle version 9.2 and above)
  • Boundaries between transactions preserved by trigger-based capture (Oracle version 9.2 and above)
  • Trigger-based capture jobs can be woken by db-event when change happens (Oracle version 10.0 and above)


HVR Hub

HVR supports Hub database (Oracle version 9.2 and above)


Integrate

HVR supports the following capabilities on Oracle:

  • Integrate changes into location (Oracle version 9.2 and above)
  • Integrate with /Burst (Oracle version 9.2 and above)
  • Integrate with /BurstCommitFrequency (Oracle version 9.2 and above)
  • Continuous integration (Integrate without /Burst) (Oracle version 9.2 and above)
  • Action TableProperties with /DuplicateRows for continuous integration (Oracle version 9.2 and above)
  • Continuous integrate with /OnErrorSaveFailed (without /Burst) (Oracle version 9.2 and above)
  • Action Transform /SoftDelete (Oracle version 9.2 and above)
  • Creation and update of HVR state tables
  • Integrate with /DbProc (Oracle version 9.2 and above)


HVR does not support the following capabilities on Oracle:

  • Disable/enable database triggers during integrate (/NoTriggerFiring)


Bi-directional Replication

HVR supports the following capabilities on Oracle:

  • Detection of changes made by HVR in a bidirectional channel to prevent loop-back (Oracle version 9.2 and above)
  • Collision Detect with Log-based Capture (without /TimestampColumn) (Oracle version 9.2 and above)
  • Collision Detect with Trigger-based Capture (with Capture /TriggerBased and without Collision Detect /TimestampColumn) (Oracle version 9.2 and above)
  • Collision Detect with /TimestampColumn (Oracle version 9.2 and above)


Refresh and Compare

HVR supports the following capabilities on Oracle:

  • Refresh or Compare from source location
  • Refresh into target location
  • Row-wise refresh into target location (option -g)
  • Disable/enable foreign keys and secondary indices during refresh (option -F)
  • Disable/enable constraints check during refresh
  • Defer foreign keys during refresh (option -F)
  • Disable/enable triggers during refresh (option -f)
  • Replicate database sequences (using action DbSequence) (Oracle version 9.2 and above)
  • Suggestions in GUI for Slice Boundaries using DBMS statistics (refresh option -S) (Oracle version 11.0 and above, since HVR 5.3.1/21)
  • Select data from each table from same consistent moment in time (refresh options -Mnow, -Mscn=val, -Mhvr_tx_seq=val, -Mtime)
  • Select data from each table from same consistent moment in time using a single transaction (and session) with 'serializable' SQL isolation level (refresh option -Mserializable)
  • Enable foreign keys immediately after refresh option -Mserializable as done on -Msnapshot and -Mnow


Other Capabilities

HVR supports the following capabilities on Oracle:

  • Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc) (Oracle version 9.2 and above)
  • DbObjectGeneration with /IncludeSQLFile (Oracle version 9.2 and above)
  • International table and column names where DBMS is not configured with UTF-8 encoding
  • Treat DBMS table names and columns case sensitive (action LocationProperties /CaseSensitiveNames)
  • Reduce width of datatype when selecting or capturing changes (action ColumnProperties /TrimDatatype)


HVR does not support the following capabilities on Oracle:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)