| 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:
Joe - Good point. I usually don't even consider offline RMAN backups. But
for a really large database, that might be useful.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of jtesta_at_dmc-it.com
Sent: Friday, June 04, 2004 11:54 AM
To: oracle-l_at_freelists.org
Subject:
Dennis, one small clarification, you can do incremental rman backups in noarchivelogmode but the difference being you can only restore to the last rman backup(you'd have ot restore to the last level 0 and then apply incrementals) and never be able to get to point of failure. Since a noarchivelogmode database has to be shutdown, you'd be at a clean spot for recovery(and rman is smart enough to not let you do a backup with a shutdown abort as the last thing since the db has to be in mount state anyways), last i checked, its been about 6 months since i played with rman.
joe
original message below
Hamid
If you are thinking that incremental export would just export the
> new
rows in a table. It doesn't. It just detects tables that have changed
since the last export and exports those tables.
As Joe points out, RMAN can do incremental backups, but you must
> have
Enterprise Edition and run in archivelogmode.
If you want just part of a table, you could do something better on
your
own. Since 8i export has a parameter QUERY. If you have a timestamp
column for when a table is inserted or updated, then you could do a
partial export of the table for just the new or changed rows. Again, I
have done exports with the QUERY parameter, but haven't designed an
incremental backup system based on that.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Jun 04 2004 - 13:03:15 CDT
 |
 |