CN115292097B - Database instance creation method, apparatus, device, storage medium, and program product - Google Patents
Database instance creation method, apparatus, device, storage medium, and program product Download PDFInfo
- Publication number
- CN115292097B CN115292097B CN202211006741.1A CN202211006741A CN115292097B CN 115292097 B CN115292097 B CN 115292097B CN 202211006741 A CN202211006741 A CN 202211006741A CN 115292097 B CN115292097 B CN 115292097B
- Authority
- CN
- China
- Prior art keywords
- parameter
- database instance
- target
- database
- creating
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1415—Saving, restoring, recovering or retrying at system level
- G06F11/1435—Saving, restoring, recovering or retrying at system level using file system or storage system metadata
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1469—Backup restoration techniques
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to a method, a device, equipment, a storage medium and a program product for creating a database instance, wherein parameter files in a database instance backup set are obtained from a storage server; displaying a parameter adjustment interface according to the parameter file, wherein the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters; receiving an adjustment operation aiming at a target parameter adjustment control, and adjusting an initial parameter value in the target parameter adjustment control to be a target parameter value according to the adjustment operation; and creating a target database instance according to the unadjusted initial parameter values and the adjusted target parameter values. The operation and maintenance work is reduced without manually logging in a test server; the corresponding operation system and database are not required to be prepared, the time for recovering the database from the exercise is shortened, and the process of creating the database instance is simplified; and a parameter adjustment interface is generated, so that the professional requirement is reduced, and the cross-platform operation is realized.
Description
Technical Field
The present invention relates to the field of database technologies, and in particular, to a method, an apparatus, a device, a storage medium, and a program product for creating a database instance.
Background
At present, the situation of database damage or data loss in the market is frequent, so that more and more users are aware of the importance of database backup, pay attention to the validity and correctness of the backup set, and more clients require that the backup be restored on a test machine in order to avoid faults when the backup is really needed.
However, in the traditional database recovery method, a series of operations for creating the database instance need to be completed by logging in the test server manually, the process is time-consuming and labor-consuming, the operation and maintenance costs are too high, and the same user database may exist in Linux, windows, domestic and various small computer systems, such as AIX, HPUX, solaris systems, and because various versions and systems of the database need to be prepared for the corresponding system and the database with the same version before recovery exercise, the professional requirements on operators are improved, so that the problems of time-consuming trouble, high operation and maintenance costs, incapability of cross-platform processing, high operation professional requirements and the like in the database recovery exercise process on the test machine are urgently solved.
Disclosure of Invention
Based on this, it is necessary to provide a method, an apparatus, a device, a storage medium and a program product for creating a database instance, in view of the above technical problems.
In a first aspect, the present application provides a method for creating a database instance. The method comprises the following steps:
acquiring a parameter file in a database instance backup set from a storage server; displaying a parameter adjustment interface according to the parameter file, wherein the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters; receiving an adjustment operation aiming at a target parameter adjustment control, and adjusting an initial parameter value in the target parameter adjustment control to be a target parameter value according to the adjustment operation; and creating a target database instance according to the unadjusted initial parameter values and the adjusted target parameter values.
In one embodiment, creating a target database instance from the unadjusted initial parameter values and the adjusted target parameter values includes: sending a creation request to an agent component deployed in a test server, wherein the creation request carries unadjusted initial parameter values and adjusted target parameter values; the creation request is used to instruct the proxy component to perform a database instance creation process based on the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
In one embodiment, a database instance creation process includes: creating a parameter file, creating a password file, creating a directory, creating a snoop, and starting a database.
In one embodiment, the method further comprises: after the proxy component creates the target database instance, sending a recovery exercise request to the proxy component; the resume drill request is to instruct the agent component to perform a database resume drill operation based on the target database instance.
In one embodiment, the process of creating a backup set of database instances includes: and carrying out physical backup on the target database instance to create a database instance backup set.
In one embodiment, the method for creating a database instance is applied to a service component deployed in a backup server, and before sending a creation request to a proxy component deployed in a test server, the method further includes: receiving a registration request of a proxy component; the proxy component is registered in the service component according to the registration request.
In a second aspect, the present application further provides a device for creating a database instance. The device comprises:
the acquisition module is used for acquiring the parameter files in the database instance backup set from the storage server;
The display module is used for displaying a parameter adjustment interface according to the parameter file, wherein the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters;
the adjusting module is used for receiving the adjusting operation aiming at the target parameter adjusting control and adjusting the initial parameter value in the target parameter adjusting control to be a target parameter value according to the adjusting operation;
and the creation module is used for creating a target database instance according to the unadjusted initial parameter values and the adjusted target parameter values.
In one embodiment, the creation module is specifically configured to: sending a creation request to an agent component deployed in a test server, wherein the creation request carries unadjusted initial parameter values and adjusted target parameter values; the creation request is used to instruct the proxy component to perform a database instance creation process based on the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
In one embodiment, the database instance creation process includes: creating a parameter file, creating a password file, creating a directory, creating a snoop, and starting a database.
In one embodiment, the database instance backup set creation process includes: and carrying out physical backup on the target database instance to create a database instance backup set.
In one embodiment, the apparatus further comprises a recovery exercise module for: after the proxy component creates the target database instance, a recovery drilling request is sent to the proxy component, the recovery drilling request being used to instruct the proxy component to perform a database recovery drilling operation based on the target database instance.
In one embodiment, the method for creating a database instance is applied to a service component deployed in a backup server, and the apparatus further includes a registration module, where the registration module is configured to: receiving a registration request of a proxy component; the proxy component is registered in the service component according to the registration request.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the steps of any of the above-mentioned first aspects when the processor executes the computer program.
In a fourth aspect, the present application also provides a computer-readable storage medium. A computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of any of the above-mentioned first aspects.
In a fifth aspect, the present application also provides a computer program product. The computer program product comprising a computer program which, when executed by a processor, implements the steps of any of the above-described first aspects.
According to the method, the device, the equipment, the storage medium and the program product for creating the database instance, the parameter files in the database instance backup set are obtained from the storage server, and the parameter adjustment interface is displayed according to the parameter files, wherein the parameter adjustment interface comprises the parameter adjustment controls corresponding to different parameters, each parameter adjustment control displays the initial parameter value of the corresponding parameter, then the adjustment operation for the target parameter adjustment control is received, the initial parameter value in the target parameter adjustment control is adjusted to be the target parameter value according to the adjustment operation, then the target database instance is created according to each initial parameter value without adjustment and the target parameter value obtained by adjustment, the operation and maintenance work of logging in the test server are reduced, and meanwhile, a corresponding operating system and a database with the same version are not required to be prepared, so that the time for database recovery exercise is shortened, the process for creating the database instance is simplified, and the database instance content required before the recovery exercise can be created in a one-key mode without depending on too high professional operation.
Drawings
FIG. 1 is an application environment diagram of a method of creating a database instance in one embodiment;
FIG. 2 is a flow diagram of a method of creating a database instance in one embodiment;
FIG. 3 is a schematic diagram of an exemplary parameter adjustment interface in one embodiment;
FIG. 4 is a schematic diagram of another exemplary parameter adjustment interface in one embodiment;
FIG. 5 is a flow diagram of a method of registering a proxy component in one embodiment;
FIG. 6 is a flow chart of a method of creating a database instance in another embodiment;
FIG. 7 is an internal block diagram of a database instance creation apparatus in one embodiment;
FIG. 8 is an internal block diagram of a means for creating another database instance in one embodiment;
fig. 9 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The database is a warehouse for organizing, storing and managing data according to a data structure, and along with the rapid development of informatization, the database technology becomes a core part of various information systems such as a management information system, an office automation system, a decision support system and the like, is an important technical means for scientific research and decision management, and meanwhile, the application of the database is deep in aspects of work and life.
At present, the situation of database damage or data loss in the market is frequent, so that more and more users are aware of the importance of database backup, pay attention to the validity and correctness of the backup set, and more clients require that the backup be restored on a test machine in order to avoid faults when the backup is really needed.
However, in the traditional database recovery mode, a test server needs to be logged in manually to complete a series of operations for creating the database instance, the process is time-consuming and labor-consuming, the operation and maintenance cost is too high, and the same user database can exist in Linux, windows, domestic and various small computer systems, such as AIX, HPUX, solaris systems, and because various versions and systems of the database, the corresponding system and the database with the same version need to be prepared before recovery exercise, the professional requirements on operators are improved, and therefore, the problems of trouble, time consumption, high operation and maintenance cost, incapability of cross-platform processing, high operation professional requirements and the like exist in the database recovery exercise process on a test machine.
In view of this, the embodiment of the application provides a method for creating a database instance, which can automatically and quickly create a database instance in a cross-platform manner without manually logging in a test server, reduces the operation and maintenance work of logging in the test server, displays a parameter adjustment interface, has low requirements on the operation specialty, and can be quickly created by one-key by a person skilled in the art.
The method for creating the database instance provided in the embodiment of the present invention may be applied to an application environment as shown in fig. 1, where the application environment includes a plurality of servers, where the plurality of servers includes a test server 101, a backup server 102, and a storage server 103, where a database instance backup set is stored in the storage server 103, and the backup server 102 may obtain the database instance backup set from the storage server 103, and create a target database instance in the test server 101 based on the database instance backup set, so that the test server 101 performs recovery exercise according to the target database instance.
In an alternative embodiment of the present application, a proxy (english: agent) component may be disposed in the test Server 101, where the proxy component implements the functions of the test Server 101 described in the embodiments of the present application, and a service (english: server) component may be disposed in the backup Server 102, where the service component implements the functions of the backup Server 102 described in the embodiments of the present application; the storage server 103 stores therein the parameter files in the database instance backup set. Wherein the test server 101 is in connection communication with the backup server 102 via a communication network, and the backup server 102 is in connection communication with the storage server 103 via a communication network.
Referring to fig. 2, a flowchart of a method for creating a database instance according to an embodiment of the present application is shown, where an execution subject of the method for creating a database instance is the backup server 102 shown in fig. 1. As shown in fig. 2, the method for creating the database instance may include the steps of:
The storage server 103 is a special server carrying many functions, including storage management software, additional hardware to ensure high flexibility, RAID configuration types, and additional network connections to ensure more desktop users are connected thereto. In this application, the function of the storage server 103 is mainly to store the parameter files in the backup set of the management target database instance, and meanwhile, the storage server 103 is accessed into the local area network to realize the sharing of the data files in the backup set of the database instance, so that the backup server 102 can obtain the parameter files in the backup set of the database instance from the storage server 103 through network communication.
The parameter file in the database instance backup set refers to an operating system file containing a series of parameters and values corresponding to the parameters, and the operating system file is loaded when the database instance is started, determines the physical structure, memory, limitation of the database, a large number of default values of the system, various physical properties of the database, specified control file names and paths of the database and other information, and is an important file for database design and performance tuning.
In one possible implementation, a method for obtaining a parameter file in a database instance backup set includes: the parameter file is extracted by utilizing the database statement, the parameter file is backed up to an elastic cloud database RDS server, the cloud database RDS server supports the function of starting the public network access, the public network access is carried out through the elastic public network IP, and the backup server 102 can acquire the parameter file.
The parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters. For example, the parameter adjustment control may be a source address, a directory, an instance name, a sys password, a system user, log information, etc., and the embodiments of the present application do not limit specific parameter types in the parameter adjustment interface.
Please refer to fig. 3, which is a schematic diagram of an exemplary parameter adjustment interface, wherein the target database is an ORACLE database, and as shown in fig. 3, parameter adjustment controls corresponding to different parameters are displayed on the parameter adjustment interface, wherein the parameter adjustment controls include oracle_home, oracle_base, instance name, sys password, repetition password, and system user. Wherein the oracle_home is a product catalog of the ORACLE database; the oracle_base is the root directory of the ORACLE database; the instance name is an instance name set for the oracle database and is used for identifying the database instance; the sys password is the password of a sys user, the sys user is the user with the highest authority in the oracle database, and the sys password is modified to ensure the security of the oracle database; the repeated password is repeatedly input once to ensure the correctness of the password; the system user is a system user of the oracle database.
Please refer to fig. 4, which is a schematic diagram of another exemplary parameter adjustment interface, wherein the target database type is also an oracle database, and is the same as the environment of the above exemplary oracle database, and as shown in fig. 4, parameter adjustment controls corresponding to different parameters are displayed on the parameter adjustment interface, wherein the parameter adjustment controls include audio_file_ dest, background _dump_ dest, compatible, control _files and core_dump_dest, and the content of each parameter adjustment control refers to each parameter at the bottom layer of the oracle database, which together determine the content of the working environment in which the oracle database operates normally.
The initial parameter value is carried by a parameter file in a database instance backup set, the content of the initial parameter value corresponds to a target database instance, and through the display of a parameter adjustment interface, a user can intuitively acquire the content required for creating the target database instance without excessive specialized knowledge, so that complicated acquisition processes, such as code writing, specialized program use, related software downloading and the like, are reduced.
The adjustment operation means that the user adjusts and changes the initial parameter value of the parameter on the parameter adjustment interface by using the parameter adjustment control, and the initial parameter value can be adjusted to be the target parameter value, for example, if the root directory positions corresponding to the operating systems on the test server 101 are different, the root directory position of the database instance needs to be changed, and further, the parameter value of the root directory position is correspondingly modified.
In one possible implementation, the initial parameter value refers to an initial parameter value in the target database instance, and the related content is related to the original operating system and version number of the database; the target parameter value refers to a parameter value of a database instance created on the test server 101, and the related content is related to an operating system and a version number on the test machine, so that an adjustment operation needs to be performed on the initial parameter value to adjust the initial parameter value to the target parameter value so as to adapt to the running environment on the test machine and match with the running environment when the exercise is resumed.
In order to match the created database instance with the running environment at the time of recovery exercise, optionally, on the parameter adjustment interface provided by the backup server 102, an adjustment operation may be performed on the target parameter adjustment control to change the initial parameter value that is not matched to the target parameter value of the database instance that can match the running environment.
In one possible implementation, the manner of adjusting the adjustment operation of the control for the target parameter includes: the user manually performs adjustment operation, uses a software program to perform adjustment operation, writes database sentences to perform adjustment operation and the like, wherein the machine modes of performing adjustment operation and writing database sentences to perform adjustment operation and the like by using the software program can realize the automatic change adjustment operation function without manual verification, but both the manual mode and the machine mode depend on the parameter file content in the database instance backup set.
The unadjusted initial parameter values and the adjusted target parameter values refer to parameter values that can be matched with the operating environment during the recovery exercise, wherein the adjusted target parameter values are obtained by adjusting the target parameter adjustment control in the display parameter adjustment interface of the backup server 102.
To create a target database instance, optionally, a service component in the backup server 102 sends a create request to a proxy component deployed in the test server 101. Wherein the creation request carries the unadjusted initial parameter values and the adjusted target parameter values, the creation request being for instructing the proxy component to perform a database instance creation process based on the unadjusted initial parameter values and the adjusted target parameter values to create the target database instance.
Further, the proxy component, upon receiving the creation request, performs a database instance creation process on the test server 101 based on the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
The method for creating the target database instance is a process which has to work before the database recovery exercise is carried out, and in order to ensure the concrete implementation of the recovery exercise, the content of the target database instance needs to be created in advance, wherein the process for creating the database instance comprises the following steps: creating a parameter file, creating a password file, creating a directory, creating a snoop and start database.
Furthermore, based on the created target database instance, a backup and recovery exercise of the database is performed in advance of the occurrence of the situation that the database is really needed to be recovered. In practical applications, the situation that the database needs to be recovered is various, for example, a virus causes a machine to crash, and a system file is damaged; some components in the machine have poor thermal stability, which causes problems for the components; software conflicts or corruption; operating system incompatibility, and the like. Because the actual problem has burstiness and instability, if the backup is not prepared in advance, the loss of database content will result, and therefore, the backup and recovery exercise of the database needs to be performed on the testing machine in a standby mode.
According to the method for creating the database instance, the parameter files in the database instance backup set are obtained from the storage server, and the parameter adjustment interface is displayed according to the parameter files, wherein the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, each parameter adjustment control displays initial parameter values of the corresponding parameters, then adjustment operation for the target parameter adjustment control is received, the initial parameter values in the target parameter adjustment control are adjusted to target parameter values according to the adjustment operation, then the target database instance is created according to each initial parameter value which is not adjusted and the target parameter values which are obtained through adjustment, a test server does not need to be logged in manually, operation and maintenance work of logging in the test server is reduced, meanwhile, a corresponding operation system and databases of the same version are not required to be prepared, the time for recovering the database is shortened, the process for creating the database instance is simplified, and because the parameter adjustment interface is displayed according to the parameter files, too high professional operation is not relied on any more, and the content of the database instance required before the recovery exercise can be created by one key across platforms.
In accordance with the foregoing, the process of creating a database instance is performed by first obtaining a parameter file in a database instance backup set from the storage server 103, where the process needs to create the database instance backup set in advance in the storage server 103, and in an alternative embodiment of the present application, an alternative method for creating a database instance backup set is provided, which includes: storage server 103 performs a physical backup of the target database instance to create a database instance backup set.
Wherein, the physical backup refers to the backup of dump database physical files, which can directly restore database contents, and the physical files comprise: data files, control files, archive log files, etc., can be restored by using these files once the database fails, and in practical applications, physical backup is also generally used mainly. Meanwhile, the physical backup is generally accompanied with the backup of the parameter file, and the backup set is backed up to the storage server, so that the purpose of disaster recovery backup is achieved.
The database instance backup set includes all contents in the database instance, where the contents are presented in the form of data files, and in the embodiment of the present application, the backup server 102 obtains the parameter files in the database instance backup set from the storage server 103, and based on the parameter files, executes a subsequent process of creating the target database instance.
In an alternative embodiment of the present application, the storage server 103 performs a physical backup on the target database instance, so as to obtain a physical file in the target database instance, and meanwhile, the physical backup is generally accompanied with a backup of a parameter file, and the parameter file is backed up in a backup set of the storage server 103, further, the storage server 103 creates a database instance backup set, where the backup set includes the parameter file of the target database instance, and through the parameter file, a parameter adjustment interface is displayed, and an adjustment operation is performed on a target parameter adjustment control in the parameter adjustment interface, so as to create the target database instance.
Further, in one embodiment, there is provided a method of creating a target database instance, the method comprising: the service components in the backup server 102 send a create request to the proxy components deployed in the test server 101.
Wherein the creation request carries the unadjusted initial parameter values and the adjusted target parameter values, the creation request being for instructing the proxy component to perform a database instance creation process based on the unadjusted initial parameter values and the adjusted target parameter values to create the target database instance.
Wherein, the database instance creation process comprises the following steps: creating a parameter file, creating a password file, creating a directory, creating a snoop and start database.
Since the creation of the database instance is only one step before the recovery exercise, and a specific recovery exercise process is an essential step in order to complete the complete database recovery exercise, embodiments of the present application provide a method for database recovery exercise, which includes: after the proxy component creates the target database instance, a resume drill request is sent to the proxy component.
Wherein the recovery drilling request is used to instruct the agent component in the test server 101 to perform a database recovery drilling operation based on the target database instance.
In one possible implementation, the process of sending a resume drill request to the proxy component includes: the service component in the backup server 102 sends a request containing a recovery exercise event to the agent component in the test server 101, and the agent component receives the request through network communication, performs a target database instance recovery exercise operation, and restores the target database instance to a state before backup.
In the embodiment of the present application, the method for creating a database instance may be applied to a service component deployed in the backup server 102, and then before the backup server 102 sends a creation request to a proxy component deployed in the test server 101, the proxy component should be registered to the service component, as shown in fig. 5, which illustrates a method for registering the proxy component in the test server 101, including the following steps:
Wherein the registration request refers to a request carrying proxy component registration information in the test server 101, and the registration request is used to obtain a resource on the backup server 102, where the resource may be text, an image, or any element that may be contained in a page, so as to enable a connection communication between two servers.
In one possible implementation, the process of receiving, by the backup server 102, a registration request for a proxy component in the test server 101 includes: the proxy component in the test server 101 issues a registration request to the backup server 102, and the backup server 102 receives the registration request and sends the registration request to the service component through network communication so that the subsequent service component performs the request operation.
In one possible implementation, the process of the backup server 102 registering the proxy component with the service component in the backup server 102 according to the registration request includes: the backup server 102 receives the registration request through network communication and transmits the registration request to a service component in the backup server 102, the service component receives the registration request and performs a registration request operation, registers a proxy component in the service component in the backup server 102, establishes network communication between the test server 101 and the backup server 102, so that the two servers can communicate with each other, and receives resource information from each other, so as to perform the step of creating a database instance and the recovery exercise operation.
For example, the backup server 102 obtains the parameter file contents of the database instance backup set in the storage server 103, performs an adjustment operation according to the parameter file display parameter adjustment interface, and then, the service component in the backup server 102 needs to send the parameter contents, including the initial parameter value in the target parameter adjustment control and the adjusted target parameter value, to the proxy component in the test server 101 through the communication connection network established after registration, and then, the proxy component receives the parameter contents and creates the target database instance.
Similarly, the content in the test server 101 may also send information to the service component in the backup server 102 via the registered communication connection network by using the proxy component.
In one embodiment, as shown in fig. 6, a method for creating a database instance is provided, including the steps of:
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a database instance creation device for realizing the database instance creation method. The implementation of the solution provided by the apparatus is similar to the implementation described in the above method, so the specific limitation in the embodiment of the creation apparatus of one or more database instances provided below may refer to the limitation of the creation method of the database instance hereinabove, and will not be repeated herein.
In one embodiment, as shown in fig. 7, there is provided a database instance creation apparatus 700, including: an acquisition module 701, a presentation module 702, an adjustment module 703 and a creation module 704, wherein:
an obtaining module 701, configured to obtain, from the storage server 103, a parameter file in the database instance backup set.
The display module 702 is configured to display a parameter adjustment interface according to the parameter file, where the parameter adjustment interface includes parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays an initial parameter value of the corresponding parameter.
The adjustment module 703 is configured to receive an adjustment operation for the target parameter adjustment control, and adjust an initial parameter value in the target parameter adjustment control to a target parameter value according to the adjustment operation.
A creating module 704, configured to create a target database instance according to the unadjusted initial parameter values and the adjusted target parameter values.
In one embodiment, the creating module 704 is specifically configured to: sending a creation request to a proxy component deployed in the test server 101, the creation request carrying the unadjusted initial parameter values and the adjusted target parameter values; the creation request is used to instruct the proxy component to perform a database instance creation process based on the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
In one embodiment, the database instance creation process includes: creating a parameter file, creating a password file, creating a directory, creating a snoop, and starting a database.
In one embodiment, the database instance backup set creation process includes: and carrying out physical backup on the target database instance to create a database instance backup set.
Referring to fig. 8, another database instance creating apparatus 800 is provided in the embodiment of the present application, where the database instance creating apparatus 800 includes, in addition to the modules included in the database instance creating apparatus 700, optionally: a recovery drilling module 705 and a registration module 706.
Wherein, the recovery exercise module 705 is configured to: after the proxy component creates the target database instance, sending a recovery exercise request to the proxy component; the resume drill request is to instruct the agent component to perform a database resume drill operation based on the target database instance.
The database instance creation method is applied to the service components deployed in the backup server 102, and the registration module 706 is configured to: before sending a creation request to a proxy component deployed in the test server 101, receiving a registration request of the proxy component; the proxy component is registered in the service component according to the registration request.
The respective modules in the database instance creation means described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 8. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of creating a database instance.
It will be appreciated by those skilled in the art that the structure shown in fig. 8 is merely a block diagram of some of the structures associated with the present application and is not limiting of the computer device to which the present application may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of:
acquiring a parameter file in a database instance backup set from a storage server 103; displaying a parameter adjustment interface according to the parameter file, wherein the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters; receiving an adjustment operation aiming at a target parameter adjustment control, and adjusting an initial parameter value in the target parameter adjustment control to be a target parameter value according to the adjustment operation; and creating a target database instance according to the unadjusted initial parameter values and the adjusted target parameter values.
In one embodiment, the processor, when executing the computer program, performs the steps of: sending a creation request to a proxy component deployed in the test server 101, the creation request carrying the unadjusted initial parameter values and the adjusted target parameter values; the creation request is used to instruct the proxy component to perform a database instance creation process based on the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
In one embodiment, a database instance creation process includes: creating a parameter file, creating a password file, creating a directory, creating a snoop, and starting a database.
In one embodiment, the processor, when executing the computer program, performs the steps of: after the proxy component creates the target database instance, sending a recovery exercise request to the proxy component; the resume drill request is to instruct the agent component to perform a database resume drill operation based on the target database instance.
In one embodiment, the creation process of the database instance backup set includes: and carrying out physical backup on the target database instance to create a database instance backup set.
In one embodiment, the method of creating a database instance is applied to a service component deployed in the backup server 102, and the processor when executing a computer program implements the following steps: receiving a registration request of a proxy component; the proxy component is registered in the service component according to the registration request.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
acquiring a parameter file in a database instance backup set from a storage server 103; displaying a parameter adjustment interface according to the parameter file, wherein the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters; receiving an adjustment operation aiming at a target parameter adjustment control, and adjusting an initial parameter value in the target parameter adjustment control to be a target parameter value according to the adjustment operation; and creating a target database instance according to the unadjusted initial parameter values and the adjusted target parameter values.
In one embodiment, the computer program when executed by a processor performs the steps of: sending a creation request to a proxy component deployed in the test server 101, the creation request carrying the unadjusted initial parameter values and the adjusted target parameter values; the creation request is used to instruct the proxy component to perform a database instance creation process based on the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
In one embodiment, a database instance creation process includes: creating a parameter file, creating a password file, creating a directory, creating a snoop, and starting a database.
In one embodiment, the computer program when executed by a processor performs the steps of: after the proxy component creates the target database instance, sending a recovery exercise request to the proxy component; the resume drill request is to instruct the agent component to perform a database resume drill operation based on the target database instance.
In one embodiment, the creation process of the database instance backup set includes: and carrying out physical backup on the target database instance to create a database instance backup set.
In one embodiment, the method of creating a database instance is applied to a service component deployed in the backup server 102, and the computer program when executed by the processor implements the steps of: receiving a registration request of a proxy component; the proxy component is registered in the service component according to the registration request.
In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of:
Acquiring a parameter file in a database instance backup set from a storage server 103; displaying a parameter adjustment interface according to the parameter file, wherein the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters; receiving an adjustment operation aiming at a target parameter adjustment control, and adjusting an initial parameter value in the target parameter adjustment control to be a target parameter value according to the adjustment operation; and creating a target database instance according to the unadjusted initial parameter values and the adjusted target parameter values.
In one embodiment, the computer program when executed by a processor performs the steps of: sending a creation request to a proxy component deployed in the test server 101, the creation request carrying the unadjusted initial parameter values and the adjusted target parameter values; the creation request is used to instruct the proxy component to perform a database instance creation process based on the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
In one embodiment, a database instance creation process includes: creating a parameter file, creating a password file, creating a directory, creating a snoop, and starting a database.
In one embodiment, the computer program when executed by a processor performs the steps of: after the proxy component creates the target database instance, sending a recovery exercise request to the proxy component; the resume drill request is to instruct the agent component to perform a database resume drill operation based on the target database instance.
In one embodiment, the creation process of the database instance backup set includes: and carrying out physical backup on the target database instance to create a database instance backup set.
In one embodiment, the method of creating a database instance is applied to a service component deployed in the backup server 102, and the computer program when executed by a processor performs the steps of: receiving a registration request of a proxy component; the proxy component is registered in the service component according to the registration request.
It should be noted that, user information (including but not limited to user equipment information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.
Claims (10)
1. A method of creating a database instance, the method comprising:
acquiring a parameter file in a database instance backup set from a storage server;
displaying a parameter adjustment interface according to the parameter file, wherein the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters;
Receiving an adjustment operation aiming at a target parameter adjustment control, and adjusting an initial parameter value in the target parameter adjustment control to be a target parameter value according to the adjustment operation;
sending a creation request to a proxy component deployed in a test server, wherein the creation request carries unadjusted initial parameter values and adjusted target parameter values; the creation request is used for instructing the proxy component to execute a database instance creation process according to the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
2. The method of claim 1, wherein the database instance creation process comprises:
creating a parameter file, creating a password file, creating a directory, creating a snoop, and starting a database.
3. The method according to claim 1 or 2, characterized in that the method further comprises:
after the proxy component creates the target database instance, sending a recovery drilling request to the proxy component;
the recovery drilling request is used for instructing the agent component to execute database recovery drilling operation based on the target database instance.
4. The method of claim 1, wherein the creation of the database instance backup set comprises:
and carrying out physical backup on the target database instance to create the database instance backup set.
5. The method of claim 1, wherein the method of creating database instances is applied to service components deployed in a backup server, the method further comprising, prior to sending a create request to a proxy component deployed in a test server:
receiving a registration request of the proxy component;
and registering the proxy component into the service component according to the registration request.
6. A database instance creation apparatus, the apparatus comprising:
the acquisition module is used for acquiring the parameter files in the database instance backup set from the storage server;
the display module is used for displaying a parameter adjustment interface according to the parameter file, the parameter adjustment interface comprises parameter adjustment controls corresponding to different parameters, and each parameter adjustment control displays initial parameter values of the corresponding parameters;
the adjusting module is used for receiving the adjusting operation aiming at the target parameter adjusting control and adjusting the initial parameter value in the target parameter adjusting control to be a target parameter value according to the adjusting operation;
The creation module is used for sending a creation request to an agent component deployed in the test server, wherein the creation request carries the initial parameter values which are not adjusted and the target parameter values which are obtained through adjustment; the creation request is used for instructing the proxy component to execute a database instance creation process according to the unadjusted initial parameter values and the adjusted target parameter values to create a target database instance.
7. The apparatus of claim 6, wherein the creation module comprises:
and the creation unit is used for creating a parameter file, creating a password file, creating a catalog, creating a monitor and starting a database.
8. The apparatus of claim 6, wherein the apparatus further comprises:
a drilling request sending unit, configured to send a recovery drilling request to the proxy component after the proxy component creates the target database instance; the recovery drilling request is used for instructing the agent component to execute database recovery drilling operation based on the target database instance.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 5 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211006741.1A CN115292097B (en) | 2022-08-22 | 2022-08-22 | Database instance creation method, apparatus, device, storage medium, and program product |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211006741.1A CN115292097B (en) | 2022-08-22 | 2022-08-22 | Database instance creation method, apparatus, device, storage medium, and program product |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115292097A CN115292097A (en) | 2022-11-04 |
| CN115292097B true CN115292097B (en) | 2023-05-23 |
Family
ID=83830153
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211006741.1A Active CN115292097B (en) | 2022-08-22 | 2022-08-22 | Database instance creation method, apparatus, device, storage medium, and program product |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115292097B (en) |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11256824B2 (en) * | 2019-08-06 | 2022-02-22 | Saudi Arabian Oil Company | Securing database backups with unique global identifier |
| CN112527564A (en) * | 2020-12-18 | 2021-03-19 | 平安科技（深圳）有限公司 | Database data recovery drilling method and device and storage medium |
| CN113572862A (en) * | 2021-09-27 | 2021-10-29 | 武汉四通信息服务有限公司 | Cluster deployment method and device, electronic equipment and storage medium |
| CN114827171B (en) * | 2022-03-23 | 2023-12-15 | 青岛中科曙光科技服务有限公司 | Information synchronization method, apparatus, computer device and storage medium |
| CN114817213A (en) * | 2022-05-31 | 2022-07-29 | 苏州浪潮智能科技有限公司 | Server database tuning test method, device, terminal and storage medium |
-
2022
- 2022-08-22 CN CN202211006741.1A patent/CN115292097B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN115292097A (en) | 2022-11-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9213607B2 (en) | Systems, methods, and media for synthesizing views of file system backups | |
| US20080208926A1 (en) | Data management in a data storage system using data sets | |
| US11237911B2 (en) | Object store for database backups | |
| US9135266B1 (en) | System and method for enabling electronic discovery searches on backup data in a computer system | |
| US9977706B2 (en) | System and method of validating data for incremental format of backup archive | |
| CN112596951B (en) | NAS data disaster recovery method, device, equipment and storage medium | |
| US9600376B1 (en) | Backup and replication configuration using replication topology | |
| US11531712B2 (en) | Unified metadata search | |
| US9201739B1 (en) | Method and system for a database management system add-in for third party backup and restore applications | |
| US11442752B2 (en) | Central storage management interface supporting native user interface versions | |
| CN112214351A (en) | Backup data recovery method and device, electronic equipment and storage medium | |
| US10318330B2 (en) | Data-persisting temporary virtual machine environments | |
| US10459905B2 (en) | Centralized hierarchical configuration system for applications in a distributed network | |
| US10387262B1 (en) | Federated restore of single instance databases and availability group database replicas | |
| CN115292097B (en) | Database instance creation method, apparatus, device, storage medium, and program product | |
| US9354853B2 (en) | Performing administrative tasks associated with a network-attached storage system at a client | |
| US12007851B2 (en) | Differential checksum validation | |
| US11544166B1 (en) | Data recovery validation test | |
| US10467104B1 (en) | Method and system for distributed systems backup configuration wizard | |
| US11501014B2 (en) | Secure data replication in distributed data storage environments | |
| US9489271B1 (en) | User interface for restoring databases | |
| US10938919B1 (en) | Registering client devices with backup servers using domain name service records | |
| US12066901B2 (en) | Protecting databases in a clusterless availability group | |
| CN116684282B (en) | Method and device for initializing newly-added cloud server and computer equipment | |
| US11782799B2 (en) | Using bitmaps to validate data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |