Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center