DB Installation and Configuration best practices 2
DB Installation and Configuration best practices.
1. export NLS_DATE_FORMAT=”MM-DD-YYYY HH24:MI:SS”
Description:
Environment variable to get the date value upto seconds.This variable we can set in the
.profile or .bash_profile.
Benefits:
Backup logs will be updated with the completed
date format including HH:MI:SS. This is verymuch useful while doing restore and recoveries.
Any Impact:
None
2. Preview RMAN Restore
Description:
Preview RMAN Restore to identify all the various backup pieces that will be
used in the recovery process without doing an actual recovery.
Benefits:
This eliminates any surprises from missing pieces during an actual recovery process.
Any Impact:
None
3. Create a new Oracle user for clients running on the same server as the DB
Description:
Applicable if any application team uses same server for connecting database using client,where databases are running.
Create a new group called “appgrp” and create a new user “oraapp” assign the user to this group.
Benefits:
Security will be maintained properly
Any Impact:
None
4. Automatic startup/shutdown scripts for OEM agents
Description:
Deploy Automatic startup / shutdown scripts in the run level 3 or 5 with the help of Unix Admin Team.
Benefits:
Time will be saved if there are many DB servers in a maintenance window.
Any Imapct:
None
See Also: