DBA30 asked what are the functions of the system DB, and how to restore the database due to damage (mainly the master database)
Master Database
Record SQLAll system-level information of the Server system. This includes metadata of the instance range (such as Logon account ),
Configure endpoints, linked servers, and systems. In addition, the masterThe
Label:Directory
Directory
Software Environment
Objective
Installing the Oracle Listener
Start Stop Listener
Create a database
Database name Db_name
DB Instance Name instance_name
The relationship between the database name and the instance name
Operating system environment variable Oracle_sid
A successful management system is made up of: [50% of the Business + 50% software], and 50% of the success of the software has [25% database + 25% of the program], the database design is a good or bad is a key. The database design is the most important part of the application if the data of the enterprise is compared to the blood necessary for life. There are num
Data files for Oracle databases (files with the extension DBF) are files that are used to hold the data in the database, and system data, data dictionary data, temporary data, index data, application data, etc. are physically stored in the data file. The user's operation on the data in the database, such as inserting, deleting, modifying and querying the data, is essentially the operation of the data file.
Label:In the previous period, the company's main database was cut into business and reporting libraries, and the business Library was replication to the report library in real time. This project was launched to improve the performance and maintainability of the system, and now review the design considerations and the work done as a reminder. Project Origins In the daily development process, functionality is always preceded by performance consideration
Chapter 2 Introduction
When the data volume is huge, the multi-table is first divided into different databases, and then the data is distributed to different databases according to the key columns. After the database is distributed, the system queries, io, and other operations can all be completed by groups composed of multiple machines. This article focuses on the principles of database sharding, table sha
Tags: adding large number of languages common number development based on defined storage Directory: 1. Relational database 2. Relational database bottlenecks 3. NoSQL 4. Relational database VS non-relational database 5. Non-relational database classification 1. Relational
1. The storage structure of databases is divided into logical and physical storage structures. Logical Storage Structure: describes the nature of the database information. SQL Server databases not only store data, but all information related to data processing operations is stored in the database. Physical storage structure: the database is stored on a disk as a
Database Name, Instance name, database domain name, global database name, and service name are several confusing concepts for many beginners. I believe that many beginners are confused by these concepts on the title just like me. Now let's figure them out.
I. Database NameWhat is the
Tags: nosql atomic database OOP tail development inconsistent key value RSS1. Relational databaseThis post is reproduced, see original Please get on the bus: http://blog.csdn.net/robinjwong/article/details/18502195/ Relational database refers to a database that uses a relational model to organize data. The relational model was first proposed by IBM researcher Dr.
Advanced Database Technology(a) IntroductionThe development of the database system began in the the 1860s, from the IBM hierarchical model IMS, the network model, the relational model, to the coexistence of most models (isomorphism and heterogeneous and their mixed form coexistence). In particular, three winners of the Turing Award in the database field, Charles
Label:1. Relational databaseRelational database refers to a database that uses a relational model to organize data. The relational model was first proposed by IBM researcher Dr. E.f.codd in 1970, and in the following decades, the concept of relational model has been fully developed and gradually becomes the mainstream model of the mainstream database structure. I
1. Relational databaseRelational database refers to a database that uses a relational model to organize data.The relational model was first proposed by IBM researcher Dr. E.f.codd in 1970, and in the following decades, the concept of relational model has been fully developed and gradually becomes the mainstream model of the mainstream database structure.In simple
1. Relational databaseRelational database refers to a database that uses a relational model to organize data.The relational model was first proposed by IBM researcher Dr. E.f.codd in 1970, and in the following decades, the concept of relational model has been fully developed and gradually becomes the mainstream model of the mainstream database structure.In simple
Source: http://blog.csdn.net/robinjwong/article/details/185021951. Relational databaseRelational database refers to a database that uses a relational model to organize data.The relational model was first proposed by IBM researcher Dr. E.f.codd in 1970, and in the following decades, the concept of relational model has been fully developed and gradually becomes the mainstream model of the mainstream
First Article: It turns out that changing MDB to ASP can prevent download.
Introduction: I tried it with animator yesterday and renamed the data. MDB file to the Data. asp file and put it in the wwwroot directory. Then input data in IE. after ASP path, ie is displayed blank. Right-click to view the source file, jump out of notepad, and save the content. MDB file, opened with access, found that the password is required, that is, at least the file header is damaged.Use flashget to download the da
Directory
Introduction to Directory Software Environment install Oracle Listener start stop listener CREATE database database name db_name database instance name instance_name database name and instance name the relational operating system environment variable Oracle_sid
Software Environment operating systemRHEL 6.1 S
I. Preface:
After the database server is set up, the first thing we need to do is not to consider which MySQL-carried servers should be running on the server that supports the database.ProgramBut how to recover to the last normal state after the database is damaged, minimizing the data loss.
In other words, just the establishment of a database server can only
Oracle442 application scenarios ---------- database instances and access Database Application Instances
The Application Scenario 1-7 is the installation process of Oracle. Here, I will explain a lot about it. There are a lot of materials on the Internet and it may be added later.
Application Scenario 8View the location of all data files:Select name from v $ DATAFILE;List command:LISTSAVE command:Save d: \ O
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.