CN109597709B

CN109597709B - Method for breakpoint resume of Oracle Dataguard creation process

Info

Publication number: CN109597709B
Application number: CN201811359314.5A
Authority: CN
Inventors: 孙朝阳
Original assignee: Hangzhou Woqu Technology Co ltd
Current assignee: Hangzhou Woqu Technology Co ltd
Priority date: 2018-11-15
Filing date: 2018-11-15
Publication date: 2023-01-10
Anticipated expiration: 2038-11-15
Also published as: CN109597709A

Abstract

The invention provides a method for establishing a Dataguard by Oracle database breakpoint retransmission, aiming at the problem that once the Oracle database is interrupted, the Dataguard cannot be continuously transmitted. The invention has the creativity that the defects of an Oracle database are made up, and in the long process of creating the Dataguard, if errors occur, synchronous data does not need to be restarted, and only differential data need to be synchronized, so that the characteristic of breakpoint continuous transmission is realized. The invention greatly reduces the time consumption in the process of creating the Dataguard and reduces the waiting time of technicians.

Description

Method for breakpoint resume in Oracle Dataguard creation process

Technical Field

The invention relates to an Oracles database, which is used for enhancing the process of creating the Dataguard by Oracle native, making up the defect that errors in the midway need to be restarted, and particularly relates to a method for breakpoint resume in the process of creating the Oracle Dataguard.

Background

Oracle Dataguard technology is a way to create an Oracle backup database that is natively supported by the Oracle database.

During the creation of the Dataguard, oracle provides a simple operation mode, and realizes the simplification operation of operations such as synchronous control files, data files, filing files and the like during the creation.

When errors occur in the network, storage, database and other layers, the Dataguard creation process is terminated, and the native creation command cannot realize the function of breakpoint transmission. Since the Oracle database size may be large, up to 30TB or even over 100TB, the time cost for re-creation is very high in case of error.

Disclosure of Invention

Aiming at the defect that errors occur in the middle of the process of creating the Dataguard by Oracle native in the prior art and the data uard needs to be restarted, the invention provides a method for creating the Dataguard by breakpoint resume of an Oracle database, when the method for creating the Dataguard by Oracle native is used, the breakpoint resume can be realized by using the method, and the method for restarting the native process is replaced, and the method comprises the following steps;

(1) And comparing whether the data files of the current main database (hereinafter referred to as the main database) and the backup database (hereinafter referred to as the backup database) are consistent. If the two signals are consistent, going to the step (2), and if the two signals are not consistent, going to the step (3);

(2) And acquiring the minimum FIRST _ CHANGE # field value and the maximum NEXT _ CHANGE # field value in all continuous archival logs of the primary library, namely the range of the continuous archival logs, and comparing the minimum FIRST _ CHANGE # field value and the maximum NEXT _ CHANGE # field value with the CHECKPOINT _ CHANGE # field of all data files in the V $ DATAFILE view in the backup library. If the record with the CHECKOINT _ CHANGE # field smaller than the range of the primary library filing log exists, going to (3), and if not, going to (4);

(3) And exporting the control file of the main library to the standby library to cover the original old file of the standby library. Updating the information of the transmitted data file to the control file;

(4) The minimum FIRST _ CHANGE # field value and the maximum NEXT _ CHANGE # field value in all continuous archive logs of the primary library, namely the range of the continuous archive logs, are obtained and compared with the check key _ CHANGE # field of all data files in the V $ database _ HEADER view in the backup library. If the record with the CHECKPOINT _ CHANGE # field smaller than the range of the primary library filing log exists; go to (5), otherwise go to (6);

(5) According to the information obtained in the step (4), retransmitting the data file indicated by the record with the CHECKPOINT _ CHANGE # field smaller than the filing log range of the main library, and updating the information to the control file;

(6) Performing log archiving once on all the instances of the master library, and recording the value of the FIRST _ CHANGE # field of the newly generated archiving log;

(7) Transmitting the difference filing log to a standby library according to the minimum CHECKPoint _ CHANGE # field value in the V $ DATAFILE view and the V $ DATAFILE _ HEADER view;

(8) Executing a RECOVER operation in the standby library, and designating to restore to the value of the FIRST _ CHANGE # field recorded in the step (6);

(9) At this time, the standby library can successfully execute the OPEN operation, the Dataguard is successfully created, and the whole process is finished.

Due to the adoption of the technical scheme, the invention has the remarkable technical effects that: through breakpoint retransmission, the data transmitted before the interruption of the creation process can be multiplexed without retransmission, and the time cost for creating the Oracle Dataguard is greatly reduced.

Drawings

Fig. 1 is a flow chart of a method for creating Dataguard by breakpoint resuming of an Oracle database.

Detailed Description

The present invention will be described in further detail with reference to the accompanying drawings and examples.

Example 1

As shown in fig. 1, a method for creating Dataguard by breakpoint resuming of Oracle database includes the following steps:

In summary, the above is only a preferred embodiment of the present invention, and all equivalent changes and modifications made in the claims of the present invention should be covered by the claims of the present invention.

Claims

1. A method for creating Dataguard by breakpoint resuming of Oracle database, comprising: comprises the following steps;

(1) Comparing whether the number of data files is consistent or not in the current main database, the main database for short, and the backup database, the backup database for short; if the two signals are consistent, going to the step (2), and if the two signals are not consistent, going to the step (3);

(2) Acquiring a minimum FIRST _ CHANGE # field value and a maximum NEXT _ CHANGE # field value in all continuous archiving logs of a primary library, namely a range of the continuous archiving logs, and comparing the range with the check key _ CHANGE # fields of all data files in a V $ DATAFILE view in a secondary library; if the record with the CHECKOINT _ CHANGE # field smaller than the range of the primary library filing log exists, going to (3), and if not, going to (4);

(3) Exporting the control file of the main library to the standby library, and covering the original old file of the standby library; updating the information of the transmitted data file to the control file;

(4) Acquiring the minimum FIRST _ CHANGE # field value and the maximum NEXT _ CHANGE # field value in all continuous archiving logs of a main library, namely the range of the continuous archiving logs, and comparing the range with the CHECKPOINT _ CHANGE # field of all data files in the V $ DATAFILE _ HEADER view in the backup library; if the record with the CHECKPoint _ CHANGE # field smaller than the range of the primary library filing log exists; go to (5), otherwise go to (6);

(9) The OPEN operation is successfully performed by the standby library, and the Dataguard is successfully created.

2. The method for Oracle database breakpoint resumption creation of Dataguard as claimed in claim 1, wherein: and realizing breakpoint continuous transmission through synchronous difference data.