1、oracle的启动停止
su - oracle
lsnrctl status
lsnrctl start
sqlplus /nolog
conn as sysdba
user-name: system
startup shutdown
2、创建用户及对应的表空间
select name from v$datafile;
CREATE TABLESPACE nc_temp datafile '/oradata/bq2db/nc_temp.dbf' size 600M autoextend on next 50m maxsize unlimited;
CREATE USER nc_temp IDENTIFIED BY nc_temp DEFAULT TABLESPACE nc_temp;
grant connect,resource,dba to nc_temp;
3、导入数据
imp
要导入的数据库用户名和密码: Username: nc_temp/nc_temp
用nc_57用户导出的数据文件:Import file: expdat.dmp > /oracle/dump_file/nc57_2014.dmp
Username: nc57(导出时使用的用户nc_57)
4、导出备份数据
备份
select * from dba_directories; #查看数据路径
create directory DATA_PUMP_DIR as '/oradata/bq2db/bf'; #再创建一个路径(DATA_DUMP_DIR)
expdp spark_kf5/spark_kf5@10.10.20.90/bq2db schemas=spark_kf5 directory=DATA_DUMP_DIR dumpfile=/oradata/KF5_201712251124.dmp logfile=KF5_201712251124.log
su - oracle
lsnrctl status
lsnrctl start
sqlplus /nolog
conn as sysdba
user-name: system
startup shutdown
2、创建用户及对应的表空间
select name from v$datafile;
CREATE TABLESPACE nc_temp datafile '/oradata/bq2db/nc_temp.dbf' size 600M autoextend on next 50m maxsize unlimited;
CREATE USER nc_temp IDENTIFIED BY nc_temp DEFAULT TABLESPACE nc_temp;
grant connect,resource,dba to nc_temp;
3、导入数据
imp
要导入的数据库用户名和密码: Username: nc_temp/nc_temp
用nc_57用户导出的数据文件:Import file: expdat.dmp > /oracle/dump_file/nc57_2014.dmp
Username: nc57(导出时使用的用户nc_57)
4、导出备份数据
备份
select * from dba_directories; #查看数据路径
create directory DATA_PUMP_DIR as '/oradata/bq2db/bf'; #再创建一个路径(DATA_DUMP_DIR)
expdp spark_kf5/spark_kf5@10.10.20.90/bq2db schemas=spark_kf5 directory=DATA_DUMP_DIR dumpfile=/oradata/KF5_201712251124.dmp logfile=KF5_201712251124.log