New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Example 18: Start, Stop, Report , Altering Replicat – Repositioning etc.

Want to know new features in 12c, 18c, 19c, 20c ??? Follow this

More than 100+ features listed here : http://db.geeksinsight.com/category/12c-database/

More than 50+ features listed here: http://db.geeksinsight.com/category/18c-database/

More than 40 features listed here: http://db.geeksinsight.com/category/19c-database/

Upcoming 20c features : http://db.geeksinsight.com/category/20c-database/

As like extract altering, you can also alter the replicat process to reposition to start over replication process from a trail file, Along with reposition with specific Extseqno , you can also reposition to specific date and time especially useful when you regenerate extract trail files or replication abended for some reasons.

Start Stop Replicat start replicat rep3

stop replicat rep3

stop replicat r*

start replicat r*

 starting and stopping replicat process

stop/start replicat process or group that start with r*
Kill Replicat kill replicat rep3 Kill the replicat process when the stop command does not respond
Lag Replicate lag replicat rep3 Shows how much lag replicat is from the extract.
From paritcular extract sequence 
ALTER REPLICAT rep3, EXTSEQNO 53
 Useful when you know which sequence the replicat stop and restart from that point
From particular RBA address 
ALTER REPLICAT rep3, EXTRBA 0

ALTER REPLICAT rep3, EXTRBA 1001
 Useful when the extrail is available and you want to read from particular place to avoid duplicacy of data

0 - means from header

n - means from particular that point.
From Particular date 
ALTER REPLICAT rep3, BEGIN 2011-01-07 08:00:00
 Reads and start replicate from particular date and time
Unregister Unregister replicat rep3  Rather delete if you want to unregister the replicat from database, so ti removes the information from the goldengate metadata.
Delete delete replicat rep3 deletes the replicat from process
cleanup cleanup replicate rep3 cleansup records from checkpoint table , does not delete the replicat