Solved

production

Posted on 2013-11-17
2
168 Views
Last Modified: 2013-11-28
What is a production control oracle dba do?
What is his main tasks..
0
Comment
Question by:dev_dba
2 Comments
 
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 total points
ID: 39655663
Keeping the database in the air and making sure precautions are in place to solve any disasters happening

Maintenance tasks like cleanup of archivelogs, audtiing, etc
Maintaining 1 or more standby databases, making sure it's following the production db
or maintaining a high available database
Making sure the backups have run
Monitoring the database (and server) for performance

Possible disasters:
Wrongly deleting of data or objects
Drive failures/Data corruption
Some degree of electric failures/total datacenter failures
0
 
LVL 23

Accepted Solution

by:
David earned 250 total points
ID: 39656358
Similar to Geert's, but I define my career success as a "steward" of the data owner.  Being responsible for the health and growth of someone else's property.

Data Integrity
Data Availability
Data Confidentiality
from many sources, such as http://security.blogoverflow.com/2012/08/confidentiality-integrity-availability-the-three-components-of-the-cia-triad/

I add:
Data Recoverability - TESTED & DOCUMENTED
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Database creation fails 5 50
oracle report printing 2 pages in one page 2 58
Migrate database to ASM disks. 1 40
File generation using utl_file 4 46
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now