This content has been marked as final. Show 6 replies
The 21 objects in the recycle bin are all WRH$ objectsBut result of utlu112i.sql shows 834 objects?
I would expect
1) DBUA will stop after the initial check
2) not sure about what will happen during a manual upgrade
But with a backup made before the whole process can be rolled back - if necessary.
Pl also open an SR and request Support for the steps to get around this issue
Yeah, I saw that too. Pretty strange stuff. A serious bug which seems to indicate potential corruption issues.
Yes, I will raise an SR for this.
I did try setting the recyclebin off, but utlu112i script still gives the same warning.
Will feedback the cause and fix once this is resolved.
Just to update on this...
Yesterday I cloned the virtual guest this database was on (taken from a backup on Sunday night). Started up the database and ran 'purge dba_recyclebin' and the command worked.
I then logged into the Test database and did the same command, which also worked (took about 2 minutes to run).
Perhaps a background process has done a cleanup between my Saturday morning attempt and Sunday night?! Anyway,... it works (utlu112i.sql had no issues, and I successfully upgraded the clone).
Edited note: When I started up the db, recyclebin was off. Purge command was run (succeeded). Immediately after this, I set on the recyclebin on (spfile), bounced database and ran purge command again. Still worked okay.
Edited by: stuartu on Nov 29, 2011 10:55 AM
Thanks for the update