Restoring Backup

[ricardo25ti]

Environment information:
* Oracle version: Database 10G Enterprise Edition Release 10.2.0.1.0
* Operating system: Windos XP (in a virtual machine)

Gentlemen Good evening, I am restoring a backup on a virtual machine (Windows XP) to do some tests, when making import (I am using the imp and the exp) in the end the following error occurs:
[[0]

Does anyone know where I can make this setup so that does not occur more? Thank you very much in advance.

[diegolenhardt]

But after this error occurs for import or goes to the end?

If you are arriving at the end you can create the jobs manually after,



You are using the option Fromuser and Touser right? (IMP)

[ricardo25ti]

This goes to the end and apparently the bank is working normal, I have not seen error yet. I have already used

Select all

 touser fromuser

and I have also used

Select all

full=y

in both cases presented the same error.

[diegolenhardt]

Are the same versions?

I have several times had problems with the jobs, I suggest you create them manually and good.

=]

[pedroedu]

this same, knife oqo diego said, in this case create the jobs manual over after the same import: wink: and another, only a friend's tip, export and import can not be considered a restoration of a backup, because you do not make a cold backup Even, restores and opens the bank ??? I would not have these problems with Jobs: Wink: and other BD parameters

[ricardo25ti]

In case it would stop the bank and copy all the files?

[pedroedu]

If it is a 24x7 bank that can not stop shooting way, not to ... but if it is a bank where there is a long interval of access, you can schedule a stop and do it ... Abraco ...

[ricardo25ti]

In case what would I copy? What folders?

[diegolenhardt]

Dude, I suggest using the DataPump or Export, it's a good time to rearrange your data files,

for example, has tables that were created and no longer exist, inserted data and have been deleted , this caused your Datafiles to grow, but when deleting, deleting the data they do not come back, then with the Export / DataPump process the bank is recreated and the import will write sequentially again in the data files.

If you do not have many tablespaces, you create the bank by the DBCA, which will allow you to visualize all parameters graphically by adjusting them according to the new need, (memory, sizes), etc. .

[ricardo25ti]

is for a test base, that's why the idea of ??the backup is not so bad

[diegolenhardt]

Rman ...