How to import a database into Oracle 11g from a dump?

Question

Oracle

Tell me how to do a full database import from a dump file on Oracle 11g.
OS: Solaris 11.2
DBMS: Oracle 11.2
There is not a single database on the server, only Oracle itself was installed without creating a database.
You need to deploy the database from the dump.
I tried to do it to an empty database:
imp [email protected] full=y file=/db/data.dump log=/oracle/imp.log
Errors appear on import: IMP- 00015
: following statement failed because the object already exists:

what is the general procedure for restoring a database, can it be done if there is not a single database on the server?

Answer 1

Good afternoon! To deploy a full backup to a newly installed database, you must first create this database.
To do this, you need to log in as an oracle user via ssh with the -Y
ssh -Y [email protected] address or server name parameter. (this is if from Linux, if you need to use Xming from Windows) in the server console from under the oracle user, you need to run dbca, a graphical thing to create a database.
to this empty database, and you will need to restore your ladies
with the parameters imp userid=system/[email protected] file=file name.dmp full=Y ignore=Y, rows=Y buffer=10485760 GRANTS=Y log=log name.log
when This will break the current settings of the new database.
it is better to use fromuser and touser parameters instead of full (you will have to create a user and a label for it beforehand)
and even better if there is the possibility of impdp and expdp
(more correctly, the dump rises without breaking the parameters of the current database)