Re: About incremental backup in Export.

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 25 Jul 2006 03:43:41 -0700
Message-ID: <1153781048.190155@bubbleator.drizzle.com>

joel garry wrote:
> DA Morgan wrote:

>> Raaj wrote:
>>> Hi,
>>>    Also, can we make an incremental backup through EXPORT as we do in
>>> RMAN(Oracle9i).
>>>
>>> Regards,
>>> Raaj
>> 1. Don't top post.
>> 2. An export is not a backup.

>
> An export is a logical backup. One needs a dependable physical backup
> for recovery. Both logical and physical backups have their uses. In
> normal Oracle usage, when a document says "backup the database" it
> means a physical backup. Only physical backups can be used to recover
> transactions, which is the normal end use for a backup. Please read
> the backup documentation, starting with the basics.
>
> (This isn't meant as a slam on Daniel, just a clarification for the OP.
> I presume what Daniel really meant was "don't rely solely on exports
> to backup your data," which is explicit in the docs
> http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro001.htm#sthref13
> )
>
> jg
> --
> @home.com is bogus.
> I'm an enemy?
> http://www.signonsandiego.com/uniontrib/20060723/news_1n23vista.html

You are correct Joel. By the definition that an export is a backup one could consider an external table a backup too.

My point was that an export can not be used to recover from a failure.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jul 25 2006 - 05:43:41 CDT