oracle 恢复备份

down voteaccepted

How was the database exported? If it was exported using exp and a full schema was exported, then Create the user: create user <username> identified by <password> default tablespace <tablespacename> quota unlimited on <tablespacename>; Grant the rights: grant connect, create session, imp_full_database to <username>; Start the import with imp: imp <username>/<password>@<hostname> file=<filename>.dmp log=<filename>.log full=y; If it was exported using expdp, then start the import with impdp: impdp <username>/<password> directory=<directoryname> dumpfile=<filename>.dmp logfile=<filename>.log full=y; Looking at the error log, it seems you have not specified the directory, so Oracle tries to find the dmp file in the default directory (i.e., E:\app\Vensi\admin\oratest\dpdump\). Either move the export file to the above path or create a directory object to pointing to the path where the dmp file is present and pass the object name to the impdp command above.

71down voteaccepted

How was the database exported? If it was exported using exp and a full schema was exported, then Create the user: create user <username> identified by <password> default tablespace <tablespacename> quota unlimited on <tablespacename>; Grant the rights: grant connect, create session, imp_full_database to <username>; Start the import with imp: imp <username>/<password>@<hostname> file=<filename>.dmp log=<filename>.log full=y; If it was exported using expdp, then start the import with impdp: impdp <username>/<password> directory=<directoryname> dumpfile=<filename>.dmp logfile=<filename>.log full=y; Looking at the error log, it seems you have not specified the directory, so Oracle tries to find the dmp file in the default directory (i.e., E:\app\Vensi\admin\oratest\dpdump\). Either move the export file to the above path or create a directory object to pointing to the path where the dmp file is present and pass the object name to the impdp command above.