Detailed steps for Oracle automatic backup

Detailed steps for Oracle automatic backup: the Oracle database server automatically backs up the database ylios once a day. Solution: The Oracle backup file is automatically generated by date using the task plan, batch file, and Oracle exp export function. Detailed steps: 1. Create the batch processing file exp_ylios.bat. The details are as follows: @ echo off echo is backing up the Yiling database. Please wait ...... set filename = ylios _ % Date :~ 0, 4% % Date :~ 5, 2% % Date :~ 8, 2% % time :~ 0, 2% % time :~ 3,2% % time :~ 6, 2% exp ylios/ylios_123456 @ orcl file = E: \ data_bak \ % filename %. dmp log = E: \ data_bak \ % filename %. log buffer = 204800000 rar a-df E: \ data_bak \ Program filename=.rar E: \ data_bak \ % filename %. dmp echo database backup is complete! 2. Add a task scheduler ylios Start> All Programs> accessories> System Tools> Task Scheduler> Add Task Scheduler> next> Search for the prepared exp_ylios.bat file in the browser> enter the task name ylios, run this task on a daily basis, next step>, start date:, next step> enter the user name and password. The user name must be the user name of the Administrator permission. Next Step> click Finish, A new task plan named "ylios" is added to the task plan column, indicating that the configuration has been completed.