1.
Usually We can check on call mailbox for any alerts/issues like
following
·
Mount point full
·
Tablespace alert
·
Listener down
·
Server down
·
Backups fail
2.
Alert log error checking.
3.
Shift handover report, it contains pending request.
4.
Daily resolving the tickets by using Remedy ticketing tool.
5.
Verify all instances are online.
6.
Deploying the application code to production servers.
7.
Schema level refreshing by using exp/imp, expdp/impdp.
8.
Explaining the plans for particular table to tune the databases.
9.
Taking backups by using RMAN on daily and weekly basis.
10.
Supporting to TAF (Transparent Application Failover).
11.
Check tablespaces should not be used more that 95%
12.
Monitoring the RAC instances by using Cron Tab.
13.
Check all last night backups were successful.
14.
Monitoring the databases by using Cron Tab.
15.
Check all database archiving are done.
From the day one when did i start viewing this blog keeping on surprising really.....
ReplyDeleteam really happy associate with Mr.Nikhil such a great person with a great blog really ...
whenever i find difficulty immediately i look at this blog and i refered so many people to view this great blog...
this is like spoon feeding those who wants to learn oracle dba no need of training at all this is enough ...
hatts off to u mr nikhil....
thanks and regards,
sai.
Thank You Sai for appreciation. I’m glad I could help you.
DeleteRegards
Nikhil Kotak
Its really helpful Nikhil...thanks for sharing your knowledge🙏🙏
ReplyDelete