| How to Automate an logical bkp [message #161523] |
Sun, 05 March 2006 22:59  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Hi all,
Daily i am taking a logical full database bkp manually.
Can any one tell me how to automate this job on windows.
I've successfully automated the bkp in the Windows control panel -->Scheduled jobs . but my requrement is that
daily automatically on D:\backups dir it should create a new dir
at OS level with the dir name as dd/mm/yyyy format and the export dump file and logfile must be exported into that dir.
Can anyone tell me how to do it.
here is my takebkp.bat
exp parfile=x.par
and here is my parfile which look like this:
USERID=system/pwd@TEST
FILE=FULL_DB.DMP
LOG=FULL_DB.LOG
CONSISTENT=Y
FULL=Y
Thanks in advance.
|
|
|
|
| Re: How to Automate an logical bkp [message #161536 is a reply to message #161523] |
Sun, 05 March 2006 23:49  |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
FYI. An example:
takebkp.bat
-------------------------------------------------
set NowDate=%DATE:~-10%
set Month=%NowDate:~0,2%
set Day=%NowDate:~3,2%
set expfile=exp_%Month%%Day%
set logfile=exp_%Month%%Day%
set expfile=%expfile%_full.dat
set logfile=%logfile%_full.log
exp FILE=%expfile% LOG=%explog% CONSISTENT=Y FULL=Y
Alex zeng | Skype me: hans9zeng
[Updated on: Mon, 06 March 2006 00:01] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
