Home » RDBMS Server » Backup & Recovery » How to Take Backup on every 30 Min (Oracle 10g, Version 10.2.0)
How to Take Backup on every 30 Min [message #480519] Mon, 25 October 2010 08:16 Go to next message
mahatab
Messages: 92
Registered: January 2008
Location: Dhaka
Member

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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10625
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 #480525 is a reply to message #480521] Mon, 25 October 2010 09:01 Go to previous messageGo to next message
mahatab
Messages: 92
Registered: January 2008
Location: Dhaka
Member

Thanks for the reply. The size of my db is 543mb and everyday there are near about 1mb of data are loaded. So could you please give me some hints to work on that matter.
Re: How to Take Backup on every 30 Min [message #480527 is a reply to message #480525] Mon, 25 October 2010 09:04 Go to previous messageGo to next message
BlackSwan
Messages: 22781
Registered: January 2009
Senior Member
Data Guard
Re: How to Take Backup on every 30 Min [message #480528 is a reply to message #480525] Mon, 25 October 2010 09:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10625
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If your database is highly critical and you want the most latest data immediately available,
DataGuard is the solution.
You maintain a copy of database in another node with dataguard.

Else, you just need a hot backup with RMAN and schedule it.
Re: How to Take Backup on every 30 Min [message #480536 is a reply to message #480528] Mon, 25 October 2010 09:40 Go to previous messageGo to next message
mahatab
Messages: 92
Registered: January 2008
Location: Dhaka
Member

Thanks (Mahesh and BlackSwan) for the reply. I will start working with DataGuard.
Re: How to Take Backup on every 30 Min [message #480554 is a reply to message #480536] Mon, 25 October 2010 12:37 Go to previous messageGo to next message
John Watson
Messages: 4553
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.
Re: How to Take Backup on every 30 Min [message #480556 is a reply to message #480554] Mon, 25 October 2010 12:52 Go to previous messageGo to next message
Michel Cadot
Messages: 59085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If you don't have the necessary Enterprise Edition licences, Data Guard is not an option.

Yes but you can use the original standby database with own made log shipping (many scripts available on the web).

Regards
Michel
Re: How to Take Backup on every 30 Min [message #480802 is a reply to message #480556] Wed, 27 October 2010 05:33 Go to previous message
mahatab
Messages: 92
Registered: January 2008
Location: Dhaka
Member

Thank you once again i am working on it and let you know my outcomes ASAP.
Previous Topic: How can get Archived log size in advance
Next Topic: dB can't produce archived log files
Goto Forum:
  


Current Time: Tue Sep 16 10:57:02 CDT 2014

Total time taken to generate the page: 0.09803 seconds