Best Practices
Last modified by Jeff McDonald on 2021/11/17 07:31
Taken fromĀ Five DBA best practices...
Use Multiple Oracle Homes for Patching
Create a second Oracle Home of the same version...
Patch it, switch over.
This assumes both Oracle Homes are pointing to the same table space directories.
Set Audit Trail to DB
What this about?
Don't use the extension .log for redo files
Someone might delete all the .log files
Preview RMAN Restore
Sure, but how?
Create a different linux user for client applications
Don't let client apps run under the 'oracle' username.
Use ADDM for database-wide performance diagnostic.