Hi Gurus,
I am curious to understand what happens internally when we register a classic extract to database? What is the advantage of doing it?
Reason for curiosity is , I am facing a problem with the classic extract registered with the database. We had a single extract (EX1), pump(EP1) and replicat (RP1) running. On 12th May, we did a switchover of DB from DATACENTER A to DATACENTER B and came back after a week from DATACENTER B to DATACENTER A.
On 31st, May, we created multiple other extracts as part of different configuration. While we saw that ASM got full as archive purge job were not able to delete archives from 12th May onwards. Since space was less, we unregister the extract , run the purge script and re-registered the old extract and new ones.
When I see today, below query shows me all scn pointing to 31st May. So would like to understand, the internals of registering the classic extract and implications of not doing it.
select CAPTURE_NAME,START_SCN,FIRST_SCN,CAPTURED_SCN,REQUIRED_CHECKPOINT_SCN, Status, CHECKPOINT_RETENTION_TIME, capture_type from dba_capture;
Environment
GG - 11.2.1.0.31
DB - 11.2.0.4 - Enterprise.