备份
命令详解
exp system/test1234@imapdb full=y file=/opt/oracle/dbbackup/imapdb/20120416/201204016.dmp log=/opt/oracle/dbbackup/imapdb/20120416/20120416.log
exp: 备份命令字
system/test1234@imapdb :数据库用户名/数据库密码@数据库实例名
full=y: 全量备份
file=/opt/oracle/dbbackup/imapdb/20120416/201204016.dmp : 备份的目的文件
log=/opt/oracle/dbbackup/imapdb/20120416/20120416.log :备份过程中的日志
oracle数据库恢复:
删除数据库表和表空间:
drop tablespace IMAP_DB including contents and datafiles cascade constraints; //IMAP_DB为oracle表名称
commit; //提交数据库操作
恢复oracle数据库:
imp system/test1234@imapdb full=y file=/opt/oracle/dbbackup/imapdb/20120416/201204016.dmp DESTROY=y log=/opt/oracle/dbbackup/imapdb/20120416/20120416.log
补充:sybase数据库备份和恢复
登录sybase数据库:isql -S$DB_SRV_NAME -U$DB_USER -P$DB_PWD