Oracle uses EXP to automatically back up and delete old backups

Between my ability is limited

This method is only suitable for small data volumes

A huge amount of data, another way to find him.

Step One: Write the bat batch file

Echo is removing the spare files and logs from 7 days ago ... forfiles/P"D:\Backup\OracleAutoBackup"/M ZYWL_*.DMP/D-7/C"cmd/c del @path"forfiles/P"D:\Backup\OracleAutoBackup"/M ZYWL_*.LOG/D-7/C"cmd/c del @path"echo Delete Complete ... echo is backing up the Oracle database ...ExpZywl/[email protected] file=d:\backup\oracleautobackup\zywl_%Date:~0,4%%Date:~5,2%%Date:~8,2%.dmpLog=d:\backup\oracleautobackup\zywl_%Date:~0,4%%Date:~5,2%%Date:~8,2%.log owner=zywlecho Task completed ...

Step two: Set up a task plan

Find Task Scheduler in System Tools

Click "Create basic Task" in the Action window

Fill in the task name to configure the trigger execution cycle

Select the bat batch file you just wrote to

Oracle uses EXP to automatically back up and delete old backups