CN108009046A - A kind of method of ORACLE data remote backup - Google Patents
A kind of method of ORACLE data remote backup Download PDFInfo
- Publication number
- CN108009046A CN108009046A CN201711162345.7A CN201711162345A CN108009046A CN 108009046 A CN108009046 A CN 108009046A CN 201711162345 A CN201711162345 A CN 201711162345A CN 108009046 A CN108009046 A CN 108009046A
- Authority
- CN
- China
- Prior art keywords
- data
- batch processing
- processing script
- backup
- strange land
- 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
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific 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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of method of ORACLE data remote backup, comprise the steps of:Compressed file instrument is installed;Write the batch processing script of expdp data backups;Configure the batch processing script that Windows timings plan target is used for performing gained on time;Configure the FTP service of strange land machine;The batch processing script of expired Backup Data is cleared up in the timing for writing strange land machine;The timing plan target timing for configuring strange land machine performs batch processing script for removing expired Backup Data.The present invention realizes that data are backed up in timing, strange land is transmitted and the purpose of removing stale data.
Description
Technical field
The present invention relates to data backup field, more particularly to a kind of method of ORACLE data remote backup.
Background technology
It is priceless using data for most companies, therefore the backup of application data just seems very heavy
Will.But it is entirely different concept that the long-distance disaster of data is backed up with our daily native datas, is most had in data disaster tolerance
Ensure be also it is most effective be exactly disaster-tolerant backup scheme because it is that data backup is saved in another place.So as to
Avoid because the foeign element such as computer virus, hacker attack, natural calamity is lost caused by data, so as to reduce because of data
Destroy the heavy loss brought to company.
TB grades of toy data base is not reaching to typically, for some data volumes, many companies are all without purchase one
The backup scenario or backup software of a little expert data backup companies, but wish to carry out strange land appearance to database by timing
Calamity back up, but common DB Backup process all there is a situation where human intervention, it is necessary to special messenger timing regularly to data into
Row backup and removing work, many uncertainties so just come to the backup tape of data, it is more likely that do not reach very well
Backup effect.
The content of the invention
The shortcomings that it is an object of the invention to overcome the prior art and deficiency, there is provided a kind of ORACLE data remote backup
Method, realizes that data are backed up in timing, strange land is transmitted and the purpose of removing stale data.
The purpose of the present invention is realized by following technical solution:
A kind of method of ORACLE data remote backup, comprises the steps of:
(1) compressed file instrument is installed;
(2) the batch processing script of expdp data backups is write;
(3) Windows timings plan target is configured to be used for performing the batch processing script obtained by step (2) on time;
(4) FTP service of strange land machine is configured;
(5) the batch processing script of expired Backup Data is cleared up in the timing for writing strange land machine;
(6) the timing plan target timing for configuring strange land machine performs batch processing script for removing expired Backup Data.
In step (1), the compressed file instrument is WinRAR.Installation compressed file be mainly used for the data of backup into
Row compression is handled, and saves the transmission time of Backup Data.
The step (3) is specially:Batch processing as obtained by Windows timing plan targets instrument adds step (2)
Path where script, and configure the specific time that the good task needs to perform.
The step (6) is specially:Added on the strange land machine of data disaster tolerance by Windows timing plan targets instrument
Path where batch processing script, and configure the specific time that the good task needs to perform.
The batch processing script, its information being related to can be adjusted change according to the needs of technical staff, described
Information includes database instance name, account, password, the IP of FTP.
Compared with prior art, the present invention having the following advantages that and beneficial effect:
1st, the timing plan target that the present invention is mainly carried by Windows systems, which is timed, performs batch processing foot
This, comparatively, configuration is simple, stability is strong, and can be adapted to different Windows operating systems.
2nd, backup is operated by writing a batch processing script, can be related to script under different demands
Parameter carry out simple modification can meet demand, comparatively flexibly and efficiently.
3rd, database can be carried out a full backup and data can also be carried out strange land transmission by the present invention, be reached
The purpose of one disaster-tolerant backup, so as to reduce the risk of loss of data.
4th, present invention addresses the work that special messenger's right place backs up data, full automation is realized, so that
The loss brought by people's operation error to data is avoided, the burden of staff is decreased, improves work efficiency.
Brief description of the drawings
Fig. 1 is a kind of flow chart of the method for ORACLE data remote backup of the present invention.
Embodiment
With reference to embodiment and attached drawing, the present invention is described in further detail, but embodiments of the present invention are unlimited
In this.
Such as Fig. 1, a kind of method of ORACLE data remote backup, comprises the steps of:
(1) compressed software instrument WinRAR is installed;(explanation:Installation compressed file is mainly used for the data progress to backup
Compression is handled, and saves the transmission time of Backup Data.)
(2) expdp data backup batch processing scripts are write;(explanation:The batch processing of this example includes some exemplary datas,
Concrete operations can be adjusted as needed.)
@echo off
Rem sets variable
SET Year=%date:~0,4%
SET Month=%date:~5,2%
SET Day=%date:~8,2%
SET NOWDATE=%Year%_%Month%_%Day%
Rem sets backup directory
SET BACKUPDIR=D:\Backup
IF NOT EXIST%BACKUPDIR% (
MD%BACKUPDIR%
)
Rem is passed through exemplified by backing up test user data using data pump technology export database data, this example
Expdptest/orcl_2017@ORCL DIRECTORY=oradumpdumpfile=%NOWDATE%.dmp logfile
=%NOWDATE%.log schemas=test
Rem is compressed processing using WinRAR to derived database file
"C:\Program Files\WinRAR\WinRAR.exe"a-k-r-s-m1
D:Backup %NOWDATE%.rar D:Backup %NOWDATE%.*
Rem sets the IP address and FTP accounts and password of remote backup server
SET HOST=192.168.1.132
SET FTP_USERNAME=Administrator
SET FTP_PASSWORD=test@123
Rem is created FTP translation profiles file and is transmitted using binary system
Cd/d%BACKUPDIR%
Echo open%HOST%>>%BACKUPDIR% ftp.cfg
Echo user%FTP_USERNAME%%FTP_PASSWORD%>>%BACKUPDIR% ftp.cfg
echo bin>>%BACKUPDIR% ftp.cfg
echomkdiroradmp>>%BACKUPDIR% ftp.cfg
echo cd oradmp>>%BACKUPDIR% ftp.cfg
Echomput%NOWDATE%.rar>>%BACKUPDIR% ftp.cfg
echo bye>>%BACKUPDIR% ftp.cfg
Rem carries out FTP transmission, after the completion of delete configuration file and uncompressed backup file and daily record ftp-i-n-
v-s:%BACKUPDIR% ftp.cfg
Del/f/s/q%BACKUPDIR% ftp.cfg 2>&1>nul
Del/f/s/q%BACKUPDIR% * .dmp 2>&1>nul
Del/f/s/q%BACKUPDIR% * .log 2>&1>nul
Rem clears up local backup file, local only to retain first three day file
Forfiles/P%BACKUPDIR%/S/C " cmd/c del/f/s/q@file "/D-3 2>&1>nul for/f"
Usebackup " %%din (` " dir/ad/b/s | sort/R " `) dord " %%d " 2>&1>nul for/f"tokens
=* " %%ain (' dir/b/ad/s " %BACKUPDIR% " ^ | sort/r') dord " %%a " 2>&1>nul
(3) by path where Windows timing plan target instrument interpolation data backups autoexec, and configure
The good task needs the specific time performed;
(4) FTP service has been configured on the strange land machine of data disaster tolerance;
(5) the batch processing script that stale data is cleared up in timing is write;
@echo off
Rem clears up the file of strange land data catastrophic failure-tolerant backup, only retains the first seven day file
forfiles/P"D:\OracleBackup\oradmp"/S/C"cmd/c del/f/s/q@file"/D-7 2>&1
>nul
(6) batch processing is removed by Windows timing plan target instruments interpolation data on the strange land machine of data disaster tolerance
Path where file, and configure the specific time that the good task needs to perform.
The information such as the IP of database instance name, account, password and FTP arrived involved in script can be according to technology people
The needs of member are adjusted change.
Technical scheme is mainly the Oracle backups being applied on windows platform, is carried by Windows
Timing plan target come execution module batch processing script complete data backup and strange land transmission, and on the machine of strange land lead to
Cross timing plan target and achieve the purpose that stale data is removed automatically to perform batch processing script.And by remote backup significantly
The security of data is improved, reduces the risk brought by data degradation to company.
First:" a kind of Oracle data back up method ", 201510903876.1, which discloses one kind
ORACLE data back up method, but the program and the system application platform in the present invention are different, have such difference:1st, two
Although a invention is all ORACLE data back up method, the program can be only applied to Linux platform system and of the invention
It can apply in windows platform system;2 and the script that uses it is different, the program uses Shell scripts to compile
Write and the present invention uses Windows order lines;3rd, the mode of backup is different, and the program is local backup and this programme is
Remote backup.
Second:" a kind of Oracle multi-channel parallels backup and restoration methods ", 201510405568.6, the technical solution
Backup and the restoration methods of a kind of ORACLE multi-channel parallels are disclosed, but the program has greatly with the backup mode in the present invention
Difference, has such difference:The program is mainly to realize that multichannel backs up with the RMAN backups of ORACLE, and the present invention is
Backed up using the expdp data pump technologies of ORACLE.
3rd:" one kind is based on oracle database backup and restoration methods ", 201510537941.3, the technical solution
A kind of method for disclosing ORACLE DB Backups and recovery, has such difference:The program is primarily directed to backup number
During according to circulation, security, reliability, confidentiality, the practicality of file are backed up, and the present invention is primarily directed to ORACLE data
One strange land is backed up completely, therefore emphasis is completely different.
4th:" a kind of tables of data backup method and device based on oracle database ", 201410131490.9, should
Technical solution discloses the tables of data backup method and device of a kind of ORACLE databases, has such difference:Program master
If for the quick backup scheme of mass data, and the strange land that the present invention is realized primarily directed to small and medium databases is complete
Full backup.
The present invention realizes the strange land automation backup of ORACLE, efficiently ORACLE data can be carried out timing strange land appearance
Calamity backs up, and is lost so as to reduce because of computer virus intrusion, hacker attack and natural calamity caused by data, while
Reduce the work load of staff, improve work efficiency.
Above-described embodiment is the preferable embodiment of the present invention, but embodiments of the present invention and from above-described embodiment
Limitation, other any Spirit Essences without departing from the present invention with made under principle change, modification, replacement, combine, simplification,
Equivalent substitute mode is should be, is included within protection scope of the present invention.
Claims (5)
- A kind of 1. method of ORACLE data remote backup, it is characterised in that comprise the steps of:(1) compressed file instrument is installed;(2) the batch processing script of expdp data backups is write;(3) Windows timings plan target is configured to be used for performing the batch processing script obtained by step (2) on time;(4) FTP service of strange land machine is configured;(5) the batch processing script of expired Backup Data is cleared up in the timing for writing strange land machine;(6) the timing plan target timing for configuring strange land machine performs batch processing script for removing expired Backup Data.
- 2. the method for ORACLE data remote backup according to claim 1, it is characterised in that in step (1), the compression File tool is WinRAR.
- 3. the method for ORACLE data remote backup according to claim 1, it is characterised in that the step (3) is specially: Path where batch processing script as obtained by Windows timing plan targets instrument adds step (2), and configure it is good this Business needs the specific time performed.
- 4. the method for ORACLE data remote backup according to claim 1, it is characterised in that the step (6) is specially: Path where adding batch processing script by Windows timing plan targets instrument on the strange land machine of data disaster tolerance, and match somebody with somebody The specific time that the task needs to perform is put.
- 5. the method for ORACLE data remote backup according to claim 1, it is characterised in that the batch processing script, its The information being related to can be adjusted change according to the needs of technical staff, described information include database instance name, account, The IP of password, FTP.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711162345.7A CN108009046A (en) | 2017-11-21 | 2017-11-21 | A kind of method of ORACLE data remote backup |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711162345.7A CN108009046A (en) | 2017-11-21 | 2017-11-21 | A kind of method of ORACLE data remote backup |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108009046A true CN108009046A (en) | 2018-05-08 |
Family
ID=62053040
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711162345.7A Pending CN108009046A (en) | 2017-11-21 | 2017-11-21 | A kind of method of ORACLE data remote backup |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108009046A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109325075A (en) * | 2018-08-30 | 2019-02-12 | 黄疆 | A kind of timely carry recovery system of Oracle based on timed backup and method |
CN109324928A (en) * | 2018-09-13 | 2019-02-12 | 中通国脉物联科技南京有限公司 | A kind of method of automatically backup data file |
Citations (5)
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 |
CN201532631U (en) * | 2009-07-13 | 2010-07-21 | 升东网络科技发展(上海)有限公司 | Database remote backup system |
CN105373625A (en) * | 2015-12-09 | 2016-03-02 | 浪潮电子信息产业股份有限公司 | ORACLE data backup method |
CN105446824A (en) * | 2014-05-28 | 2016-03-30 | 无锡华润微电子有限公司 | Table increment obtaining method and remote data backup method |
CN106844093A (en) * | 2016-12-14 | 2017-06-13 | 国网北京市电力公司 | The method and device of Backup Data |
-
2017
- 2017-11-21 CN CN201711162345.7A patent/CN108009046A/en active Pending
Patent Citations (5)
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 |
CN201532631U (en) * | 2009-07-13 | 2010-07-21 | 升东网络科技发展(上海)有限公司 | Database remote backup system |
CN105446824A (en) * | 2014-05-28 | 2016-03-30 | 无锡华润微电子有限公司 | Table increment obtaining method and remote data backup method |
CN105373625A (en) * | 2015-12-09 | 2016-03-02 | 浪潮电子信息产业股份有限公司 | ORACLE data backup method |
CN106844093A (en) * | 2016-12-14 | 2017-06-13 | 国网北京市电力公司 | The method and device of Backup Data |
Non-Patent Citations (1)
Title |
---|
孙伟: "基于信息管理工作中批处理文件的应用", 《信息安全与技术》 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109325075A (en) * | 2018-08-30 | 2019-02-12 | 黄疆 | A kind of timely carry recovery system of Oracle based on timed backup and method |
CN109324928A (en) * | 2018-09-13 | 2019-02-12 | 中通国脉物联科技南京有限公司 | A kind of method of automatically backup data file |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
KR101035178B1 (en) | Systems and methods for automatic maintenance and repair of entites in data model | |
JP5563220B2 (en) | Method and system for data backup | |
US8397039B2 (en) | Storage systems and methods | |
CN107066357A (en) | A kind of database synthetic backup and carry restoration methods | |
CN103064763B (en) | A kind of data back up method and relevant device, system | |
US20030212920A1 (en) | System and method of volume health checking and recovery | |
AU4913997A (en) | Regeneration agent for back-up software | |
CN103699548A (en) | Method and equipment for recovering database data by using logs | |
CN108009046A (en) | A kind of method of ORACLE data remote backup | |
CN103729169A (en) | Method and device for determining scope of file to be migrated | |
CN106126427A (en) | A kind of method and system of fast quick-recovery test | |
CN104135483B (en) | A kind of network security automatically configures management system | |
CN106293882A (en) | A kind of virtual disk snapshot implementing method and device | |
CN107515801A (en) | A kind of data self-repairing method based on relevant database | |
CN104794143A (en) | Agent-free backup technology | |
US10289320B1 (en) | Utilizing a virtual backup appliance within data storage equipment | |
CN108804248B (en) | Automatic verification method for real-time protection data of volume | |
CN109697139A (en) | A kind of Database Automatic Backup method based on MongoDB, equipment and storage equipment | |
CN104063294B (en) | A kind of linux system backup and restoration methods | |
US6813632B2 (en) | Distributed file system using scatter-gather | |
CN106326041A (en) | Second-level recovery method for database | |
CN103942123A (en) | Method and system for achieving cloud disaster recovery backup through reverse data fetching | |
CN104375903A (en) | Asynchronous data processing method and device for trading flow records | |
CN103853633A (en) | Application program injection type backup method based on operation information application discovery of virtual machine | |
CN107977403A (en) | The inquiry of historical data method and device |
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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180508 |
|
RJ01 | Rejection of invention patent application after publication |