Oracle11g Workshop
Notes from 11g Oracle workshop
1) 11.2.0.2 Premier Support ends January 2015
2) Options to minimize downtime:
a. Truncate AUD$ table
b. Turn archiving off
c. Collect Dictionary stats
3) Notes:
a. 251.1 Upgrade Advisor
b. 785351.1 Upgrade Companion (Plan)
c. 837570.1 Checklist
d. 756388.1 Recommended Patches
e. 161818.1 Alerts
f. 169706.1 O/S patches
g. 1277424.1 Demo Upgrade
4) Sanity Operations
a. Check for invalid objects
b. Fix invalid objects before the upgrade
c. No invalid on sys and system
d. Purge recycle bin
e. Save a copy of the old init.ora file
f. Remove old init.ora parameters, events and underscores
5) Preparation
a. Preserve performance stats
b. Test performance
c. Gather performance stats 30 days prior to upgrade using AWR
6) Patches before upgrade
a. 11.2.0.2 is the newest patchset
b. Apply latest PSU
c. Bundled patches
d. Patches for known issues
7) Post Upgrade Steps
a. Recompile invalid objects
b. Gather stats
c. Check status of objects and stats
d. Create an editable init.ora from spfile
e. TimeZone DST V11 or higher
f. Gather workload stats (system stats) during regular workload plus when workload changes or there are HW changes
g. Gather fixed table stats
h. Check default values for maintenance windows for jobs
i. Document lessons learned in an Issues Log
j. Document all changes in a Change Log
8) Alternatives
a. Data Guard Physical Standby
b. Transient Logical Standby (for 11g only)
9) Password sensitivity in 11g (applies to database links also)
10) Fallback/Backout strategy
a. During Upgrade:
i. Offline Backup – copy sys, system, tablespaces/datafiles
ii. Flashback DB
b. After Upgrade:
i. Exp/Imp from 11g to 10g (downgrade)
ii. Golden Gate/Streams/ Shareplex
Hope this helps! Rupam
