Oracle primary simple logical backup restore

Oracle primary simple logical backup restore

Note:

1, all commands run at the cmd command prompt (type EXP help=y or imp help=y for help information).

2, the path folder must exist (in this case, the folder Oracleback must exist).

To back up the fruit table under user ORCL separately:

Exp Userid=xxk/password direct=y tables= (fruit) file=d:\oracleback\baktb_fruit20140509.dmp log=d:\oracleback\baktb_ Fruit_log20140509.log

To back up all tables under User orcl:

Exp Userid=xxk/password direct=y file=d:\oracleback\bakdb20140509.dmp log=d:\oracleback\baklog20140509.log

Back up all (using System users)

Exp Userid=system/password direct=y full=y file=d:\oracleback\bakall_db20140509.dmp log=d:\oracleback\bakall_db_ Log20140509.log

Follow users and tables for recovery

Imp Userid=xxk/password file=d:\oracleback\baktb_fruit20140509.dmp Log=d:\oracleback\baktb_fruit_log20140509.log

Recover all (using System users)

Imp Userid=system/password full=y file=d:\oracleback\bakall_db20140509.dmp log=d:\oracleback\bakall_db_ Log20140509.log

Backups are used for a long time, and all information about the system is backed up, using either per-user or per-table to basically meet the needs

This article is from the "Oriental Pavilion" blog, please be sure to keep this source http://lailai.blog.51cto.com/3362373/1408902