Oracle eGDB SDE Repo Upgrade Using Oracle Restore Point

MMBR

 _________________________________________________________________________________________________

Oracle Enterprise Geodatabase SDE Repository Upgrade using an

Oracle Restore Point to Rollback the changes in case of problems.

Download PDF Version

 _________________________________________________________________________________________________

• 1. ArcGIS Documentation - Before you upgrade
• 2. Oracle Archiving and Oracle Flashback
• 3. Create the Restore Point
• 4. Check Invalid Objects
• 5. Privileges Required for Geodatabase Upgrade
• 6. Active Connections
• 7. Upgrade Geodatabase Repository
• 8. Check Invalid Objects
• 9. Recompile Invalid Objects
• 10. Check Invalid Indexes
• 11. RevokePrivileges Required for Geodatabase Upgrade
• 12. Update the ST_GEOMETRY library
• 13. Check Invalid Objects
• 14. Check Invalid Indexes
• 15. Gather new Statistics
• 16. Drop the Restore Point
• 17. Execute RMAN Backup
• Appendix - Restore using flashback database
• FAQ - Frequent Asked Questions

 _________________________________________________________________________________________________

1. ArcGIS Documentation - Before you upgrade