required_checkpoint_scn goes backwards at restart?
This is with 11.2g...
I have two database instances (call them A and connected by streams (single capture process, single propagation process, single apply process on each instance).
At some point I query A to find out what archive log files it needs. If I do:
SELECT r.CONSUMER_NAME,
r.NAME,
r.FIRST_SCN,
r.NEXT_SCN,
r.PURGEABLE
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME;
then I find that the minimum non-purgeable archive file is 366 (1_366_blahblah.dbf).
But if I do the script from Oracle Note 290143.1, it says the minimum required file is 380.
I have two database instances (call them A and connected by streams (single capture process, single propagation process, single apply process on each instance).
At some point I query A to find out what archive log files it needs. If I do:
SELECT r.CONSUMER_NAME,
r.NAME,
r.FIRST_SCN,
r.NEXT_SCN,
r.PURGEABLE
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME;
then I find that the minimum non-purgeable archive file is 366 (1_366_blahblah.dbf).
But if I do the script from Oracle Note 290143.1, it says the minimum required file is 380.
0