Learning overview Oracle Rdbms

Oracle is still quite common, So I studied Oracle Rdbms and shared it with you here. I hope it will be useful to you. This is just to lay some foundation for future security, because we will use them later. Haha ~!

1. components contained in Oracle:

An Oracle Database refers to the entire Oracle Rdbms environment. It includes the following components:
◆ Oracle Database process and buffer instance ).
◆ The SYSTEM tablespace contains a centralized SYSTEM category, which can be composed of one or more data files.
◆ Other tablespaces defined by the database administrator (DBA). Each tablespace consists of one or more data files.
◆ More than two online recovery logs.
◆ Optional ).
◆ Other file control files, Init. ora, Config. ora, etc ).
Each Oracle database runs on a central SYSTEM category and data dictionary. It is located in the SYSTEM tablespace.

2. About "logs"

Oracle databases use several structures to protect data: database backup, logs, rollback segments, and control files. Here we will take a general look at the "log" as one of the main structures ":

Each Oracle database instance provides logs to record all modifications made in the database. Each running Oracle database instance has an online log, which works with the Oracle background process LGWR and immediately records all modifications made to the instance. Offline archiving) logs are optional. Once an Oracle database instance is filled with online logs, an online log archive file can be formed. Archived online log files are uniquely identified and merged into archived logs.

◆ Online logs: each instance of an Oracle database has an associated online log. An online log consists of multiple online log files. Online log file (online redo log file) is filled with the log item redo entry). The data recorded in the log item is used to reconstruct all modifications made to the database.

◆ Archive logs: Archive logs must be created when Oracle wants to archive the filled online log File groups ). It is useful for database backup and recovery:
<1> database backup and online and archive log files Ensure that all submitted items can be recovered in case of an operating system or disk failure.
<2> online backup can be used if the archived logs are permanently saved when the database is enabled and normally used by the system.

Databases can run in NOARCHIVELOG or ARCHIVELOG modes. When a database is used in NOARCHIVELOG mode, online logs cannot be archived. If the database runs in ARCHIVELOG mode, you can archive online logs.

3. physical and logical storage structure:

Oracle Rdbms is composed of tablespaces, and tablespaces are composed of data files. The tablespace data file is formatted as an internal block unit. The block size is set by DBA when Oracle was first created. It can be changed within the range of 512 to 8192 bytes. When an object is created in an Oracle tablespace, the user uses the initial length (initial extent), the next length (next extent), and the minimum length (min extents) and max extents) to indicate the size of the object space. The length of an Oracle database can be changed, but it must contain a chain consisting of at least five consecutive blocks.

4. The networking protocol for Oracle compared with Microsoft SQL Server.

1. Analysis and Discussion on Oracle Database Restoration
2. Oracle remote disk image
3. New Oracle 11g function display
4. Detailed analysis of Oracle XML data
5. Oracle Data Guard