CN104573052A - Method for replacing storage based on Oracle ASM - Google Patents
Method for replacing storage based on Oracle ASM Download PDFInfo
- Publication number
- CN104573052A CN104573052A CN201510029488.5A CN201510029488A CN104573052A CN 104573052 A CN104573052 A CN 104573052A CN 201510029488 A CN201510029488 A CN 201510029488A CN 104573052 A CN104573052 A CN 104573052A
- Authority
- CN
- China
- Prior art keywords
- asm
- disk
- oracle
- data
- storage
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
- G06F3/0601—Interfaces specially adapted for storage systems
- G06F3/0602—Interfaces specially adapted for storage systems specifically adapted to achieve a particular effect
- G06F3/0604—Improving or facilitating administration, e.g. storage management
- G06F3/0607—Improving or facilitating administration, e.g. storage management by facilitating the process of upgrading existing storage systems, e.g. for improving compatibility between host and storage device
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for replacing the storage based on Oracle ASM and relates to the field of computer system design and databases. The method includes utilizing the Rebalance characteristic of the data file storage mode ASM of the Oracle database to add a newly stored disk into an ASM disk group where a database document of the database system is stored, and then deleting the stored disk to be replaced from the ASM disks, wherein ASM automatically distributes deleted disk data in the ASM disk group on the surplus disks of the ASM disk group in balance to achieve storage replacement. The method is achieved through the Oracle ASM automatically, manual error operation is avoided as much as possible, meanwhile non-breaking storage replacement in business production system is achieved, system working stability is ensured, and the system storage and replacement efficiency is improved.
Description
Technical field
The present invention relates to Computer System Design field and database field, be specifically related to a kind of method changing storage based on Oracle ASM.
Background technology
By the impact of the aspects such as economic globalization and global IT application, human social development and diversified demand, cloud computing and technology of Internet of things strengthened research, in the past few years, " large data " (bigdata) has become the hot word that IT field and internet are mentioned repeatedly, people describe with it the mass data produced for each field of human society with definition information explosion time, and the arriving of large data age.The data total amount of China's generation in 2013 is equivalent to 800,000,000 TB more than 0.8ZB(), be equivalent to the twice of 2012, be equivalent to the data total amount in the whole world in 2009.Expect 2020, the data total amount that China produces will be 10 times of 2013, more than 8.5ZB.
Along with the arriving of large data age, enterprise customer's original system storage space cannot meet growing big data quantity gradually, also to consider the safety problem of data simultaneously, as aging in hardware disk, hardware fault etc., this just relates to a problem, how to realize dilatation and the upgrading of operation system storage.
Can realize storing the mode of replacing has a lot, as from database aspect, by Backup and Restore mode or the disaster tolerance mode of database; Hardware view, reproduction technology of storage etc. can both realize the replacement work stored.But they all exist a problem, realize by the way storing replacing, need stopping business production system, waited after storing replacement (Data Migration) and could start business production system, the stand-by time of production system is directly proportional to data volume.Require to keep running for 7*24 hour for current many business event production systems, maybe cannot stand long-time shutdown, some above-mentioned migration patterns are just improper.
Summary of the invention
The present invention is directed to the technical matters existed at present, propose under one can ensure the unbroken situation of business event production system, realize the method storing replacement work.
A kind of method changing storage based on Oracle ASM of the present invention, the technical scheme solving the problems of the technologies described above employing is as follows: should change based on Oracle ASM the method stored, and proposes a kind of by the Oracle ASM method that fulfillment database storage is replaced under the situation of non-interrupting service production system; The method is applicable to the above version of business production system usage data storehouse Oracle10g, and adopt data storage method to be the business production system of ASM, in the unbroken situation of business, original memory disk is replaced with new memory disk by the Rebalance function of ASM, realize memory change.
The method changing storage based on Oracle ASM of the present invention, specifically utilize the Rebalance characteristic of oracle database data file storage mode ASM, new memory disk is joined in the ASM disk group that database system data library file deposits, then will the disk of the storage replaced be needed to delete from ASM disk, ASM being distributed on the remaining disk of ASM disk group automatically by data automatic equalization on the disk deleted in ASM disk group, thus realize replacing the replacement work stored.
Preferably, the method is not when stopping business production system, new memory disk is mapped in production system, and by the order of ASM disk fabric anomaly, new memory disk being joined in ASM disk group, database data in ASM disk group can on all disks being distributed in ASM disk group of automatic uniform.
Preferably, the memory disk that the method will be replaced by the order of ASM disk fabric anomaly is deleted from ASM disk group, and simultaneously ASM can by the data syn-chronization on the disk deleted from ASM disk group on the existing disk of ASM disk group.
Preferably, the method checks synchronous regime by the order of ASM disk fabric anomaly, after guaranteeing that data all synchronously complete, then thoroughly closes the memory disk replaced.
Of the present inventionly a kind ofly change based on Oracle ASM the beneficial effect that compared with prior art has of method stored and be: data to be evenly distributed in ASM disk group on each disk by Oracle ASM automatic equalization by the method, realize storing replacement work, more than work and all have Oracle ASM automatically to complete, maximum possible avoids people for maloperation, system database service can be realized do not need to stop simultaneously, thus achieve the work that production system does not interrupt replacing storage, ensure that the stability of system works, improve system storage simultaneously and change efficiency.
Accompanying drawing explanation
Accompanying drawing 1 is described ASM disk group Rebalance building-block of logic.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly understand, below in conjunction with specific embodiment, and with reference to accompanying drawing, to a kind of method further description changing storage based on Oracle ASM of the present invention.
A kind of method changing storage based on Oracle ASM of the present invention, proposes a kind of by the Oracle ASM method that fulfillment database storage is replaced under the situation of non-interrupting service production system.The method stored should be changed based on Oracle ASM, be applicable to the above version of business production system usage data storehouse Oracle10g, and adopt data storage method to be the business production system of ASM, ensure, in the unbroken situation of business, original memory disk is replaced with new memory disk by the Rebalance function of ASM, realize memory change.
Should change in the method stored, because more than Oracle10g version oracle database just possesses database purchase mode ASM based on Oracle ASM.ASM(Automated Storage Management, i.e. Automatic Storage Management) be the storage mode of a kind of database system data file that Oracle company provides, the storage mode of current oracle database system data file supports raw device, file system, ASM.Rebalance, is the function of a kind of self-poise ASM disk group data in magnetic disk that oracle database data file system storage mode ASM carries, production data automatic average can be assigned on each disk of ASM disk group.
Embodiment 1:
A kind of method changing storage based on Oracle ASM described in the present embodiment, does not interrupt replacing the method stored by realizing production system based on Oracle ASM; Utilize the Rebalance characteristic of oracle database data file storage mode ASM, join in ASM disk group that database system data library file deposits by newly storing, then will the disk of the storage replaced be needed to delete from ASM disk, ASM being distributed on the remaining disk of ASM disk group automatically by data automatic equalization on the disk deleted in ASM disk group, thus realize replacing the replacement work stored.
Change the method stored described in the present embodiment based on Oracle ASM, so that disk in ASM disk group is replaced with new memory disk, describe the implementation procedure of this structure, as shown in Figure 1.
Figure a in accompanying drawing 1 is before not changing storage, and database data leaves in and stores upper ASM disk group data status: data to be evenly distributed in ASM disk group on each disk.When not stopping production system business, new memory disk is mapped in production system, and by the order of ASM disk fabric anomaly, disk is joined in ASM disk group, database data in ASM disk group can on all disks being distributed in ASM disk group of automatic uniform, as the figure b in accompanying drawing 1.The memory disk that will be replaced by the order of ASM disk fabric anomaly is deleted from ASM disk group, and now ASM can by the data syn-chronization on the disk deleted from ASM disk group on the existing disk of ASM disk group, as the figure c in accompanying drawing 1.Check synchronous regime by the order of ASM disk fabric anomaly, after guaranteeing that data all synchronously complete, can thoroughly close the storage replaced, can not interrupt storing replacement work by finishing service.
Above-mentioned embodiment is only concrete case of the present invention; scope of patent protection of the present invention includes but not limited to above-mentioned embodiment; any claims according to the invention and any person of an ordinary skill in the technical field to its suitable change done or replacement, all should fall into scope of patent protection of the present invention.
Claims (4)
1. change the method stored based on Oracle ASM, it is characterized in that, propose a kind of by the Oracle ASM method that fulfillment database storage is replaced under the situation of non-interrupting service production system; The method is applicable to the above version of business production system usage data storehouse Oracle10g, and adopt data storage method to be the business production system of ASM, utilize the Rebalance characteristic of oracle database data file storage mode ASM, new memory disk is joined in the ASM disk group that database system data library file deposits, then will the disk of the storage replaced be needed to delete from ASM disk, ASM being distributed on the remaining disk of ASM disk group automatically by data automatic equalization on the disk deleted in ASM disk group, realizes memory change.
2. according to claim 1 a kind of based on Oracle ASM change store method, it is characterized in that, when not stopping business production system, new memory disk is mapped in production system, and by the order of ASM disk fabric anomaly, new memory disk being joined in ASM disk group, database data in ASM disk group can on all disks being distributed in ASM disk group of automatic uniform.
3. according to claim 2 a kind of based on Oracle ASM change store method, it is characterized in that, the memory disk that will be replaced by the order of ASM disk fabric anomaly is deleted from ASM disk group, and simultaneously ASM can by the data syn-chronization on the disk deleted from ASM disk group on the existing disk of ASM disk group.
4. according to claim 3 a kind of based on Oracle ASM change store method, it is characterized in that, check synchronous regime by the order of ASM disk fabric anomaly, after guaranteeing that data all synchronously complete, then thoroughly close the memory disk replaced.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510029488.5A CN104573052A (en) | 2015-01-21 | 2015-01-21 | Method for replacing storage based on Oracle ASM |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510029488.5A CN104573052A (en) | 2015-01-21 | 2015-01-21 | Method for replacing storage based on Oracle ASM |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104573052A true CN104573052A (en) | 2015-04-29 |
Family
ID=53089114
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510029488.5A Pending CN104573052A (en) | 2015-01-21 | 2015-01-21 | Method for replacing storage based on Oracle ASM |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104573052A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407397A (en) * | 2016-09-20 | 2017-02-15 | 郑州云海信息技术有限公司 | An oracle asm Rebalance-based data migration method and device |
| CN106933514A (en) * | 2017-03-15 | 2017-07-07 | 郑州云海信息技术有限公司 | A kind of automatic location mode of cold and hot data of ASM disks group and system |
| CN109597819A (en) * | 2018-12-07 | 2019-04-09 | 北京字节跳动网络技术有限公司 | Method and apparatus for more new database |
| CN112860668A (en) * | 2021-02-23 | 2021-05-28 | 浪潮云信息技术股份公司 | Implementation method of Store disabling and enabling functions |
| CN113655967A (en) * | 2021-08-23 | 2021-11-16 | 中国建设银行股份有限公司 | Method and device for deleting disk, electronic equipment and computer storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2725764A1 (en) * | 2012-03-12 | 2014-04-30 | Huawei Technologies Co., Ltd | Data storage method and data storage device |
-
2015
- 2015-01-21 CN CN201510029488.5A patent/CN104573052A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2725764A1 (en) * | 2012-03-12 | 2014-04-30 | Huawei Technologies Co., Ltd | Data storage method and data storage device |
Non-Patent Citations (2)
| Title |
|---|
| HACKERSANDPAINTERS: "Oracle ASM存储转移", 《HTTP://BLOG.CSDN.NET/L106439814/ARTICLE/DETAILS/7952263》 * |
| L: "[原创]L随笔日记：说说一天能够做什么？（针对Oracle技术）", 《HTTP://F.DATAGURU.CN/THREAD-97872-1-1.HTML》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106407397A (en) * | 2016-09-20 | 2017-02-15 | 郑州云海信息技术有限公司 | An oracle asm Rebalance-based data migration method and device |
| CN106933514A (en) * | 2017-03-15 | 2017-07-07 | 郑州云海信息技术有限公司 | A kind of automatic location mode of cold and hot data of ASM disks group and system |
| CN109597819A (en) * | 2018-12-07 | 2019-04-09 | 北京字节跳动网络技术有限公司 | Method and apparatus for more new database |
| CN109597819B (en) * | 2018-12-07 | 2020-12-18 | 北京字节跳动网络技术有限公司 | Method and apparatus for updating a database |
| CN112860668A (en) * | 2021-02-23 | 2021-05-28 | 浪潮云信息技术股份公司 | Implementation method of Store disabling and enabling functions |
| CN112860668B (en) * | 2021-02-23 | 2023-07-14 | 浪潮云信息技术股份公司 | Method for realizing Store disabling and enabling functions |
| CN113655967A (en) * | 2021-08-23 | 2021-11-16 | 中国建设银行股份有限公司 | Method and device for deleting disk, electronic equipment and computer storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104573052A (en) | Method for replacing storage based on Oracle ASM | |
| CN102843418B (en) | A kind of resource scheduling system | |
| CN103218175B (en) | The cloud storage platform access control system of many tenants | |
| CN101814045B (en) | Data organization method for backup services | |
| CN103226539B (en) | Service level objective for cloud hosts applications | |
| CN104065685B (en) | Data migration method towards in the bedding storage system of cloud computing environment | |
| CN104252485A (en) | Database management platform | |
| CN103955510A (en) | Massive electricity marketing data integration method uploaded by ETL cloud platform | |
| CN105468476B (en) | Data disaster recovery and backup systems based on HDFS | |
| CN109325075A (en) | A kind of timely carry recovery system of Oracle based on timed backup and method | |
| CN102609337A (en) | Rapid data recovery method for memory database | |
| CN102360357A (en) | Data synchronization component of network relation database nodes of SCADA (Supervisory Control and Data Acquisition) system | |
| CN102170460A (en) | Cluster storage system and data storage method thereof | |
| CN110502523A (en) | Business datum storage method, device, server and computer readable storage medium | |
| US20130290265A1 (en) | Backup jobs scheduling optimization | |
| CN110737504B (en) | Fault-tolerant method, system, terminal and storage medium for deep learning model training | |
| CN106155838B (en) | A kind of database back-up data restoration methods and device | |
| CN104182306A (en) | Low-cost intelligent breakdown instant switching method for cloud host | |
| CN109101320A (en) | Heterogeneous processor fusion of platforms management system | |
| CN103761059A (en) | Multi-disk storage method and system for mass data management | |
| CN110083306A (en) | A kind of distributed objects storage system and storage method | |
| CN103593257A (en) | Data backup method and device | |
| CN103593420A (en) | Method for constructing heterogeneous database clusters on same platform by sharing online logs | |
| CN102820998B (en) | Realize the dual computer fault-tolerant service system towards office application and date storage method thereof | |
| CN107111534A (en) | A kind of method and apparatus of data processing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150429 |