Oracle数据库备份与恢复

oracle数据库导出

su -l oracle

exp username/password@IP/ServiceName file=./backup.dmp owner=o1,o2

示例： $ exp bwmdm/bwmdm@localhost/bwmdmdb file=./bwmdmdb.dmp owner=bwmdm

oracle数据库导入

imp username/password@IP/ServiceName file=./backup.dmp full=y

示例： $ imp bwmdm/bwmdm@10.60.4.166/bwmdmdb file=./bwmdmdb.dmp full=y