Shulou(Shulou.com)06/01 Report--

Oracle Primary simple Logic backup and restore

Note:

1, all commands are run at the cmd command prompt (type EXP HELP=Y or IMP HELP=Y for help).

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

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

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

Restore according to user and table

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

Restore all (using system users)

Imp userid=system/password full=y file=d:\ oracleback\ bakall_db20140509.dmp log=d:\ oracleback\ bakall_db_log20140509.log

The backup takes a long time, and all the information of the system is backed up, which can basically meet the demand by user or by table.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.