Re: Fast Backup?

There is an incremental export feature which exports only those tables that have not changed. However, and all the big tables of Applications will be touched with extreme regularity so this won't save you much.

BTW - all the data files in an Oracle database will be touched every time the system does a checkpoint, and I would expect all the files of an Oracle database system to stay the same size almost all the time if it were being properly managed.

The only option to avoid unnecessary volume of backup is RMAN which is Oracle's own product which examines the SCN on each block in the database to determine if the block has been changed since the last backup.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

andres wrote in message <7tc0ir$1s1_at_dfw-ixnews10.ix.netcom.com>...
>Hi all:
>
>Is there a table in Oracle where I could query what tables where touched
>(its content altered in any way) since the last shutdown.
>I'm looking for a faster way to backup the datafiles that where altered
>(Isn't it what they call differential backup) and not do the backup of the
>entire database.
>My company has Oracle 7.3.4/Applications 10.7 and I've observed that 90
>percent of the files do not change size in a whole week.
>Regards, Andres
>
>
Received on Tue Oct 05 1999 - 03:19:26 CDT