| How to Take Backup on every 30 Min [message #480519] |
Mon, 25 October 2010 08:16  |
|
|
Hi,
I want to take automated backup after every 30min. How can i do that? I will be glad if i could atleast given a hints to work with. I know how to write a batch file for taking manual backup but wanted to know how to do it automatically.
Thanks and Regards
Sarker Mahatab Masud
|
|
|
|
| Re: How to Take Backup on every 30 Min [message #480521 is a reply to message #480519] |
Mon, 25 October 2010 08:33  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>. I know how to write a batch file for taking manual backup but wanted to know how to do it automatically
Schedule it?
Actual scheduling methods depends on your OS.
>>I want to take automated backup after every 30min.
Never seen a database that needs such a requirement.
Probably you just need to backup the archived logs?
What is the size of database.
What is the volume of transactions?
[Updated on: Mon, 25 October 2010 08:35] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: How to Take Backup on every 30 Min [message #480554 is a reply to message #480536] |
Mon, 25 October 2010 12:37 |
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
If you don't have the necessary Enterprise Edition licences, Data Guard is not an option. However, using fast incremental backups (which you can schedule every ten minutes if you want) and the RECOVER COPY OF DATABASE command, you can achieve a good level of high availability without Data Guard.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
