export with sysdate [message #640974] |
Fri, 07 August 2015 23:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c70e51380f6e8af6765f6e8fede51587?s=64&d=mm&r=g) |
m.abdulhaq
Messages: 254 Registered: April 2013 Location: Ajman
|
Senior Member |
|
|
i have to schedule a daily export of oracle database at a particular time , i was trying to run the below script as batch file , the export is done with date and time but the log file is missing ,also i would like to know if there is a builtin schedule to do this in oracle itself.
EXP RAKLIVE/ORION FILE=H:\DUMPSBACKUP\RAKLIVE\RAKLIVE%date:~7,2%%date:~4,2%%date:~10,4%_%time:~0,2%%time:~3,2%.DMP LOG=H:\DUMPSBACKUP\RAKLIVE\RAKLIVE%date:~7,2%%date:~4,2%%date:~10,4%_%time:~0,2%%time:~3,2%.LOG OWNER=RAKLIVE STATISTICS=NONE
|
|
|
Re: export with sysdate [message #640975 is a reply to message #640974] |
Sat, 08 August 2015 00:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1/ Execute it interactively and post the output
2/ Export using DataPump API: DBMS_DATAPUMP and one of the two Oracle schedulers; you can also use Windows scheduler and your usual command.
[Updated on: Sat, 08 August 2015 00:37] Report message to a moderator
|
|
|
Re: export with sysdate [message #640976 is a reply to message #640975] |
Sat, 08 August 2015 00:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c70e51380f6e8af6765f6e8fede51587?s=64&d=mm&r=g) |
m.abdulhaq
Messages: 254 Registered: April 2013 Location: Ajman
|
Senior Member |
|
|
thanks michael , i figuered it out it was matter of using single quotes in the file path .
regarding point number 2, datapump i will check the fine manual regarding schedulers you meant to say dbms_scheduler right.
EXP RAKLIVE/ORION FILE='H:\DUMPSBACKUP\RAKLIVE\RAKLIVE%date:~7,2%%date:~4,2%%date:~10,4%_%time:~0,2%%time:~3,2%.DMP' LOG='H:\DUMPSBACKUP\RAKLIVE\RAKLIVE%date:~7,2%%date:~4,2%%date:~10,4%_%time:~0,2%%time:~3,2%.LOG' OWNER=RAKLIVE STATISTICS=NONE
is there any method for point of recovery , i know this is a huge topic, but can you guide me like if the server crashes (like hardware) and we need to recover the database , is rman the right approach or is there any alternative like making standby database.
so that we need to reduce the downtime.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|