Home » RDBMS Server » Backup & Recovery » Need Advice on Backup strategy
Need Advice on Backup strategy [message #267276] Wed, 12 September 2007 23:16 Go to next message
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,

Re: Need Advice on Backup strategy [message #267278 is a reply to message #267276] Wed, 12 September 2007 23:18 Go to previous messageGo to next message
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.
Re: Need Advice on Backup strategy [message #267283 is a reply to message #267276] Wed, 12 September 2007 23:36 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Have documented & functioning recovery procedure(s).
Re: Need Advice on Backup strategy [message #267285 is a reply to message #267278] Wed, 12 September 2007 23:50 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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?
Re: Need Advice on Backup strategy [message #267292 is a reply to message #267276] Thu, 13 September 2007 00:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Using EM use Oracle Suggested Backup Strategy.
Re: Need Advice on Backup strategy [message #267295 is a reply to message #267288] Thu, 13 September 2007 00:07 Go to previous messageGo to next message
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,
Re: Need Advice on Backup strategy [message #267299 is a reply to message #267276] Thu, 13 September 2007 00:14 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Need Advice on Backup strategy [message #267312 is a reply to message #267299] Thu, 13 September 2007 00:33 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member

ya sure.
Thanks Anacedent,
I will work it out.
Re: Need Advice on Backup strategy [message #267313 is a reply to message #267276] Thu, 13 September 2007 00:40 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Simply put, backup is easy & RECOVERY is what is IMPORTANT!
Previous Topic: ORA-01180: can not create SYSTEM datafile
Next Topic: oracle 10g (RMAN)
Goto Forum:
  


Current Time: Sat Dec 10 14:23:02 CST 2016

Total time taken to generate the page: 0.08989 seconds