How to Implement ORACLE backup

Source: Internet
Author: User

ORACLE backup should be the knowledge we all need to know. The following describes how to use ORACLE backup for your reference. If you have encountered similar problems in ORACLE backup, take a look.

The task plan, batch processing file, and oracle exp export function can automatically generate ORACLE backup files based on the date, greatly facilitating ORACLE backup. :

1. Create a batch file backup. bat

Exp system/manager file = d: \ backup \ oracle % date :~ 0, 10%. dmp owner = system log = d: \ backup \ oracle % date :~ 0, 10%.

Log will generate the oracle2006-01-09.dmp File

2. Add a task scheduler. Use the task scheduler Wizard to set the time frequency for automatic task execution based on the ORACLE backup policy, for example, every day. Execute backup. bat.

3. backups and log files such as oracle2005-08-31.dmp and oracle2005-08-31.log will be generated in the directory every day.

Note:

(1) The value of % date % may be different in different system and language versions. The setting of the region options in the control panel will also change the value of % date %. Test the return value of echo % date % in the command line. % Date :~ 4,10% is the return date function ,~ The first parameter is the starting position starting from 0. The second parameter is the length to be truncated. If not, the parameter is truncated to the end. You can modify the parameter as needed.

(2) If you need accurate time as the file name, use the % time % function. The parameters are the same as above.

Oracle backup command to use instances

Oracle single row date functions

Introduction to Oracle bitand () Functions

Use of oracle Aggregate functions

Oracle functions for Calculating Time Difference

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.