Oracle Streams consists of three components. The first is Capture, where data is captured from the Oracle redo logs and packaged into Logical Change Records (LCRs). The LCRs are then moved into the second component, which is the Staging environment. LCRs are stored in the Staging environment until a subscriber picks them up to be used or consumed. Finally, during in the third component, Apply, LCRs are picked up and applied to a database. You can modify LCRs before they are applied to the database.
Of course, Oracle Streams is not the only solution for this type of work. You might want to check out several other ETL (Extract, Transform and Load) tools on the market before committing to the Oracle Streams product. Other products/vendors to consider include Ascential DataStage, Ab Initio and Informatica.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.