If you want to take export backup on windows servers, you can take with batch scripts and windows schedule tasks. You can create backup directory for this scripts and backups. We will use EXPORTDIR directory and below data, scripts, daily directories. You have to create three scripts file below scripts directory for this issue. <\/p>\n
Firstly, you have to create export script file. The extension can be “.txt” for this file.<\/p>\n
Export Script File : SchemaName.txt<\/strong><\/p>\n \nUSERID=sysbackup\/password Secondly, you have to create execute script file. The extension can be “.bat” for this file. This file will execute SchemaName.txt file. <\/p>\n Execute Export Script File : Export_SchemaName.bat<\/strong><\/p>\n \nset SHELL_DIR=D:\\EXPORTDIR\\scripts\\ exp parfile=%SHELL_DIR%SchemaName.txt Thirdly, you have to create general executable batch file to execute export scripts of all schemas. This file will add windows schedule tasks. The extension can be “.bat” for this file. Also this script make zip file this backups. <\/p>\n Export File : Execute_Exports.bat<\/strong><\/p>\n \nset SHELL_DIR=D:\\EXPORTDIR\\scripts\\ REM Deletin Old Files<\/p>\n del %BACKUP_DAILY%* \/Q<\/p>\n exp parfile=%SHELL_DIR%SchemaName.txt copy %BACKUP_DIR%data_SchemaName_expdat.dmp %BACKUP_DIR%data_SchemaName_expdat_%BACKUP_DAY%.dmp Finally, you have to add windows schedule tasks for Execute_Exports.bat as daily, weekly… Delete Old Backups File : Delete_Old_Backups.bat<\/strong><\/p>\n \n@ECHO OFF :: Check the Windows version :: Initialize variable :: Read the Date format from the registry :: Check if a valid date was specified :: Check if the second argument is a valid number :: Parse the date specified :: Check for errors :: Convert the parsed Gregorian date to Julian :: Display original input :: Add or subtract the specified number of days :: Convert the new Julian date back to Gregorian again :: Reformat the date to local format :: Display the result :: Action :: Return the result in a variable named after this batch file :GDate :JDate :ParseDate :ReadDateFormat :ReformatDate :DeleteOlder :Syntax This solution can be provided that you can export backup of one and more schemas with changing three scipts. If you want to add the other schemas, you have to add newSchemanName.txt, Export_newSchemaName.bat and change Execute_Exports.bat script.<\/p>\n","protected":false},"excerpt":{"rendered":" If you want to take export backup on windows servers, you can take with batch scripts and windows schedule tasks. You can create backup directory for this scripts and backups. We will use EXPORTDIR directory and below data, scripts, daily directories. You have to create three scripts file below scripts directory for this issue. Firstly,…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[20],"tags":[23,14,90],"class_list":["post-286","post","type-post","status-publish","format-standard","hentry","category-oracle-backup-and-recovery","tag-backup-and-recovery-2","tag-database-administration","tag-oracle"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-4C","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=286"}],"version-history":[{"count":13,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/286\/revisions"}],"predecessor-version":[{"id":300,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/286\/revisions\/300"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=286"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nLOG=D:\\EXPORTDIR\\data\\data_SchemaName_exp.log
\nFILE=D:\\EXPORTDIR\\data\\data_SchemaName_expdat.dmp
\nGRANTS=y
\nINDEXES=y
\nROWS=y
\nCONSTRAINTS=y
\nOWNER=SchemaName\n<\/p><\/blockquote>\n
\nset BACKUP_DIR=D:\\EXPORTDIR\\data\\
\nset BACKUP_DAY=%date:~10,4%%date:~4,2%%date:~7,2%
\nset BACKUP_DAILY=D:\\EXPORTDIR\\daily\\
\nset ORACLE_SID=YOURDBSID<\/p>\n
\ndate \/T >> %BACKUP_DIR%log_SchemaName_exp.log\n<\/p><\/blockquote>\n
\nset BACKUP_DIR=D:\\EXPORTDIR\\data\\
\nset BACKUP_DAY=%date:~10,4%%date:~4,2%%date:~7,2%
\nset BACKUP_DAILY=D:\\EXPORTDIR\\daily\\
\nset ORACLE_SID=YOURDBSID<\/p>\n
\ndate \/T >> %BACKUP_DIR%log_SchemaName_exp.log<\/p>\n
\n“C:\\Program Files (x86)\\WinRAR\\winrar.exe” a -p”yourwinrarpassword_.MKY” %BACKUP_DIR%data_SchemaName_expdat_%BACKUP_DAY%.rar %BACKUP_DIR%data_SchemaName_expdat_%BACKUP_DAY%.dmp
\ndel %BACKUP_DIR%data_SchemaName_expdat_%BACKUP_DAY%.dmp
\nmove %BACKUP_DIR%log_SchemaName_exp.log %BACKUP_DIR%log_SchemaName_exp_%BACKUP_DAY%.log
\ncopy %BACKUP_DIR%data_SchemaName_expdat_%BACKUP_DAY%.rar %BACKUP_DAILY%\n<\/p><\/blockquote>\n
\n
\nLastly, if you want to delete old backups, you can create batch file and add windows schedule tasks.<\/p>\n
\nECHO.<\/p>\n
\nIF NOT “%OS%”==”Windows_NT” GOTO Syntax
\nSETLOCAL<\/p>\n
\nSET Error=0
\nSET cDays=-4
\nSET cDate=%date:~4,2%\/%date:~7,2%\/%date:~10,4%
\nSET sfold=D:\\BACKUPDIR\\data\\
\nSET dfold=D:\\BACKUPDIR\\temp\\<\/p>\n
\nCALL :ReadDateFormat<\/p>\n
\n(ECHO.%cDate%) | FINDSTR \/R \/B \/C:”[0-9]*\\%sDate%[0-9]*\\%sDate%[0-9]*” >NUL
\nIF ERRORLEVEL 1 (
\n ECHO Error: %cDate% is not a valid date
\n ECHO.
\n GOTO Syntax
\n)<\/p>\n
\n(ECHO.%cDays%) | FINDSTR \/R \/B \/C:”-*[0-9]*” >NUL
\nIF ERRORLEVEL 1 (
\n ECHO Error: %cDays% is not an integer
\n ECHO.
\n GOTO Syntax
\n)<\/p>\n
\nCALL :ParseDate %cDate%<\/p>\n
\nIF %Error% NEQ 0 GOTO Syntax<\/p>\n
\nCALL :JDate %GYear% %GMonth% %GDay%<\/p>\n
\nECHO Starting date : %cDate%<\/p>\n
\nIF “%cDays:~0,1%”==”-” (
\n SET \/A NewJDate = %JDate% – %cDays:~1%
\n ECHO Days subtracted : %cDays:~1%
\n) ELSE (
\n SET \/A NewJDate = %JDate% + %cDays%
\n ECHO Days added : %cDays%
\n)<\/p>\n
\nCALL :GDate %NewJDate%<\/p>\n
\nCALL :ReformatDate %GDate%<\/p>\n
\nECHO Resulting date : %LDate%<\/p>\n
\nCALL :DeleteOlder<\/p>\n
\nENDLOCAL & SET %~n0=%LDate%
\nGOTO:EOF<\/p>\n
\n::
\nSET \/A P = %1 + 68569
\nSET \/A Q = 4 * %P% \/ 146097
\nSET \/A R = %P% – ( 146097 * %Q% +3 ) \/ 4
\nSET \/A S = 4000 * ( %R% + 1 ) \/ 1461001
\nSET \/A T = %R% – 1461 * %S% \/ 4 + 31
\nSET \/A U = 80 * %T% \/ 2447
\nSET \/A V = %U% \/ 11
\nSET \/A GYear = 100 * ( %Q% – 49 ) + %S% + %V%
\nSET \/A GMonth = %U% + 2 – 12 * %V%
\nSET \/A GDay = %T% – 2447 * %U% \/ 80
\n:: Clean up the mess
\nFOR %%A IN (P Q R S T U V) DO SET %%A=
\n:: Add leading zeroes
\nIF 1%GMonth% LSS 20 SET GMonth=0%GMonth%
\nIF 1%GDay% LSS 20 SET GDay=0%GDay%
\n:: Return value
\nSET GDate=%GYear% %GMonth% %GDay%
\nGOTO:EOF<\/p>\n
\n:: Convert date to Julian
\n:: Arguments : YYYY MM DD
\n:: Returns : Julian date
\n::
\n:: First strip leading zeroes
\nSET MM=%2
\nSET DD=%3
\nIF %MM:~0,1% EQU 0 SET MM=%MM:~1%
\nIF %DD:~0,1% EQU 0 SET DD=%DD:~1%
\n::
\n:: Algorithm based on Fliegel-Van Flandern
\n:: algorithm from the Astronomical Almanac,
\n:: provided by Doctor Fenton on the Math Forum
\n:: (http:\/\/mathforum.org\/library\/drmath\/view\/51907.html),
\n:: and converted to batch code by Ron Bakowski.
\nSET \/A Month1 = ( %MM% – 14 ) \/ 12
\nSET \/A Year1 = %1 + 4800
\nSET \/A JDate = 1461 * ( %Year1% + %Month1% ) \/ 4 + 367 * ( %MM% – 2 -12 * %Month1% ) \/ 12 – ( 3 * ( ( %Year1% + %Month1% + 100 ) \/ 100 ) ) \/ 4 + %DD% – 32075
\nFOR %%A IN (Month1 Year1) DO SET %%A=
\nGOTO:EOF <\/p>\n
\n:: Parse (Gregorian) date depending on registry’s date format settings
\n:: Argument : Gregorian date in local date format,
\n:: Requires : sDate (local date separator), iDate (local date format number)
\n:: Returns : GYear (4-digit year), GMonth (2-digit month), GDay (2-digit day)
\n::
\nIF %iDate%==0 FOR \/F “TOKENS=1-3 DELIMS=%sDate%” %%A IN (‘ECHO.%1’) DO (
\n SET GYear=%%C
\n SET GMonth=%%A
\n SET GDay=%%B
\n)
\nIF %iDate%==1 FOR \/F “TOKENS=1-3 DELIMS=%sDate%” %%A IN (‘ECHO.%1’) DO (
\n SET GYear=%%C
\n SET GMonth=%%B
\n SET GDay=%%A
\n)
\nIF %iDate%==2 FOR \/F “TOKENS=1-3 DELIMS=%sDate%” %%A IN (‘ECHO.%1’) DO (
\n SET GYear=%%A
\n SET GMonth=%%B
\n SET GDay=%%C
\n)
\nIF %GDay% GTR 31 SET Error=1
\nIF %GMonth% GTR 12 SET Error=1
\nGOTO:EOF<\/p>\n
\n:: Read the Date format from the registry.
\n:: Arguments : none
\n:: Returns : sDate (separator), iDate (date format number)
\n::
\n:: First, export registry settings to a temporary file:
\nSTART \/W REGEDIT \/E “%TEMP%.\\_TEMP.REG” “HKEY_CURRENT_USER\\Control Panel\\International”
\n:: Now, read the exported data:
\nFOR \/F “tokens=1* delims==” %%A IN (‘TYPE “%TEMP%.\\_TEMP.REG” ^| FIND \/I “iDate”‘) DO SET iDate=%%B
\nFOR \/F “tokens=1* delims==” %%A IN (‘TYPE “%TEMP%.\\_TEMP.REG” ^| FIND \/I “sDate”‘) DO SET sDate=%%B
\n:: Remove the temporary file:
\nDEL “%TEMP%.\\_TEMP.REG”
\n:: Remove quotes from the data read:
\n:: SET iDate=%iDate:”=%
\nFOR %%A IN (%iDate%) DO SET iDate=%%~A
\n:: SET sDate=%sDate:”=%
\nFOR %%A IN (%sDate%) DO SET sDate=%%~A
\nGOTO:EOF<\/p>\n
\n:: Reformat the date back to the local format
\n:: Arguments : YYYY MM DD
\n:: Returns : LDate (Gregorian date in local format)
\n::
\nIF %iDate%==0 SET LDate=%2%sDate%%3%sDate%%1
\nIF %iDate%==1 SET LDate=%3%sDate%%2%sDate%%1
\nIF %iDate%==2 SET LDate=%1%sDate%%2%sDate%%3
\nGOTO:EOF<\/p>\n
\n:: Copy new files to another directory
\n:: Arguments : YYYY MM DD
\n:: Returns : int
\n::
\nXCOPY %sfold%* %dfold%* \/d:%GMonth%-%GDay%-%GYear%
\nDEL %sfold%* \/Q
\nMOVE %dfold%* %sfold%
\nGOTO:EOF<\/p>\n
\nECHO DateAdd.bat, Version 1.10 for Windows NT 4 \/ 2000 \/ XP \/ Server 2003 \/ Vista
\nECHO Add (or subtract) the specified number of days to (or from) the specified date
\nECHO.
\nECHO Usage: DATEADD [ date ] days
\nECHO.
\nECHO Where: “date” is a “normal” Gregorian date in the local computer’s format
\nECHO (default value if no date is specified: today’s date)
\nECHO “days” is the number of days to add or subtract
\nECHO.
\nIF “%OS%”==”Windows_NT” FOR %%A IN (%Date%) DO SET Today=%%A
\nIF “%OS%”==”Windows_NT” ECHO E.g. DATEADD %Today% 1 will return tomorrow’s date (as will DATEADD 1)
\nIF “%OS%”==”Windows_NT” ECHO DATEADD %Today% -1 will return yesterday’s date (as will DATEADD -1)
\nIF “%OS%”==”Windows_NT” ENDLOCAL
\nIF NOT “%OS%”==”Windows_NT” ECHO E.g. DATEADD 01\/25\/2007 1 should return 01\/26\/2007
\nIF NOT “%OS%”==”Windows_NT” ECHO DATEADD 01\/25\/2007 -1 should return 01\/24\/2007
\nECHO.
\nECHO Delete Completed.
\nECHO.<\/p><\/blockquote>\n