Question on Actualize_all

[Sri]

Hi Erman,

We have ran actualize_all following the below steps.
$ adop phase=prepare
$ adop phase=actualize_all
$ adop phase=finalize finalize_mode=full
$ adop phase=cutover
$ adop phase=cleanup cleanup_mode=full

we dont find any errors in logs and all the ddls executed successfully.but we still see the editions in active state as below,Above steps didnt remove old editions.

ORA$BASE                 ACTIVE
V_20170104_1115          ACTIVE
V_20170105_1144          ACTIVE
V_20170904_1329          ACTIVE
V_20170905_1612          ACTIVE
V_20170920_1550          ACTIVE
V_20170922_1009 OLD      ACTIVE
V_20170910_1417 RUN      ACTIVE  CURRENT

we need your help erman,any references

Thank you

[ErmanArslansOracleBlog]

interesting.

Actually; Oracle documents say : You can drop "all" old database editions by running the adop actualize_all phase and then performing a full cleanup.

Anyways, send me the actualize_all log.. I want to check it and see how it decides the editions to be removed.

[ErmanArslansOracleBlog]

Probably, adop does ALTER object COMPILE to actualize the object.

ALTER object COMPILE always actualizes the objects.

[ErmanArslansOracleBlog]

Send me the log anyways..


Later we may try the following; (but not now)

Execute->
exec sys.ad_zd_sys.retire_old_editions;
After that, check the editions once again.

[ErmanArslansOracleBlog]

Update -->

send me the logs of all the phases, not only the actualize_all log.