Oracle-dba-fresher-help

This blog post is a quick summary of How to become a DBA course – A 100% free course which speaks about everything you need to become an Oracle DBA. Learning SQL is just not enough to become an Oracle DBA. You need much more skills and learn other things to crack your first job interview. In this blog post, I would like to talk about 15 things you must know as a Junior (Fresher) DBA even before you would like to start your career as database administrator. 1. Linux Administration 98% of the servers in all the MNCs out there use Unix or Linux operating system. It is obvious that the Oracle database you will be working on would also be hosted on some Linux server. And, not having good hands-on knowledge on Linux will be one of the biggest road blocks in your path to become a DBA. 2. Virtualization Now that you know the importance of Linux operating system, the next big question is how to practice it. In order to learn Linux, you need to install it on your laptop (or desktop) to master it...

. Usually We start by checking on call mailbox for any alerts/issues like following OEM Alerts Mount point full Tablespace alert Listener down Server down Backups failuer . Shift handover report, it contains pending request. . Daily tickets/Incidents by using available ticketing tool. .Daily scheduled Change Req & Service Req as per schedule. . Alert log error checking. . Verify all instances are online. . Check tablespaces should not be used more that 95% . Check all last night backups were successful. . Check OEM Alerts and resolve them. . Schema level refreshing by using exp/imp, expdp/impdp. . Explaining the plans for particular table to tune the databases. . Taking backups by using RMAN on daily and weekly basis.

can we create an SR  for clarifying why napply option of opatch is used exactly . http://docs.oracle.com/cd/E11882_01/em.112/e12255/oui7_opatch.htm#OUICG319 1) Napply Command for OUI-based Oracle Homes This command applies interim patches to several Oracle homes at the same time. 2) Or is it used ofr applying multiple patches in single shot  ?

1) During hot backup db/tbsp is put into backup mode, "alter database begin backup;" or "alter tablespace tbsp_name begin backup;" 2) Then we copy datafiles to disk or tape, cp *.dbf  /backup 3) Take db out of backup mode. "alter database end backup;" or "alter tablespace tbsp_name end backup;" 4) Check the backup mode from V$BACKUP view. "select status from v$backup;"  if status is active means there are some files still in backup mode  if status is not active means no files are in backup mode we have a couple of questions here which we face in every interview???? Is the datafile available for dml during backup? If not, then where is the data going ? The misconception start what is actually done during hot backup, is data file opens writeable during backup process? or changes are stored somewhere in the SGA, the redologs, the rollback/undo segments or some combination thereof, and then written back into the da...

Oracle Database Architecture: oracle db is split into 2 parts : logical + physical logical= memory + background process memory here means the physical memory which is assigned to oracle bg process are some mandatory process which run to maintain the database sanity. physical = all the files which actually contain the data which the end user want to hold on a database.