Recycling Object_id mechanism in 19.19
Hi all!
Released recently Oracle database 19.19 has Object_id recycling mechanism.
When max object_id in obj$ is close to max permitted value (about 4.3 billion) we can solve problem of potential database unfunctionality using
Mechanism to Recycle Database Object Identifiers (Doc ID 2923706.1)
For that purpose I was trying to build a test environment, but got some issues.
I cloned one of production databases into test. This database has current object_id equal to 3.2 billion. So for testing 19.19 recycling object_id feature I need to increase object_id by 1.1 billion. I developed scripts which created deferred segments tables, sequences and synonyms. After 10 days of running I was almost at object_id = 4.3 billion, and then decided to back-up test database. It was running in noarchivelog mode, so I stopped id. When I tried to start database after backup, I got hang. Reason was simple - 'alter database open' runs some recursive statements, which can not complete