Nat
Just a plug for always testing your backups, regardless of whether you
are doing hot or cold. We do cold backups, and we test them from time to
time by restoring them on a test system so the developers have some data to
test against. Several times over the years we've found that a file was
On our larger database we do exports of some of the smaller users which also
have frequent changes.
I wish I had some of the larger tables also, it would have saved a big
headache last week getting one table restored (7 days to get the files
restored from tape, 1.5 hours to modify the control tr
Well I just happen to know of this great Oracle Press RMAN book due out in
October!
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author of several Oracle books you can find on Amazon.com!
The avalanche has begun, It is too late for the pebbles
No we do trust our hot backups. Our databases are mostly idle during early
ours of Sunday between 12 AM - 1 AM.
So we thought lets go for a cold backup on weekends.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 12:28 P
On Fri, 20 Sep 2002, Nat wrote:
> We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our
> database once a week for half an hour for cold bcv splits. So far it has
> worked very well.
Just curious, why do you do a cold backup weekly? Do you not trust
your hot backups?
--
Jer
Robert
I don't think a full export has a place since your largest tables are
probably too large to reimport in a reasonable amount of time. I like Jay's
suggestion though. But your original question wasn't about a full export,
you just said export. My answer is a definite "yes". Following Paret
An export with data will probably cause more headaches than it solves in
large DBs.
A logical export without data will also have limited use. It is quick to do
and small but I suggest may be invaluable for various tasks.
Mike Jenner
Database Administrator
-Original Message-
Sent: 20 Se
Our db size is around 350Gig. We have stopped full logical exports since
our database size has grown above 200 Gigs.
It is just not feasible for us to do the full exports anymore, time it takes
to export is too much.
We use EMC/EDM bcv splits to do a hot backup every night. We shutdown our
data
I do nightly exports of my large databases with ROWS=N. This way I can restore users,
grants, indexes, table definitions, etc.
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> [EMAIL PROTECTED] 09/20/02 10:13AM >>>
I'd like to pose a question to you all and get your respo
I'd like to pose a question to you all and get your response. If you are
running a database that is larger than 250GB, what place in your backup
strategy does a logical export have? Do you do logical exports at all, and
if so with what frequency? Do you feel that logical exports are an important
p
10 matches
Mail list logo