oracle backup database

 

1. dmp 现有数据库

exp hr/hr@xe file=D:\xetest\dups\test_bak20150414.dmp owner=Hr

 

2. 切换sqlplus操作 

sqlplus /nolog 

 

3. 输入数据库用户名和密码 

conn sys/sys

4. 创建新数据库用户

Create Temporary Tablespace User_Temp 
tempfile 'D:\xetest\user_temp.dbf' 
size 500m 
autoextend on 
next 50m maxsize 2048m 
extent management local; 
create tablespace test_mynewdb 
logging 
datafile 'D:\xetest\test_mydb.dbf' 
size 500m 
autoextend on 
next 50m maxsize 2048m 
Extent Management Local; 
drop user mynewdb cascade; 
create user mynewdb identified by mynewdb 
default tablespace test_mynewdb 
Temporary Tablespace User_Temp; 
grant connect,resource,dba to mynewdb;

 

5. 导入数据

imp mynewdb/mynewdb@Xe file=D:\xetest\dups\test_bak20150414.dmp  fromuser=hr touser=mynewdb

 

 

6. 查看现有数据文件存放位置

 

select FILE_NAME from dba_data_files;

 

7.查看数据库日志文件位置

 

select * from v$logfile;