Urgent [message #124649] |
Mon, 20 June 2005 14:25 |
rudolfguth
Messages: 2 Registered: June 2005
|
Junior Member |
|
|
Hi,
I need to know how to set a time and date to start a backup in Oracle 9 and date and time to finish it!!!
Please it´s very urgent!! If anyone know something about it answer me!!!
Thank you
|
|
|
Re: Urgent [message #124725 is a reply to message #124649] |
Tue, 21 June 2005 02:48 |
girish.rohini
Messages: 744 Registered: April 2005 Location: Delhi (India)
|
Senior Member |
|
|
First thing... setting only the starting time of backup is possible. Theres no ending time setting... anyways u can't stop a backup process midway because the system time equaled the ending time that u have specified for the process. Its not recommended.
Now for backup start time:
Backup can be scheduled using RMAN as well (the most recommended method).
If not using RMAN then:
If u r using Unix: use CRON.
If on windows: use windows scheduler for the process.
Both these do require creation of script file (using shell) that will get executed everytime system time equals the specified time.
This script is going to contain the backup commands.
Also u need to decide what type of backup u want:
Is it cold backup or hot backup.
Accordingly u may need to shutdown/startup ur database (in case of cold backup). This too has to be performed using the script only.
|
|
|