deleting huge data from a RAC environment with DR
I have oracle rac 19c with 2 nodes db 19.3 on linux 7 with a single standby database.
i have a process to be run that would delete almost 4M records from 2 tables.
the process is done to commit after every 5000 records being deleted and inserted into another table (the process would select the records from a table and insert them into another table and then to be deleted)
im not sure how run this process as it might impact my standby databases , as with too much data being inserted and deleted a lot of undo/redo will be generated
the process could not be tested as well as no DR site for the UAT environment, and no production datashould be on the TEST