Hi friends, This is abdul raffeek working as a Sr.Oracle DBA in an Indian Based MNC, I would like to share something about Oracle DBA Work nature, day to day activities and advance concepts.
DBA Work Nature:
As an Oracle DBA, you can expect to be involved in the following tasks:
DBA Work Nature:
As an Oracle DBA, you can expect to be involved in the following tasks:
-
Installing Oracle software
-
Creating Oracle databases
-
Performing upgrades of the database and software to new release levels
-
Starting up and shutting down the database
-
Managing the database's storage structures
-
Managing users and security
-
Managing schema objects, such as tables, indexes, and views
-
Making database backups and performing recovery when necessary
-
Proactively monitoring the database's health and taking preventive or corrective action as required
-
Monitoring and tuning performance
Daily Activities:
In a small to midsize database environment, you might be the sole person performing these tasks. In large, enterprise environments, the job is often divided among several DBAs, each with their own specialty, such as database security or database tuning.
Advance Concepts:
Datagurad, ASM and RAC
Hello Rafiq ....Good Job and idea . All the Best !
ReplyDelete@Vinoth: Thanks Man.
ReplyDeleteHi raffiq i try your script of rman cloning in my laptop linux oracle 10g.
ReplyDeleteI have error they are
Rman-00571
Rman-00569
rman-03002-failure of duplicate db command
rman-03015:error occured in stored script memory SCRIPT.
Rman-06136:oracle error from auxiliary database:ORA-01013 USER REQUESTED CANCEL OF CURRENT OPERATION.
so please fix the error and update new rman cloning scripts .
Hi Buddy check now.
ReplyDeleteHi Raffeek,CPU Utlization is high in server.then what i hve to proceed nxt.then
ReplyDeletehow to analyze from vmstat command.
Hi,
ReplyDeleteNice blog, Thanks for sharing.