i have to take incremental backup of 5 specific tables in a oracle database...i cannot use data pump api as it doesn't support incremental backup...in recovery manager(RMAN) the backup is taken of whole database but i want to have backup if data changes in these 5 specific tables , not all tables in which data changes
Asked
Active
Viewed 639 times
-1
-
what kind of failure do you want to repair with such a backup and why should it be incremental? – miracle173 Jan 05 '18 at 05:58
1 Answers
0
You can take incremental backups of databases, individual tablespaces or datafiles. So if you only want 5 tables, you could move those tables into their own tablespace and then take backups of just that tablespace.
You would want to be very sure that these tables are "self-contained" in the sense that if you wanted to restore that tablespace to a specific point in time, you would not introduce a logical corruption into the rest of the database.
Connor McDonald
- 10,418
- 1
- 11
- 16