| Incremental EXPORT [message #374625] |
Thu, 21 June 2001 15:32  |
MK
Messages: 31
Registered: June 2001
|
Member |
|
|
We had done a full database import on June 9th. Now we need to reflect the incremental changes to the database
since 9th of June.
This is a fairly large database.
Can anyone tell me how to go about doing this and what
precautions we need to take.
|
|
|
|
| Re: Incremental EXPORT [message #374637 is a reply to message #374625] |
Fri, 22 June 2001 07:59  |
cl
Messages: 10
Registered: April 2001
|
Junior Member |
|
|
First of all, how do you do the full database export? If you done your full database export without including the inctype=complete option, now when you do an incremental export it will do a full export, because a complete export establishes a base for incremental and cumulative. When inctype is set to complete, it is equivalent to a full database export, except that it updates the tables(sys.inexp, sys.incfil, and sys.incvid) that track incremental and cumulative exports. If you haven't already done a full database export with the inctype option set to complete, then do that first before you do the incremental export when you have new changes to DB again, then it will only export those tables or system files that contain changes instead of the everything).
For example: Full database with inctype option.
(exporting data to files in a directory--because of 2G limitation with filesize on some systems, you can perform a full DB export to several files)
exp userid/password full=y inctype=complete direct=y file=/your_directory_path/fodb
_full_export1.dmp,/your_directory_path/fodb_full_export2.dmp filesize=2047M
log=/your_directory_path/fodb_full_export.log
OR
(exporting directly into the tape)
exp login/password file=/dev/rmt/0m full=y direct=y inctype=complete log=/your_directory_path/fodb
_direct_exp.log volsize=3000M
INCREMENTAL EXPORT: (to directory on system)
exp login/password inctype=incremental full=y direct=y file=/your_directory_path/f
odb_increment_exp1.dmp,/your_directory_path/fodb_increment_exp2.dmp filesize
=2047M log=/your_directory_path/fodb_increment_exp.log
OR
(incremental export directly into the tape)
exp login/password file=/dev/rmt/0m full=y inctype=incremental volsize=3000M direct=y
log=/your_directory_path/fodb_increment_exp.log
NOTE: I am working on HP11 OS and Oracle8i, however it should work on other Unix systems and other Oracle products with minor modification when necessary.
FILESIZE/VOLSIZE:
2047M approximately equal to 2G
3000M approximately equal to 3G
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
