Oracle之备份还原

创建表分区

createtablespaceappsdatafile'&1apps.dbf'size10mautoextendonnext8m;
createtablespaceappsysdatafile'&1appsys.dbf'size10mautoextendonnext8m;

创建分区表空间

createtablespaceAPPS_00datafile'&1APPS_00.dbf'size10Mautoextendonnext8M;
createtablespaceAPPSYS_00datafile'&1APPSYS_00.dbf'size10Mautoextendonnext8M;

删除用户

dropuserappscascade;
dropuserappsyscascade;

创建用户

createuserappsidentifiedbycapedefaulttablespaceapps;
createuserappsysidentifiedbycapedefaulttablespaceappsys;

授权

grantdbatoappswithadminoption;
grantdbatoappsys;

grantcreateanytabletoapps;
grantalteranytabletoapps;
grantdropanytabletoapps;

grantcreateanyindextoapps;
grantdropanyindextoapps;

创建目录

createorreplacedirectoryexpdp_wms_diras'D:data_bak';
grantread,writeondirectoryexpdp_wms_dirtoAPPS;

EXP/IMP备份与还原

expuser/pwd@SIDfile=d:db_20101010.dmplog=d:db_20101010.logowner=(apps,appsys)

impuser/pwd@SIDfile=D:db_20101010.dmplog=D:db_20101010.logfromuser=appstouser=appsfromuser=appsystouser=appsysignore=y

EXPDP/IMPDP备份还原

expdpuser/pwd@SIDdumpfile=DB20141216.dmplogfile=DB20141216.logschemas=(apps,appsys)directory=expdp_dirjob_name=expdp_jobversion=11.1.0.2

impdpuser/pwd@SIDdumpfile=DB20141216.DMPlogfile=DB20141216.logschemas=(apps,appsys)directory=impdp_dirjob_name=impdp_job

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!