| Importing Dump files Created using Incremental Export [message #62215] |
Mon, 05 July 2004 23:23  |
Pratap Zope
Messages: 23
Registered: July 2004
|
Junior Member |
|
|
Hi,
Will anybody please guide me for the steps of importing (and thus recovering database) dump files created using incemenatal export.
(first, shall i need to create same database as before crash? whether template created by dbca will help me in that? else what is the best way?)
Also please suggest in any case Archivelog is related to Import / Export Utility
Thanks in Advance,
Regards,
Pratap
|
|
|
|
| Re: Importing Dump files Created using Incremental Export [message #62225 is a reply to message #62215] |
Tue, 06 July 2004 03:54  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Incremental export is desupported by oracle.
It is strongly NOT recomended to use inc.export.
if you still intend to use ,then
1. apply the most recent export incexport.dmp with
full=y and inctype=system
2. again apply most recent FULL export fullexport.dmp
with full=y and inctype=restore
3. If you have any other cumulative exports in between
run all these.
4. redo the last incremental export ( as in step 1)
but with full=y and inctype=restore.
>> first, shall i need to create same database as
>> before crash? whether template created by dbca
>> will help me in that? else what is the best way?)
as usual in the regular import pre-create the database.recreate the tablespaces LIKE THe source DB.do the import.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
