Oracle automatic backup method

Oracle automatic backup method:

 

@ Echo off
Setlocal
Set SID =? // Modify the SID value based on the actual situation
Set username =? // Assign values based on actual conditions
Set Password =? // Assign values based on actual conditions
Set bakdir =? // Enter the backup path based on the actual situation
Set bakdate = % Date :~ // Format the time, for example
Set connect = % username %/% password % @ % Sid %
Exp % connect % full = y buffer = 64000000 file = % bakdir % \ % bakdate %. dmp log = % bakdir % \ exp % bakdate %. Log
Forfiles/P % bakdir %/D-10-c "CMD/C del/f/Q @ path" // delete files 10 days ago
Endlocal

After saving the script as a bat file (such as back. BAT), add the task to the scheduled task of the system and run the script at or every day.