Oracle数据库常用备份和恢复参考命令

（1）全备份
全库备份：exp inctype=complete file=’pathname/filename.dmp’ log= filename.log
全库恢复：imp   file= ’pathname/filename.dmp’ log= filename.log buffer=5000000 ignore=y constraints=n
单用户备份：exp   file=’pathname/filename.dmp’ log= filename.log
单用户恢复：imp   file= ’pathname/filename.dmp’ log=filename.log buffer=5000000  fromuser=usename touser=username ignore=y constraints=n
（2）增量备份
全库备份：exp inctype=INCREMENTAL file=’pathname/filename.dmp’ log= filename.log
全库恢复：imp file=’pathname/filename.dmp’ log= filename.log buffer=5000000 ignore=y constraints=n
单用户备份：imp file=’pathname/filename.dmp’ log= filename.log buffer=5000000 ignore=y constraints=n
单用户恢复：imp   file= ’pathname/filename.dmp’ log=filename.log buffer=5000000  fromuser=usename touser=username ignore=y constraints=n
（3）备份表结构
备份：exp inctype=complete ROWS= n file=’pathname/filename.dmp’ log= filename.log
恢复：imp file=filename.dmp log=logfilename buffer=5000000  fromuser=username touser=usename constraints=y rows=n ignore=y