Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Choosing data file size for a multi TB database?
You beat me to it. We were in that position for many years and I was forced
into just doing tablespace restores. One at a time. God that was a pain.
Thanks,
Jay Miller
Sr. Oracle DBA
x68355
-----Original Message-----
From: Parker, Matthew [mailto:matthewp_at_amazon.com]
Sent: Tuesday, September 06, 2005 2:35 AM
To: zoran_martic_at_yahoo.com; BranimirP_at_cpas.com; oracle-l_at_freelists.org
Subject: RE: Choosing data file size for a multi TB database?
As to database backup verification we could talk for hours about backup scenarios and backup methodolgies, but in it's simplest terms, this comes down to a question I normally ask in interviews of DBA's. How do you test a backup of a database when you do not have sufficient space to hold a secondary copy of the database? I never accept trust the rust as an answer. The real answer of course is simple, you perform recovery of a part of the database and you walk through all the parts. It can be done, it simply takes time.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 08 2005 - 14:34:45 CDT
![]() |
![]() |