Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method, device and system for building main database and standby database

A master database and database technology, applied in the database field, can solve problems such as affecting work efficiency and progress, work can only be delayed, and construction failures, etc., to achieve the effect of lowering professional thresholds, improving accuracy, and being easy to use

Pending Publication Date: 2021-05-25
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] At present, Data Guard is built manually. The traditional manual building method has cumbersome steps and relatively high labor and time costs. Specifically, it is reflected in:
[0004] 1. Only a full-time DBA (database administrator) can be competent when it involves Oracle, SQL and other related fields. If the DBA time cannot be arranged, this work can only be postponed
[0005] 2. Many database parameters are modified during the construction process, and most of the parameters need to be modified according to the environment of the main and standby machines. The steps are complicated and there are too many human intervention factors, which are easy to introduce human errors and cause the entire construction to fail.
[0006] 3. With one person as the unit, traditional solutions cannot achieve parallel construction, but can only be executed sequentially, which seriously affects work efficiency and progress

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method, device and system for building main database and standby database
  • Method, device and system for building main database and standby database
  • Method, device and system for building main database and standby database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] The embodiment of the present invention provides a method, device and system for building a master-standby database, which can be used in the financial field or other fields. It should be noted that the method, device and system for building a master-standby database of the present invention can be used in the financial field and also In any field except the financial field, the application field of the method, device and system application of the present invention is not limited.

[0051] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

A method, device and system for building a main database and a standby database can be used in the financial field or other fields. The method comprises: obtaining a main database server IP (Internet Protocol) and a standby database server IP, and determining main database instance information, a directory list and the file size and the file number of an online redo log; according to the file size and the file number, creating a standby database redo log in the main database; generating a connection character string, and adding the connection character string into a descriptor configuration file of the main database server; acquiring a password file, a parameter file and a descriptor configuration file from the main database, and synchronizing the password file, the parameter file and the descriptor configuration file to a standby database according to a standby database server IP; and according to the main database directory list, creating a standby database directory list in the standby database, and storing each file in the standby database directory list, so that the standby database obtains a standby database redo log from the main database and copies data. The professional threshold of the main and standby database construction is reduced, and the daily operation and maintenance accuracy, efficiency and quality are improved.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a method, device and system for building active and standby databases. Background technique [0002] At present, the construction of the active and standby databases can usually be realized through the construction of Data Guard. Data Guard is an enterprise-level database high availability solution launched by Oracle, which aims to continuously synchronize the online log stream RedoStream between the active and standby nodes to achieve data consistency. When the master node fails, Data Guard can realize data disaster recovery through fast switching. [0003] At present, Data Guard is built manually. The traditional manual building method has cumbersome steps and relatively high labor and time costs. Specifically, it is reflected in: [0004] 1. Only a full-time DBA (database administrator) can be competent for professional knowledge in related fields such as Oracle and...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/21G06F11/14
CPCG06F11/1448G06F16/21
Inventor 王洪月张振川魏锴
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products