Windows下设置oracle数据库定时备份

            <span>  1</span> echo backup oracle database......
<span>  2</span> echo %~dp0
<span>  3</span> set file_dir=%~dp0
<span>  4</span><span>  5</span> echo backup time......
<span>  6</span> set "<span>year=%date:~0,4%</span>"
<span>  7</span> set "<span>month=%date:~5,2%</span>"
<span>  8</span> set "<span>day=%date:~8,2%</span>"
<span>  9</span> set "<span>hour_ten=%time:~0,1%</span>"
<span> 10</span> set "<span>hour_one=%time:~1,1%</span>"
<span> 11</span> set "<span>minute=%time:~3,2%</span>"
<span> 12</span> set "<span>second=%time:~6,2%</span>"
<span> 13</span><span> 14</span> set mydate
<span> 15</span><span> 16</span><span>if</span> "<span>%hour_ten%</span>" == "<span />" (
<span> 17</span>     mydate=%year%%month%%day%0%hour_one%%minute%%second%
<span> 18</span> ) <span>else</span> (
<span> 19</span>     mydate=%year%%month%%day%%hour_ten%%hour_one%%minute%%second%
<span> 20</span> )
<span> 21</span><span> 22</span> exp USER/PWD@SID file=file_diryr_database_backup_%mydate%.dmp owner=OWNER
<span> 23</span>