Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Backup for Large Databases (800,000,000 rows) in one table

Oracle Backup for Large Databases (800,000,000 rows) in one table

From: Marwan Samara <samara.marwan_at_epa.gov>
Date: 21 May 2001 10:50:13 -0700
Message-ID: <12992fb9.0105210950.309a4a66@posting.google.com> 






Hi All,


I'm new to the list and to ORACLE DBA (came from Mainframe).  I've been 
asked/tasked to come up with a procedure to backup and restore one of our 
databases in the fastest waypossible !.


The largest table is partitioned by year, and contains 
about 800,000,000 rows with average length of 100 bytes.
Now, a hot backup is taking about 7 hours, and never tried the restore. 
Please, any Ideas, or references are welcome.



Thanks,



Marwan Samara.
Received on Mon May 21 2001 - 12:50:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US