DreamPirates DreamPirates

One Minute Oracle SAP Database Administrator (DBA): Server Architecture - Database Files

Author : Elizabeth Huston789
Publish Date : 2021-04-24 06:26:09
One Minute Oracle SAP Database Administrator (DBA): Server Architecture - Database Files

Oracle Server Architecture

One of the first things that one needs to understand about the Oracle RDBMS (Relational Database Management System) is the difference between the terms: "database" and the "instance." This article will discuss the term "database." Briefly, the term database, refers only to the physical files on the operating system.

The Oracle Database

An Oracle database (as opposed to an Oracle instance, which are processes in memory) is a group of files that reside on the physical hardware disk drives and actually store the data. These files consist of:

Data Files: these files contain all the user and application data, as well as undo information, and meta data about the data file itself.
Control Files: these files are the brain of the database and contain information that define the meta data (i.e. data about the data) including the names, locations, and types of the all the other database files.
Online Redo Log Files: these files contain database redo information, or the information to keep track of all changes made to the database if a database needs to be restored and recovered from a database backup. If the database is in "no archive log mode," these online redo log files will be written over as they fill up and cycle to the next one.
Archive Log Files: if the database is in "archive log mode" these files contain the online redo log file information (see above) that have been archived before they are written over. Most databases are in "archive log mode" unless they contain data that will never need to be recovered in between a cold, offline backup. Only databases in "archive log mode" can be backed up with a hot, or online backup.
Temp Files: these files contain temporary data segments that are generated when database sorts are performed.
Database Files Examples:

In a SAP Oracle database environment, the below are typical examples of the directory, or file system structure, and file names. These are examples only. Your system directory structure and file naming standards may vary.

Data Files:

 

https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=c69ab81c-1d12-48e2-981a-9870cc875c54
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=da94cb06-e7ea-4dc5-be63-08fa397732ad
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=edab779c-e12e-43a0-b8b4-14e37ab59357
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=27c658ed-76fb-4662-bdfa-68d8f21e09e9
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=e1a1241f-061c-43ac-9e06-95ac8f5193d3

 

 

/oracle/CPQ/sapdata1/system_1/system.data1

/oracle/CPQ/sapdata2/temp_1/temp.data1cd

/oracle/CPQ/sapdata3/undo_1/undo.data1

/oracle/CPQ/sapdata4/sr3db_1/sr3db.data1

Control Files:

/oracle/CPQ/sapdata1/cntrl/cntrlCPQ.dbf

/oracle/CPQ/origlogA/cntrl/cntrlCPQ.dbf

Online Redo Log Files:

/oracle/CPQ/origlogA/log_g1m1.dbf

/oracle/CPQ/origlogB/log_g2m1.dbf

/oracle/CPQ/mirrlogA/log_g1m2.dbf

/oracle/CPQ/mirrlogB/log_g2m2.dbf

Archive Log Files:

/oracle/CPQ/oraarch/CPQarch1_3325_769904912.dbf

/oracle/CPQ/oraarch/CPQarch1_3326_769904912.dbf

/oracle/CPQ/oraarch/CPQarch1_3327_769904912.dbf

Temp Files:

/oracle/CPQ/sapdata2/temOracle Server Architecture

One of the first things that one needs to understand about the Oracle RDBMS (Relational Database Management System) is the difference between the terms: "database" and the "instance." This article will discuss the term "database." Briefly, the term database, refers only to the physical files on the operating system.

The Oracle Database

An Oracle database (as opposed to an Oracle instance, which are processes in memory) is a group of files that reside on the physical hardware disk drives and actually store the data. These files consist of:

Data Files: these files contain all the user and application data, as well as undo information, and meta data about the data file itself.
Control Files: these files are the brain of the database and contain information that define the meta data (i.e. data about the data) including the names, locations, and types of the all the other database files.
Online Redo Log Files: these files contain database redo information, or the information to keep track of all changes made to the database if a database needs to be restored and recovered from a database backup. If the database is in "no archive log mode," these online redo log files will be written over as they fill up and cycle to the next one.
Archive Log Files: if the database is in "archive log mode" these files contain the online redo log file information (see above) that have been archived before they are written over. Most databases are in "archive log mode" unless they contain data that will never need to be recovered in between a cold, offline backup. Only databases in "archive log mode" can be backed up with a hot, or online backup.
Temp Files: these files contain temporary data segments that are generated when database sorts are performed.
Database Files Examples:

In a SAP Oracle database environment, the below are typical examples of the directory, or file system structure, and file names. These are examples only. Your system directory structure and file naming standards may vary.

Data Files:

/oracle/CPQ/sapdata1/system_1/system.data1

/oracle/CPQ/sapdata2/temp_1/temp.data1cd

/oracle/CPQ/sapdata3/undo_1/undo.data1

/oracle/CPQ/sapdata4/sr3db_1/sr3db.data1

Control Files:

/oracle/CPQ/sapdata1/cntrl/cntrlCPQ.dbf

/oracle/CPQ/origlogA/cntrl/cntrlCPQ.dbf

Online Redo Log Files:

/oracle/CPQ/origlogA/log_g1m1.dbf

/oracle/CPQ/origlogB/log_g2m1.dbf

/oracle/CPQ/mirrlogA/log_g1m2.dbf

/oracle/CPQ/mirrlogB/log_g2m2.dbf

Archive Log Files:

/oracle/CPQ/oraarch/CPQarch1_3325_769904912.dbf

/oracle/CPQ/oraarch/CPQarch1_3326_769904912.dbf

/oracle/CPQ/oraarch/CPQarch1_3327_769904912.dbf

Temp Files:

/oracle/CPQ/sapdata2/temp_1/temp.data1

Congratulations! You have now learned one part of the Oracle Server Architecture: what is meant by the term "database." This short treatment is not meant to cover the topic in detail, but is meant as an introduction, and an enjoyable, painless way toward mastering a complex topic. You should next learn about the Oracle Instance.aOracle Server Architecture

One of the first things that one needs to understand about the Oracle RDBMS (Relational Database Management System) is the difference between the terms: "database" and the "instance." This article will discuss the term "database." Briefly, the term database, refers only to the physical files on the operating system.

The Oracle Database

An Oracle database (as opposed to an Oracle instance, which are processes in memory) is a group of files that reside on the physical hardware disk drives and actually store the data. These files consist of:

Data Files: these files contain all the user and application data, as well as undo information, and meta data about the data file itself.
Control Files: these files are the brain of the database and contain information that define the meta data (i.e. data about the data) including the names, locations, and types of the all the other database files.
Online Redo Log Files: these files contain database redo information, or the information to keep track of all changes made to the database if a database needs to be restored and recovered from a database backup. If the database is in "no archive log mode," these online redo log files will be written over as they fill up and cycle to the next one.
Archive Log Files: if the database is in "archive log mode" these files contain the online redo log file information (see above) that have been archived before they are written over. Most databases are in "archive log mode" unless they contain data that will never need to be recovered in between a cold, offline backup. Only databases in "archive log mode" can be backed up with a hot, or online backup.
Temp Files: these files contain temporary data segments that are generated when database sorts are performed.
Database Files Examples:

In a SAP Oracle database environment, the below are typical examples of the directory, or file system structure, and file names. These are examples only. Your system directory structure and file naming standards may vary.

Data Files:

/oracle/CPQ/sapdata1/system_1/system.data1

/oracle/CPQ/sapdata2/temp_1/temp.data1cd

/oracle/CPQ/sapdata3/undo_1/undo.data1

/oracle/CPQ/sapdata4/sr3db_1/sr3db.data1

Control Files:

/oracle/CPQ/sapdata1/cntrl/cntrlCPQ.dbf

/oracle/CPQ/origlogA/cntrl/cntrlCPQ.dbf

Online Redo Log Files:

/oracle/CPQ/origlogA/log_g1m1.dbf

/oracle/CPQ/origlogB/log_g2m1.dbf

/oracle/CPQ/mirrlogA/log_g1m2.dbf

/oracle/CPQ/mirrlogB/log_g2m2.dbf

Archive Log Files:

/oracle/CPQ/oraarch/CPQarch1_3325_769904912.dbf

/oracle/CPQ/oraarch/CPQarch1_3326_769904912.dbf

/oracle/CPQ/oraarch/CPQarch1_3327_769904912.dbf

Temp Files:

/oracle/CPQ/sapdata2/temp_1/temp.data1

Congratulations! You have now learned one part of the Oracle Server Architecture: what is meant by the term "database." This short treatment is not meant to cover the topic in detail, but is meant as an introduction, and an enjoyable, painless way toward mastering a complex topic. You should next learn about the Oracle Instance.p_1/temp.data1

Congratulations! You have now learned one part of the Oracle Server Architecture: what is meant by the term "database." This short treatment is not meant to cover the topic in detail, but is meant as an introduction, and an enjoyable, painless way toward mastering a complex topic. You should next learn about the Oracle Instance.



Category : general

Guide on Impacts of Deoxygenation on Human Health

Guide on Impacts of Deoxygenation on Human Health

- There are a lot of operations and work going on in the human body. Our organs and most of the body parts can work because the flow of oxygen


Best Sofa Reviews and Buyers Guide

Best Sofa Reviews and Buyers Guide

- With such a large amount of life as of now spent at home, its a higher priority than at any other time to have furniture that works for your life.


Comprehensive Music Education

Comprehensive Music Education

- A comprehensive music education begins early, in childhood. A music education must consist of not only repertoire knowledge, but theory, composition, history, a


In reality, the vast majority of the successful real estate investors

In reality, the vast majority of the successful real estate investors

- Many people have a big misconception about real estate investing. You see, most people mistakenly believe that most real estate investors