OraFAQ Forum: Backup & Recovery » Need Advice on Backup strategy

Home » RDBMS Server » Backup & Recovery » Need Advice on Backup strategy

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need Advice on Backup strategy [message #267276]

Wed, 12 September 2007 23:16

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Hi,

Database version:10.2.0.
IBM AIX version 5.
Database Size:60GB.
Daily Updation Approximately :2GB.

I need some advice on my backup strategy.

This is my backup startegy...
Monthly Once, Date: 1 Full backup (Incremental level o).
Daily Incremental level 2 backup from Date: 2 to 6.
Weekly Once Incremental leve 1 backup on Date:7.
Daily Incremental level 2 backup from Date:8 to 13.
Weekly Incremental level 1 backup on Date:14.
Daily Incremental level 2 backup from Date:15 to 21.
Weekly Incremental level 1 backup on Date:22.
Daily Incremental level 2 backup from Date:23 to 28.
Weekly Incremental level 1 backup on Date:29.

My system requirments are i have only 70GB disk to store the backups, i can store only the full backup in it.So what i am doing is, Am storing the full backup in my disk and am transfering the Incrmental level 1(weekly Once backup) to the Tape and deleting the Daily level 2 backups, after taking that weekly backup.

Is my strategy correct or should i do anything different plz give me some advice.

TIA,

Report message to a moderator

Re: Need Advice on Backup strategy [message #267278 is a reply to message #267276]

Wed, 12 September 2007 23:18

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Read the documentation. I have not seen incremental level 2 backup in version 10g. No existence.

Report message to a moderator

Re: Need Advice on Backup strategy [message #267283 is a reply to message #267276]

Wed, 12 September 2007 23:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Have documented & functioning recovery procedure(s).

Report message to a moderator

Re: Need Advice on Backup strategy [message #267285 is a reply to message #267278]

Wed, 12 September 2007 23:50

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Am sorry, am new to 10g.

Instead of doing level 2 backup daily shall i take differential level 1 backup daily and cumulative level 1 backup once in a week.

Is this possible? If i use this strategy should i maintain the differential level 1 backup or shall i delete it after taking that cumulative level 1 backup.

@ anacedent : am sorry i couldnt get u.

TIA,

[Updated on: Wed, 12 September 2007 23:52]

Report message to a moderator

Re: Need Advice on Backup strategy [message #267288 is a reply to message #267276]

Wed, 12 September 2007 23:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You should use what ever actually works for you.
If any of the "gurus" gives their blessing & then it FAILS for you, who will your boss & upper management hold responsible; the guru or YOU?

Report message to a moderator

Re: Need Advice on Backup strategy [message #267292 is a reply to message #267276]

Thu, 13 September 2007 00:04

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Using EM use Oracle Suggested Backup Strategy.

Report message to a moderator

Re: Need Advice on Backup strategy [message #267295 is a reply to message #267288]

Thu, 13 September 2007 00:07

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Thanks for ur reply.
ya sure i totaly agree with u.
But am a fresher. Just now completed 9i OCP.
So I need some advice and experience of gurus on my backup strategy.

TIA,

Report message to a moderator

Re: Need Advice on Backup strategy [message #267299 is a reply to message #267276]

Thu, 13 September 2007 00:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>So I need some advice and experience of gurus on my backup strategy.
NO,IMO you need to practice & document a functioning RECOVERY procedure!
A "backup strategy" will dig you a hole.
A workable recovery procedure will allow you to fill in the HOLE & get you back to level ground where you started.

A "backup strategy" that can NOT be fully recovered will get folks fired.

Report message to a moderator