ORACLE data backup method

A data backup and data technology, applied in relational databases, database models, structured data retrieval, etc.

Inactive Publication Date: 2016-03-02
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF2 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical task of the present invention is to provide an ORACLE data backup method to solve the problem of inability to execute a timed task and shell script to realize data backup, effective data retention and expired data cleaning The problem

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0014] The present invention will be further described below by specific examples.

[0015] A kind of ORACLE data backup method of the present invention comprises the following steps:

[0016] (1) Create a backup directory and a script directory and assign permissions;

[0017] su –oracle

[0018] mkdir–p / oracle / backup / script## Backup script storage directory

[0019] chmod –Ra+x / oracle / backup / script

[0020] mkdir–P / oracle / dbback##Backup file and log storage directory

[0021] chmod –Ra+x / oracle / dbback

[0022] (2) Write exp data automatic backup shell script;

[0023] Script content:

[0024] #! / bin / bash

[0025] exportPATH=" / usr / jdk1.6.0_45 / bin: / bin: / usr / lib / qt-3.3 / bin: / usr / kerberos / bin: / usr / local / bin: / bin: / usr / bin: / home / oracle / bin: / home / oracle / bin: / oracle / product / 10.2.0 / bin: / crs / bin"##Consistent with user environment variables

[0026] DISK_SIZE=`df -k|grep / dev / mapper / mpath0p2|awk'{printsubstr($5,1)}'|cut -d "%" -f1`

[0027] exportDISK_SIZE#Get the disk usage ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses an ORACLE data backup method, belongs to a data backup method, and solves the technical problem that data backup, effective data reservation and stale data cleanup cannot be realized by executing a timed task and a shell script once. The technical scheme is that the method comprises the following steps: (1) creating a backup catalog and a script catalog, and performing permission granting; (2) writing exp data for automatically backing up the shell script; and (3) executing crontab-e, and editing a timed script.

Description

Technical field [0001] The invention involves a data backup method, which is specifically a method of Oracle data backup. Background technique [0002] When a small and medium -sized database is not purchased or deployed separately when the database is backup, it is expected that the shell script can be performed on the data backup through the timing task function.However, there is a manual intervention in the retention time of data and expired data during the backup process, that is, it is impossible to perform a timing task and shell script to implement data backup, effective data retention and expired data cleaning. Invention content [0003] The technical task of the present invention is to provide an Oracle data backup method to solve the problem of being unable to perform a timing task and shell script to implement data backup, effective data retention and expired data cleaning. [0004] The technical solution used to solve its technical problems of the present invention ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F11/14
CPCG06F16/284G06F11/1458G06F16/27
Inventor 关坤龙
Owner LANGCHAO ELECTRONIC INFORMATION IND CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap