Home » RDBMS Server » Backup & Recovery » RMAN Backup Strategy Recommendations (10.2.0.1.0)
RMAN Backup Strategy Recommendations [message #307608] Wed, 19 March 2008 04:55 Go to next message
M.Stone
Messages: 2
Registered: March 2008
Junior Member
Hi.

I am looking for some help.
We have a requirement to backup a 24x7 datbase, it is currently around 400 GB and growing rapidly.

Running Oracle 10.2.0.1.0
O/S Windows 2003 R2

My initial plan was:
1. Schedule RMAN through EM - Backup Level 0 on Sunday (to disk)
2. Schedule EM - Backup Level 1 Mon-Sat (to disk)
3. All disks backed up to tape every night Netbackup.

This worked wel until day five when I ran out of disk space. Also the tape backups are taking a long time so this is not effective.

Would the following strategy be successful for recovery?
1. Full backup Level 0 (Sunday)
2. Archive logs backed up Monday - Saturday
3. Files to tape every night

If this strategy is in place would it still be a requirement to do a datafile copy/backup or is this just an extra backup step?

Thanks
Mark

Report message to a moderator

Re: RMAN Backup Strategy Recommendations [message #307888 is a reply to message #307608] Thu, 20 March 2008 04:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
For redundant (in case of any failure) you can take other backup.
Simply ,full backup+ archived log backup is ok to recover database.

Report message to a moderator

Re: RMAN Backup Strategy Recommendations [message #307890 is a reply to message #307888] Thu, 20 March 2008 04:46 Go to previous messageGo to next message
M.Stone
Messages: 2
Registered: March 2008
Junior Member
Ok thanks for the response.

I have since started looking into block change tracking to make the incremental's quicker and smaller.

Thanks

Report message to a moderator

Re: RMAN Backup Strategy Recommendations [message #308194 is a reply to message #307608] Fri, 21 March 2008 18:51 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have since started looking into block change tracking to make the incremental's quicker and smaller.
While making restores longer & more complex.

TRADE-OFFS!

Report message to a moderator

Previous Topic: How does RMAN recovery with its retention policy?
Next Topic: cloning the database using netapps backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 12:54:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.