1.单表备份命令
数据库账号:lqmiss
数据库密码:lq123
--------------------------------
nohup exp lqmiss/lq123@orcl
file=/oracle-log/bak.dmp tables=tables1,tables1,tables1,tables1,tables1,.....
log=/oracle-log/bak.log &
2.分卷压缩
----------------------------
zip -s 50m Documents.zip /home/user/Documents/*
3.整库备份
--------------------
备份执行语句:备份命令
---------------------------------
nohup exp lqmiss/lq123@orcl owner=lqmiss
file=/oracle-log/bak.dmp
log=/oracle-log/bak.log &
4.数据恢复还原
------------------------------------
1、要用Oracle用户执行,su oracle
2、报错:only a DBA can import a file exported by another DBA;
需要DBA给用户赋权,赋权语句:
grant imp_full_database to lqmiss;
导入命令
fromuser=lqmiss1 从lqmiss1 账号下取出数据
touser=lqmiss 导入至lqmiss 账号
-----------------------------------------
nohup imp lqmiss/lqmiss@orcl fromuser=lqmiss1 touser=lqmiss
file= /data/bak.dmp
log= /data/bak.log &