Incremental backups

[iris]

Hi, How to perform incremental backups using datapump in 10g?

[PAVB]

You don't.
Since you cannot recover a database from a dump file created either by expdp or exp those are not appropriate backup tools.
Try rman.

[iris]

You mean using datapump we cannot perform incremental backups, I want to setup incremental backup for recovering tables, not whole database.

[PAVB]

You mean using datapump we cannot perform incremental backups, I want to setup incremental backup for recovering tables, not whole database.

Datapump has not support for incremental.

On the other hand I remember reading a paper where somebody simulated such a thing.

Here is what I remember. No delete operation was allowed on target table, dba added a timestamp column to be updated on insert/update operations.

After that, dba used expdp WHERE clause to filter what to dump.

Please do not construct previous comment as my advise to follow such path.

[iris]

Then what is the main advantage of datapumps? I mean we would have written scripts for incremental/cummulative/complete backup scripts and schedule it to run with cronjob. Now using datapump how to do this task?


thanks,

[BeefStu]

If you want to recover a table at a time, thanwhy not put each table in its own tablespace and you can use RMAN to recover a particular tablespace.

Having said that, recoving a singlee table is really not good practice.

For example:

create table department(
dept_id number,
location varchar2(20),
CONSTRAINT pk_department PRIMARY KEY (dept_id));


create table employee(
emp_id number,
dept_id number,
salary number,
CONSTRAINT pk_employee PRIMARY KEY (emp_id),
CONSTRAINT fk_empl_dept FOREIGN KEY (dept_id) REFERENCES department (dept_id));

If you recover deptartment table from a backup you may have a record in your employee table that references a deptartment record that does not exist.

RMAN is a very powerful tool, especially used with a catalog. You may want to read up on it.

Good luck

[LKBrwn_DBA]

Hi, How to perform incremental backups using datapump in 10g?

Use the Flash Recovery functionality for those tables you wish to recover.

[davey23uk]

Then what is the main advantage of datapumps? I mean we would have written scripts for incremental/cummulative/complete backup scripts and schedule it to run with cronjob. Now using datapump how to do this task?


thanks,

datapump is not a backup tool, to do backups - use a backup tool