| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: VLDB backup policy
Thanks a lot to all who replied !
Tom , thanks , i forgot to mention , the DB is expected to get recovered in
something like 1-3 hours.
Another correction , the DB size will be around 1TB for the beginning and is
expected to grow to 10TB within a couple of years.
HAPPY NEW YEAR ALL ! DBAndrey
-----Original Message-----
Sent: Wednesday, January 02, 2002 6:37 PM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'andreyb_at_elrontelesoft.com'
Andrey,
I think that you are looking at this problem from the wrong end. Rather than come up with backup scenarious first and reporting back to management, I think you need to get managment to declare to you their "Mean Time to Recovery". By this I mean that they need to tell you how long they can survive without a database before it begins to affect their operations.
Depending on their answer, it drives your research in certain directions.
If they say "10 minutes", you have no choice but to have a hot-standby database running.
If they say 1 hour, you could use EMC/mirror disk options (like Rachel just mentioned).
If they say 24 hours, then RMan backup/restore from tape (probably the cheapest solution) would work for you.
Kimberly's suggestions are very good if you are following the Rman scenario.
Hope this helps
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, January 02, 2002 10:35 AM
To: Multiple recipients of list ORACLE-L
You could split off a mirror and backup the mirror however, I have never
done that so I am not going
to get into it. I know there are others in the list who have done it for
their backup strategy.
Keep in mind that if you are running in archive log mode you need not backup
every data file at the
same time. This would be your cheap end solution. Make sure you have
enough disk to deal with
your archive logs (depends on how much you want to keep on disk). I would
place objects in tablespaces
based on usage rather then size or functionality. In other words, if you
have a bunch of tables that
have very little data changed or data that does get changed does so
infrequently then place them in
the same tablespace. If you have tables that have change constantly then
keep them together. Granted
you may end up with more then one tablespace per change type but don't mix.
Then schedule backups
of those tablespaces more frequently then others. Try and get the full
backup done by the end of
the week for all tablespaces. Keep in mind that the control file and other
stuff need to be backed up
as well.
Your recovery is going to be a little more complicated this way and time to
recover is going to be
longer but if you get the frequently changed tablespaces more often then it
should not be too bad.
-----Original Message-----
Sent: Wednesday, January 02, 2002 6:50 AM
To: Multiple recipients of list ORACLE-L
Dear list !
I'm reposting this , since got no replies yet.
I need to design a backup policy for a VLDB sized some 10TB, running
as close to 24X7 as possible.
I need 2 versions of the policy:
One is the "best case" , i.e. money does not matter, the company can aquire
any software / hardware , the only goal is to have a solid backup and
ability to backup and recover as fast as possible.
The second is the opposite case - how to achieve a good backup spending as
little money as possible, possibly tolerating a little more downtime in case
of a crash.
I just have never happened to work with 10 Terrabytes size of DB, in particular ,i believe that my proven backup strategies that work well with 100GB DB might need some amending when it comes to 10 TB size.
Another constraint is that i'm limited to Oracle 8.1.7 , and can not upgrade to 9i.
I need to decide which hardware/software needs to be purchased/evaluated to
implement solid DRP and HA.
People say : EMC , Veritas , Legato etc...
I'm just lost among these (and many others) buzzwords and need a "Second
opinion" from gurus, like you.
Please share your experience and thoughts.
Thanks a lot in advance !
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
INET: andreyb_at_elrontelesoft.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: ksmith2_at_myfirstlink.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 02 2002 - 11:56:24 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |