Home » Infrastructure » Linux » Taking Backup After 15 minutes
Taking Backup After 15 minutes [message #202787] Sun, 12 November 2006 12:01 Go to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi Mahesh,

I come across a problem which is that I have to take the backup of the database afer every 15 minutes.

I have script which I run twice daily to take the backup but now I want to write some Shell so that it would be self executing.

Bye
Ashu

[Updated on: Sun, 12 November 2006 12:02]

Report message to a moderator

Re: Taking Backup After 15 minutes [message #202886 is a reply to message #202787] Mon, 13 November 2006 03:11 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Backup every 15min !

Anyway, have you looked at using crontab ?
Re: Taking Backup After 15 minutes [message #202915 is a reply to message #202886] Mon, 13 November 2006 05:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Agree with tahpush. Backing up every 15 minutes is kind of, senseless and look into crontab.
What is the requirement?
If this is a high transaction environment, backup the archived logs several times a day.


PS:
>>Hi Mahesh,
When you post in a public forum, please avoid this. Address it for all.
Re: Taking Backup After 15 minutes [message #202960 is a reply to message #202915] Mon, 13 November 2006 07:35 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi Everybody,

Yes it is high transaction environment so how to take the backup of archived logs several times a day?

I am Application Developer so I dont have any idea of DBA related jobs.

Bye
Ashu
Re: Taking Backup After 15 minutes [message #202966 is a reply to message #202960] Mon, 13 November 2006 07:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
start here
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm
Re: Taking Backup After 15 minutes [message #202986 is a reply to message #202787] Mon, 13 November 2006 08:16 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Yupp alot of reading to do

Just for the record :=)
One can backup archived log files using RMAN or any operating system backup utility. Remember to delete files after backing them up to prevent the archive log directory from filling up. If the archive log directory becomes full, your database will hang...which is a pain
Previous Topic: How to delete files by "created date"
Next Topic: How to start sqlplus in Linux
Goto Forum:
  


Current Time: Fri Mar 29 01:19:03 CDT 2024