বুধবার, ১৮ মার্চ, ২০২০

EXP AND EXPDP

@echo off
REM
SET dirname="%date:~-7,2%-%date:~-10,2%-%date:~-4%"
mkdir \\192.168.1.99\Delowar-IT\EXP_BACKUP\%dirname%                     

set oracle_sid=ala
setlocal
for /f "tokens=1-4 delims=/ " %%a in ('date /t') do set DATE=%%c-%%b-%%a
for /f "tokens=1-3 delims=: " %%a in ('time /t') do (
set hours=%%a
set minutes=%%b
set ampm=%%c
)
if {%ampm%}=={AM} if {%hours%}=={12} set hours=00
if {%ampm%}=={PM} (
for /f "delims=0 tokens=*" %%a in ("%hours%") do set hours=%%a
set /a hours+= 12
)

E:\database2\product\11.2.0\dbhome_1\BIN\exp labserp/drockfantasi29@dba file=\\192.168.1.99\Delowar-IT\EXP_BACKUP\\%dirname%\lan_%date%_%hours%.%minutes%_%ampm%.dmp  log=\\192.168.1.99\Delowar-IT\EXP_BACKUP\\%dirname%\lan_%date%_%hours%.%minutes%_%ampm%.log statistics=none



@echo off
REM
SET dirname="%date:~-7,2%-%date:~-10,2%-%date:~-4%"
--mkdir \\192.168.1.99\Delowar-IT\EXP_BACKUP\%dirname%                     

set oracle_sid=ala
setlocal
for /f "tokens=1-4 delims=/ " %%a in ('date /t') do set DATE=%%c-%%b-%%a
for /f "tokens=1-3 delims=: " %%a in ('time /t') do (
set hours=%%a
set minutes=%%b
set ampm=%%c
)
if {%ampm%}=={AM} if {%hours%}=={12} set hours=00
if {%ampm%}=={PM} (
for /f "delims=0 tokens=*" %%a in ("%hours%") do set hours=%%a
set /a hours+= 12
)

E:\database2\product\11.2.0\dbhome_1\BIN\expdp labstest/labstest@bidba directory=expdp_dir dumpfile=expdp_%date%_%hours%.%minutes%_%ampm%.dmp logfile=expdp_%date%_%hours%.%minutes%_%ampm%.log network_link=source

কোন মন্তব্য নেই:

একটি মন্তব্য পোস্ট করুন