|
Home > Archive > Data Storage > December 2006 > Oracle redo logs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| jondelac@gmail.com 2006-12-20, 1:19 am |
| Hi.. I recently ran into a company that archives (daily) their Oracle
redo logs... each log is around 100MB... they have heavy transactions
and run 3 rotational logs. So thats about 300MB per day.
My question is, do they need to do this? Do they need to archive onto
secondary every day's redo log files?
I am not a DBA, so I cannot advise them on this topic, but trying to
get a feel for standard practices here
Jon.
| |
| robertwessel2@yahoo.com 2006-12-20, 1:19 am |
|
jondelac@gmail.com wrote:
> Hi.. I recently ran into a company that archives (daily) their Oracle
> redo logs... each log is around 100MB... they have heavy transactions
> and run 3 rotational logs. So thats about 300MB per day.
>
> My question is, do they need to do this? Do they need to archive onto
> secondary every day's redo log files?
>
> I am not a DBA, so I cannot advise them on this topic, but trying to
> get a feel for standard practices here
Think of this as the daily incremental backup of the database. If
there's a bad crash, you go back to the last "full" backup of the
database, and then reapply all the logs.
| |
| Curtis Preston 2006-12-20, 1:19 am |
| Only if you want to ever recover anything. ;)
You should also be backing up the database every day as well.
---
W. Curtis Preston
Author of O'Reilly's Backup & Recovery and Using SANs and NAS
VP Data Protection
GlassHouse Technologies
-----Original Message-----
From: comp.arch.storage-bounces@backupcentral.com
[mailto:comp.arch.storage-bounces@backupcentral.com] On Behalf Of
jondelac@gmail.com
Sent: Tuesday, December 19, 2006 5:55 PM
To: comp.arch.storage@backupcentral.com
Subject: [C.A.S.] Oracle redo logs
Hi.. I recently ran into a company that archives (daily) their Oracle
redo logs... each log is around 100MB... they have heavy transactions
and run 3 rotational logs. So thats about 300MB per day.
My question is, do they need to do this? Do they need to archive onto
secondary every day's redo log files?
I am not a DBA, so I cannot advise them on this topic, but trying to
get a feel for standard practices here
Jon.
________________________________________
_______
Subscribe or Unsubscribe to this mailing list here:
http://backupcentral.com/mailman/li...ge_backupcentra
l.com
| |
| jondelac@gmail.com 2006-12-20, 1:12 pm |
|
Curtis Preston wrote:
> Only if you want to ever recover anything. ;)
>
> You should also be backing up the database every day as well.
>
> ---
> W. Curtis Preston
> Author of O'Reilly's Backup & Recovery and Using SANs and NAS
> VP Data Protection
> GlassHouse Technologies
>
> -----Original Message-----
> From: comp.arch.storage-bounces@backupcentral.com
> [mailto:comp.arch.storage-bounces@backupcentral.com] On Behalf Of
> jondelac@gmail.com
> Sent: Tuesday, December 19, 2006 5:55 PM
> To: comp.arch.storage@backupcentral.com
> Subject: [C.A.S.] Oracle redo logs
>
> Hi.. I recently ran into a company that archives (daily) their Oracle
> redo logs... each log is around 100MB... they have heavy transactions
> and run 3 rotational logs. So thats about 300MB per day.
>
> My question is, do they need to do this? Do they need to archive onto
> secondary every day's redo log files?
>
> I am not a DBA, so I cannot advise them on this topic, but trying to
> get a feel for standard practices here
>
> Jon.
>
> ________________________________________
_______
> Subscribe or Unsubscribe to this mailing list here:
> http://backupcentral.com/mailman/li...ge_backupcentra
> l.com
This is adding 300MB daily to their storage requirements... isnt there
any way to curb this?
Jon
| |
| Bill Todd 2006-12-20, 1:12 pm |
| jondelac@gmail.com wrote:
....
> This is adding 300MB daily to their storage requirements... isnt there
> any way to curb this?
Probably no way that wouldn't cost far more than they're paying for the
required storage (well under $1 per day if it's mirrored, unless they're
using high-end enterprise-level storage for backup).
- bill
| |
| robertwessel2@yahoo.com 2006-12-20, 7:13 pm |
|
jondelac@gmail.com wrote:
> This is adding 300MB daily to their storage requirements... isnt there
> any way to curb this?
While this needs to be carefully coordinated with the DB admins, the
usual (easy) approach is to have a scheduled hard shutdown and backup
of the database at some regular interval (weekly, monthly), and then
rotate through several generations of complete database backup plus an
interval's worth of logs. Then you eventually throw away old logs.
The number of intervals has to do with your recovery requirements, and,
perhaps, with data retention requirements.
This, of course, does add a regular outage to your application.
More complicated is doing a snapshot backup of the live database.
Oracle certainly can do that, although I think you may need some
optional components.
Although I agree with Bill, the volumes you're talking about are
probably cheaper to just ignore.
| |
| Maxim S. Shatskih 2006-12-21, 7:15 am |
| > usual (easy) approach is to have a scheduled hard shutdown and backup
> of the database at some regular interval (weekly, monthly),
Why shutdown? MSSQLServer and Oracle can do hot database backups.
> More complicated is doing a snapshot backup of the live database.
> Oracle certainly can do that
All database backups in MSSQLServer are such, since version 4.2 of early 90ies.
I think Oracle can do this too.
--
Maxim Shatskih, Windows DDK MVP
StorageCraft Corporation
maxim@storagecraft.com
http://www.storagecraft.com
|
|
|
|
|