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 17: Start, Stop, Report, Altering Extract – Regenerating, Rolling Over 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/

There are numerous options for extract process and changes from version to version and many new introduced.

Out of them , The following will be useful in the cases as mentioned below.

Starting & Stopping Extract stop extract ext3

start extract ext3

 Starting and stopping extracts
Killing Extract kill extract ext3 Some times extract process does not respond to stop and you need to kill it.
Report Lag of Extract from source lag extract ext3 Reports how much lag extract is from the database, it will provide more information than INFO command
Begin the extract again ALTER EXTRACT EXT3, BEGIN NOW Caution, This will make extract to restart from current SCN, so when you do this you are actually making extract to start fresh replication from current point.

When you are trying to fix and restarting extract, you should use

start extract ext3
Restart extract from specific date and time 
ALTER EXTRACT ext3, BEGIN 2015-07-13
 Useful when you missed some extract files and replication is abended

but ensure this will reset extract trail
Restart extract from specific date and time & rollover 
ALTER EXTRACT ext3, BEGIN 2015-07-13, etrollover
 This will restart the extract to read specific time and also start new sequence number. The replicat must be modified to read from this new sequence on target

alter replicat rep3 , extseqno 1
Extract to start processing at a specific location in the trail. 
ALTER EXTRACT ext3, EXTSEQNO 26, EXTRBA 338
 Useful when extract abended for any reasons and you want to restart the extract to regenerate those redo records from that particular sequence at particular RBS

You can find the RBA and SEQNO in extract info, where its abended. or replicat

info extract ext3, detail

info replicat rep3, detail
For RAC, read for specific thread 
ALTER EXTRACT ext3, THREAD 4, BEGIN 2015-07-13
 For rac environments if you want extract process reads from thread 4 for the said date.
Start new sequence for Extract 
ALTER EXTRACT ext3, ETROLLOVER
 This will create new extract sequence no. and replicat must ensure to start from new sequence

alter replicat rep3, extseqno 1
For Oracle , Particular SCN 
ALTER EXTRACT ext3, SCN 778899

For particular log sequence
ALTER EXTRACT ext3, logseqno 18
 For oracle , to read from specific scn & specific log file sequence, This is differ from extseqno
For SQL Server, Particular LSN 
ALTER EXTRACT ext3, LSN 3454:875:445
 For MS-SQL Server, to start over from particular LSN number
For DB2, particular LRI ALTER EXTRACT ext3, TRANLOG LRI 8066.322711 For DB2 LUW, to restart the extract from particular LRI
Unregister  Unregister extract ext3  Unregister extract from database
Delete Extract delete extract ext3 Deletes the extract
cleanup cleanup extract ext3 this will just clean the records from checkpoint table , not deletes the extract