oracle emp和imp备份 恢复总结
- 格式：doc
- 大小：25.00 KB
- 文档页数：2
先查看是否是当前实例，如果不是就修改
Set ORACLESID=ORACL
如果不指定实例，则需要在登陆时指定
连接sqlplus system/ph8880@orcl
Lsnrctl start
Lsnrrctl status
查看本地网络情况
Natstat –na
Show parameter service //查看当前的service name
Select username from dba_users; //查看当前实例下的所有用户
select TABLESPACE_NAME from user_tablespaces; //查看当前实例下的所有表
create user scys identified by
imp system/ph8880@orcl file=D:\20130319181244scys_backup.dmp fromuser=scys touser=scys_t log=20120322.log
物化视图，数据库link等需要重新定义，亦可以
Ed //编辑
Alter user scystest identified by manager;
desc dba_users
show parameter serv
select username from dba_users;
desc dba_users
select username,password,default_tablespace from dba_users;
select username,password,default_tablespace from dba_users where username='SCYS’
create user scystest identified by values 'ECF45E703CB3D60C' default tablespace=’scys’;grant connect,resource to scystest; //一般只需要授予用户三个权限即可，即connect ,resource和
unlimited tablespace
grant unlimited tablespace to scystest;
grant create database link to scystest;
grant create view to scystest;
@echo off
@echo 此脚本用于备份生产运输数据库
set t=%time:~0,8%
set t=%t::=%
set t=%t: =0%
set sstr=%date:~0,4%%date:~5,2%%date:~8,2%%t%
set NLS_LANG=american_america.AL32UTF8
@echo 当前时间%sstr%
exp system/ph8880@pmdb owner=scys file=e:\scys\%sstr%scys_backup.dmp log=e:\scys\%sstr%scys_backup.log。
