CN103793529A - Method for manually restoring ASM files - Google Patents
Method for manually restoring ASM files Download PDFInfo
- Publication number
- CN103793529A CN103793529A CN201410065297.XA CN201410065297A CN103793529A CN 103793529 A CN103793529 A CN 103793529A CN 201410065297 A CN201410065297 A CN 201410065297A CN 103793529 A CN103793529 A CN 103793529A
- Authority
- CN
- China
- Prior art keywords
- asm
- disk
- file
- information
- data
- 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
Images
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/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method for manually restoring ASM files, and relates to the fields of computer system design and data bases. Damaged or lost ASM magnetic disks are reconstructed by obtaining ASM magnetic disk information, information of related magnetic disks is obtained through PST information, data files in the ASM magnetic disks are obtained through alias, and therefore the final data files are obtained. Under the condition that no backup exists, data restoration is achieved by manually extracting the damaged ASM magnetic disk files.
Description
Technical field
The present invention relates to Computer System Design field and database field, be specifically related to a kind of method of manual recovery ASM file.
Technical background
ASM full name is Automated Storage Management, i.e. Automatic Storage Management, and it is the new function of releasing from this version of Oracle10g Oracle.This is the volume manager that Oracle provides, the LVM providing for substituting operating operation system, and it not only supports single exemplary configuration, also supports many exemplary configuration that RAC is such.To bring great convenience to oracle database keeper, ASM is hyperdisk group automatically, and data redundancy and optimization are provided.Particularly, for the large data library manager of enterprise's utmost point, can make keeper from manage these trifling routine matters of hundreds and thousands of data files, free and to come, get on to process other even more important affairs.
Before this version of Oracle 10g, the data files of managing hundreds and thousands of of large database to data base administrator be one not only without technology content but also scissors and paste very, this requires data base administrator will be familiar with the relevant knowledge of the LVM of some systems, carry out disk ruleization, the associative operation of the system aspects that the band of LV etc. are relevant.And using Automatic Storage Management greatly to alleviate the workload of this respect, data base administrator only need to manage a few disk group.A disk group is a logical block of ASM management, is made up of one group of disk unit.We can define the acquiescence disk group of a disk group as database, and Oracle can automatic managed storage, comprise establishment, delete data file etc.Oracle can do these files database object suitable with associated automatically, and we only need to provide the title of object in the time of these objects of management like this, and without detailed filename is provided as before.
ASM provides a lot of useful memory technologies, as RAID and LVM(logical volume management) etc.As these technology, ASM allows you independently on disk, to create an independent disk group at one group.So just realize the I/O equilibrium of single disk group.Simultaneously ASM has also realized striping (Striping) and disk mirroring (Mirroring) to improve performance and the data reliability of I/O.Different from RAID or LVM is, ASM is striping and the mirror image of realizing in file-level, such implementation has been with very large selection degree of freedom to user, and the memory attribute that we can be different to different file configuration in same disk group, realizes different storage modes.
Due to the important information that has comprised ASM in ASM head, if a data, because artificial destruction or hardware problem cause loss of data can cause so oracle database to start, and then likely causes the loss of data in ASM disk.
Summary of the invention
The present invention utilizes to read ASM metadata and obtain the data file name being present in ASM disk, then by extract the file in corresponding disk with ASMDU, thereby in the time that ASM disk cannot mount as a kind of means of data recovery.Method for designing of the present invention is that the relevant information by reading in ASM DISK HEADER comprises kfdhdb.driver.provstr, kfdhdb.dskname, kfdhdb.blksize, kfdhdb.ausize, kfdhdb.fstlocn, kfdhdb.f1b1locn etc., obtain the information such as corresponding disk, disk group, AU by reading the data of these fields, obtain the essential information of corresponding environment.Then obtain the crucial metadata kfffde[0 of ALIAS DIRECTORY] .xptr.au, obtain the specifying information of data file another name by these data, thereby obtain corresponding database instance name, and then obtain the title of the files such as corresponding system, confile, redo, then extract corresponding file with AMDU.Thereby reach thereby also can obtain data file from the disk of ASM after ASM example down the object that data are recovered.
The invention has the beneficial effects as follows: this method is by reading PST data, then according to data construct ASM headers such as kfdhdb.dskname, kfdhdb.grpname, kfdhdb.fgname, kfdhdb.dsksize, then according to the crucial metadata kfffde[0 of ALIAS DIRECTORY] .xptr.au obtains the specifying information of data file another name, thus can be by the data pick-up in ASM disk out; Reduce the situation of the loss of data causing because there is no data backup.
The method of this manual recovery ASM file has above-mentioned advantage, without data backup in the situation that, can reduce loss of data, has protected the data of enterprise.
Accompanying drawing explanation
Accompanying drawing 1 building-block of logic of the present invention.
Embodiment
With reference to the accompanying drawings, content of the present invention, take manual recovery ASM file as example, is described to the implementation procedure of this structure.
As described in summary of the invention, logic realization construction design method of the present invention mainly comprises: ASM DISK HEADER(1), PST(2), FILE DIRECTORY(3), DISK DIRECTORY(4), ALIAS DIRECTORY(5), by reading PST data, then according to kfdhdb.dskname, kfdhdb.grpname, kfdhdb.fgname, the data construct ASM headers such as kfdhdb.dsksize, utilization is read ASM metadata and is obtained the data file name being present in ASM disk, then by extract the file in corresponding disk with ASMDU, thereby the means of recovering as a kind of data in the time that ASM disk cannot mount.
Claims (5)
1. a method for manual recovery ASM file, is characterized in that the method comprises ASM DISK HEADER(1), PST(2), FILE DIRECTORY(3), DISK DIRECTORY(4), ALIAS DIRECTORY(5); By reading PST data, then according to data construct ASM headers such as kfdhdb.dskname, kfdhdb.grpname, kfdhdb.fgname, kfdhdb.dsksize, utilization is read ASM metadata and is obtained the data file name being present in ASM disk, then by extract the file in corresponding disk with ASMDU.
2. method according to claim 1, it is characterized in that described ASM DISK HEADER, it is mainly the Proprietary Information of this asm disk, for example asm disk name, group name, ausize, the time of establishment and carry, the kfed tool that can provide by oracle reads the information of asm disk header, is recorded in first block of first AU.
3. method according to claim 1, it is characterized in that described APST is used for following the tracks of the member relation of diskgroup, second au of each disk is used for preserving pst content, last block of pst, for the heartbeat of disk group, prevents by the different clusters identical disk group of carry simultaneously.
4. method according to claim 1, is characterized in that the asm disc information of described ADISK DIRECTORY for recording disc group, comprises the size of disk, and disk creates creation-time, the information such as mounting time.
5. method according to claim 1, is characterized in that described AALIAS DIRECTORY, for recording asm another name information, comprises the disk at file place, the title of file and another name, the information such as the directory name of file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410065297.XA CN103793529A (en) | 2014-02-26 | 2014-02-26 | Method for manually restoring ASM files |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410065297.XA CN103793529A (en) | 2014-02-26 | 2014-02-26 | Method for manually restoring ASM files |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103793529A true CN103793529A (en) | 2014-05-14 |
Family
ID=50669195
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410065297.XA Pending CN103793529A (en) | 2014-02-26 | 2014-02-26 | Method for manually restoring ASM files |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103793529A (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070198610A1 (en) * | 2006-02-17 | 2007-08-23 | Hon Hai Precision Industry Co., Ltd. | System and method for backing up a database |
| CN103336728A (en) * | 2013-05-08 | 2013-10-02 | 上海爱数软件有限公司 | Disk data recovery method |
-
2014
- 2014-02-26 CN CN201410065297.XA patent/CN103793529A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070198610A1 (en) * | 2006-02-17 | 2007-08-23 | Hon Hai Precision Industry Co., Ltd. | System and method for backing up a database |
| CN103336728A (en) * | 2013-05-08 | 2013-10-02 | 上海爱数软件有限公司 | Disk data recovery method |
Non-Patent Citations (1)
| Title |
|---|
| DAVE: "Oracle RAC ASK disk header备份恢复与重建示例说明", 《HTTP://BLOG.CSDN.NET/TIANLESOFTWARE/ARTICLE/DETAILS/6743677》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10146631B1 (en) | Incremental forever backups for exchange | |
| JP5145098B2 (en) | System and method for directly exporting data from a deduplication storage device to a non-deduplication storage device | |
| US9703640B2 (en) | Method and system of performing incremental SQL server database backups | |
| US9411821B1 (en) | Block-based backups for sub-file modifications | |
| US7634627B1 (en) | System and method for performing extent level backups that support single file restores | |
| US8433867B2 (en) | Using the change-recording feature for point-in-time-copy technology to perform more effective backups | |
| US7822726B1 (en) | Encapsulation of storage object extensibility records for backup and restore | |
| US9778996B1 (en) | File system version set infrastructure | |
| US7979404B2 (en) | Extracting data changes and storing data history to allow for instantaneous access to and reconstruction of any point-in-time data | |
| US9996429B1 (en) | Mountable container backups for files | |
| US8738668B2 (en) | System and method for creating a de-duplicated data set | |
| US8438136B2 (en) | Backup catalog recovery from replicated data | |
| US10872017B2 (en) | Restoring a file system object | |
| JP2020525925A (en) | System and method for restoring database datasets at a point in time | |
| US10078555B1 (en) | Synthetic full backups for incremental file backups | |
| US20070094312A1 (en) | Method for managing real-time data history of a file system | |
| KR101674176B1 (en) | Method and apparatus for fsync system call processing using ordered mode journaling with file unit | |
| US11663160B2 (en) | Recovering the metadata of data backed up in cloud object storage | |
| JP2011510405A (en) | Scalable deduplication mechanism | |
| CN112800019A (en) | Data backup method and system based on Hadoop distributed file system | |
| US11853165B2 (en) | Using file system extended attributes to update databases in hierarchical file systems | |
| US11079960B2 (en) | Object storage system with priority meta object replication | |
| CN103176868B (en) | A kind of file status backup method | |
| US7865472B1 (en) | Methods and systems for restoring file systems | |
| CN103793529A (en) | Method for manually restoring ASM files |
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 |
Application publication date: 20140514 |
|
| WD01 | Invention patent application deemed withdrawn after publication |