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