Home » RDBMS Server » Backup & Recovery » About Incremental Backup/Restore
About Incremental Backup/Restore [message #72210] Sun, 13 April 2003 00:37 Go to next message
M. Khaled
Messages: 67
Registered: April 2002
Is it possible to take only the incremental portion of a database.Using export/import ,It takes the whole table if is incremented. In oracle 8i query option may be used for taking subset of a table.

My requirement is to take the whole database(Only the incremental portion)

Please help.........
Re: About Incremental Backup/Restore [message #72211 is a reply to message #72210] Mon, 14 April 2003 01:00 Go to previous message
Muhammad Waqas Shabir
Messages: 26
Registered: April 2003
Junior Member
Dear khalid!
Yes it is possible to take incremental (only new changes) backup.

Type this command on your command prompt:

For Incremental export:
exp username/password file=pathfilename.dmp inctype=incremental full=y grants=y compress=n log=pathfilename.log

Note:the username should be a user with export rights.

For Incremental import:
imp username/password file=pathfilename.dmp inctype=restore full=y ignore=y destroy=y grants=y log=pathfilename.log

NOTE:the username that you have mentioned in imp command must have import rights.

VIP TIP:you should import in ascending order otherwise you will be in a big trouble. i.e if you have taken two exports one on yesterday and one today THEN take the import of yesterday's export first and then of today's.

Previous Topic: Recover back space from datafiles
Next Topic: Rman - deleting old backup
Goto Forum:

Current Time: Fri Jun 02 06:21:36 CDT 2023