Pages

Subscribe:

Ads 468x60px

Showing posts with label oracle dba. Show all posts
Showing posts with label oracle dba. Show all posts

Thursday, 30 July 2020

What is Oracle Database?


Oracle Database


Oracle Database  is one product among others forming the Oracle  suite (Oracle Database, Oracle Application Server, Oracle Developer Suite, Oracle Enterprise Manager Grid Control…).

Oracle Database  is the Oracle database management system that allows multiple users to access data simultaneously while ensuring availability and disaster recovery mechanisms.

Be aware that Oracle Database refers to the entire Oracle software, while database has a specific meaning in the Oracle architecture.

To guarantee a high level of performance, Oracle maintains the database thanks to memory structures (in random access memory: RAM) and physical structures (on hard disk) and uses processes for the storage of data in memory or on disk .

Writing to disk is only performed when necessary and under conditions while Memory is used as much as possible since memory access is faster than disk access (performance gain).


In the event of a power outage, for example, Oracle will be able to recover well if data in memory, at the time of the incident, is not written to disk. This is the recovery of the instance managed by the SMON process discussed later in the oracle architecture.

An instance failure requires recovery, while a physical failure (such as a disk crash) requires a restore followed by a recovery.

Restoration and recovery are two different terms that should be clearly distinguished. The restoration is made from backup files and the recovery allows to reapply to the restored data files, the modifications already made on the base to find the consistent state of the database before the incident.


In the example in the figure, recovery at time t2 requires restoring the last available S1 backup and reimplementing any changes that occurred in the interval t1-t2.

To learn more about the components and basic concepts of the Oracle architecture, take look at our Expert DBA Team Club blog and more advance topics are available at this source.


Tuesday, 21 February 2012

How to become Oracle Specialist?


Developing experience in databases control area is very hard and challenging. But after becoming expert oracle dba you would produce more definitely. How to become Oracle DBA and how to become an expert Oracle dba?. Here are you can find some main suggestions and comprehension providing for improving your capabilities for making yourself as Oracle expert.

There are a lot of fastest choices available for getting more comprehension. Thing is that you need to upgrade every day. Every day you need to comprehend something more in same Oracle experience of another experience. Of course, if you are coming up with another experience rather than Oracle databases (because you already Oracle DBA) then it is very best option. Several capabilities always are enabling you to create risky of occupation and need. But if you have level comprehension of Oracle databases with most of Oracle models then it is also better than having comprehension of personal version comprehension.

Above articles identifies more components and some techniques to improve your comprehension as well as experience. This occupation suggestions is arriving from greater experience of my own. During mobile portable remote control control databases support and managing as databases dba, we need greater end of experience because clients are not here with you. They are in search of to end of other international locations and you have only their essential databases web host hosting server. Without looking at their activities you should need to problems firing databases issues or without referring to more components you have to deal with their issue using your techniques and experience. This is not easy procedure to maintain because this is routine procedure as mobile portable remote control control dba.