Recovering a DB instance with Exp/imp Backup

Source: Internet
Author: User

To back up the database with Exp/imp:

Oracle Data Import Export IMP/EXP
Function: Oracle data import and export imp/exp is comparable with Oracle data restore and backup.

In most cases, the data can be backed up and restored with Oracle data import and export (no loss of data).
Oracle has a benefit, although your computer is not a server, but you installed the Oracle client and established a connection
(with the net Configuration Assistant add the correct service naming, you can actually think of the client and the server side to fix the road, then the data can be pulled over)
This allows you to export the data locally, although the server may be far away from you.
You can also import DMP files from a local to a remote database server.
With this feature you can build two identical databases, one for testing and one for formal use.

Operation Steps:

1. Access to Oracle User Su-oracle

2. Then execute the EXPORT command under Oracle User: Exp test1/test1 file=/home/oracle/vpntable/daochu.dmp Owner=test1
: The last sentence is to export the entire database of the user test1 the password to test1, and export the file to the path/HOME/ORACLE/VPNTABLE/DAOCHU.DMP.
Note that there may be write permission issues when setting the export path, which can be resolved by giving the path corresponding permissions, as the example above writes the export path to the Oracle user.

3. Import the Backup to another database: Imp test2/test2 file=/home/oracle/vpntable/daochu.dmp full=y ignore=y
: Full=y ignore=y full=y is all imported, Ingore =y statement ignores objects that already exist.

Other:

Difference between 1.exp and EXPDP: http://blog.csdn.net/wyzxg/article/details/5853590

2. Enter SQL command line steps: 1, su-oracle 2, Lsnrctl start 3, Sqlplus/nolog 4, Conn/as sysdba 5, startup

Ref

1.http://www.cnblogs.com/fjfzhkb/archive/2007/09/03/879807.html

2.http://www.cnblogs.com/zdz8207/p/3793246.html

Recovering a DB instance with Exp/imp Backup

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.