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