|
Latest Article On Oracle Data Guard
|
|
Role Transition
|
|
A Data Guard configuration consists of one database that functions in the primary role and one or more databases that function in standby roles. Typically, the role of each database does not change. However, if Data Guard is used to maintain service in response to a primary database outage, you must initiate a role transition between the current primary database and one standby database in the configuration.
More>>
|
|
|
|
|
|
10 Steps For Becoming a Oracle DBA
|
|
Introduction to Oracle - Step 1
|
|
Oracle provides software to create and manage the Oracle database.Oracle provides software to create and manage the Oracle database. The database consists of physical and logical structures in which system, user, and control information is stored. The software that manages the database is called the Oracle database server.
More>>
|
|
|
Installing Oracle - Step 2
|
|
Before the installation process, Oracle performs a number of automated prerequisite checks to ensure that your machine fulfills the basic hardware and software requirements for an Oracle install.The Oracle Universal Installer guides you through an interview phase that asks you to specify your choices for installation and database creation.
More>>
|
|
|
Oracle Enterprise Manager - STEP 3
|
|
To access the Oracle Enterprise Manager Console from a client browser, the dbconsole process needs to be running on the server.This process is automatically started after installation.Understanding OEM is essential for any Oracle DBA since it provides a visual interface for managing Database.
More>>
|
|
|
Configuring client/server network - STEP 4
|
|
Oracle Net is a software component that resides on the client and the Oracle database server .On the database server side, the Oracle Net listener, commonly known as the listener, is a process that listens for client connection requests. Learn How to establish connection between client and Server witht help of Listeners.
More>>
|
|
|
Oracle Instance - STEP 5
|
|
Oracle Instance comprises of Memory Structures and Background Processes.Oracle creates a set of background processes for an instance that interact with each other and with the operating system to manage memory structure, asynchronously perform I/O to write data to disk, and do general housekeeping.
More>>
|
|
|
Database Storage Structures - STEP 6
|
|
A control file tracks the physical components of the database and other control information. It is essential to the functioning of the database.Every Oracle database has a set of two or more redo log files. The set of redo log files is collectively known as the redo log for the database Learn how DBA manages tablespace,datafiles,undo data,datafiles,Parmater File.
More>>
|
|
|
Database Administrative Accounts - STEP 7
|
|
When you create an Oracle Database, the user SYS is automatically created and granted the DBA role.System privileges, object privileges, and roles provide a basic level of database security. They are designed to control user access to data and to limit SQL statements that users can execute. Learn How to create users and grants them privileges and Roles.
More>>
|
|
|
Managing Oracle Objects - STEP 8
|
|
You can use Enterprise Manager to create or Modify tables. you can do so as a system administrator or user with the CONNECT role.Indexes are optional structures associated with tables. They can be created to improve query performance. Creating and Managing Tables and indexes is the objective of this step.
More>>
|
|
|
Backup, Restore and Recovery Concepts - STEP 9
|
|
The focus in Oracle backup and recovery is generally on the physical backup of database files, which permit the full reconstruction of your database.This step details backup and recovery strategies. Learn How Oracle DBA manages backup, restore and recovery.
More>>
|
|
|
Database Monitoring - STEP 10
|
|
Metrics are a set of statistics for certain system attributes as defined by Oracle. They are computed and stored by the AutomaticWorkload Repository, and are displayed on the All Metrics page.Tuning Database is one of the most challanging task .
More>>
|
|
|
|
|
|
Advanced Tutorials for Oracle DBA
|
|
SQL Statement
Tuning
|
|
Tuning SQL Statement has always been a issue. Because You have to determine the culprit of poor performance. Is it a slow server or a badly tuned SQL Statement? I have made an effort to create a Oracle Tutorial to help dba tuning Statements.
More>>
|
|
|
Backup and Recovery Concepts
|
|
In general, Backup and recovery refers to the various strategies and procedures involved in protecting your database against data loss and reconstructing the data should that loss occur. Read on to learn the most challenging task .
More>>
|
|
|
Oracle 11g New Features
|
|
Oracle 11g makes database infrastructure far more efficient, resilient, and manageable. For example, very compelling new features in the realm of partitioning ease the design and management of partitioned tables immensely. Read this to enhance your knowledge on new features.
More>>
|
|
|
Oracle E Suite & Others
|
|
Learn about Oracle E Suite Benefits & Others Advanced Features like Encryption,oracle release,oracle grid computing,Overview of Database Backup and Recovery Features,installing oracle on unix,data overview,extent overview,segment overview.
More>>
|
|
Oracle Data Guard
|
|
Learn how to use Oracle Data Guard to ensure high availability, data protection, and disaster recovery for enterprise data.
More>>
|
|
Video Tutorials for Oracle DBA
|
|
I came across few good video oracle related tutorials which i am sharing with Oracle Online users.
|
|
|
|
|
