oscar数据库windows及linux下备份恢复命令

来源：互联网发布：北京软件工作室编辑：程序博客网时间：2024/05/08 10:39

windows下：

备份命令
osrexp -usysdba/szoscar55 -hlocalhost -p2003 -dosrdb level=schema file=D:\temp\t\exp log=D:\temp\t\bk_exp.log mode=entirety ignore=false schema=(jc6_dz) view=true sequence=true procedure=true constraint=true trigger=true index=true

恢复命令
osrimp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=c:/20140328.osr log=c:/bk_imp.log mode=entirety ignore=true schema=(jk_dz) recreateschema=false view=true sequence=true procedure=true recreateotherobject=true recreatetable=true constraint=true deletetabledata=true trigger=true index=true

linux下：

备份命令
osrexp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=/home/oscar/20140328.osr log=/home/oscar/bk_exp.log mode=entirety ignore=false schema=\(jc6_dz\) view=true sequence=true procedure=true constraint=true trigger=true index=true

恢复命令
osrimp -ujk_dz/jh0101 -hlocalhost -p2003 -dosrdb level=schema file=/home/oscar/20140328.osr log=/home/bk_imp.log mode=entirety ignore=true schema=\(jc6_dz\) recreateschema=false view=true sequence=true procedure=true recreateotherobject=true recreatetable=true constraint=true deletetabledata=true trigger=true index=true

0 0