oracle 如何附加数据库

[kssys]

现在碰到一个问题，有Oracle的数据文件，不知道如何把它加入到Oracle里面，SQL Server有附加数据库功能，不知道oracle是否有类似的功能？

如果没有，请附上相关步骤，谢谢大家！

[minajo21]

只有 x.dbf ？

[minajo21]

参考一个迁移目录的：


//oracle目录为旧目录 oracle2为迁移目录 oracle 安装目录为/home/oracle;
//chown oracle:dba /oracle2

#copy目录admin 和 目录oradata及其文件至oracle2
修改 /oracle2/admin/orcl/pfile/initorcl.ora


#修改链接
ln -s /oracle2/admin/orcl/pfile/initorcl.ora /home/oracle/dbs/initorcl.ora


#用oracle身份登陆并启动sqlplus
sqlplus / nolog
connect /as sysdba
STARTUP NOMOUNT


#修改control file中所有数据文件的位置
alter database rename file '/oracle/oradata/orcl/system01.dbf' to '/oracle2/oradata/orcl/system01.dbf';
alter database rename file '/oracle/oradata/orcl/undotbs01.dbf' to '/oracle2/oradata/orcl/undotbs01.dbf';
alter database rename file '/oracle/oradata/orcl/cwmlite01.dbf' to '/oracle2/oradata/orcl/cwmlite01.dbf';
alter database rename file '/oracle/oradata/orcl/drsys01.dbf' to '/oracle2/oradata/orcl/drsys01.dbf';

alter database rename file '/oracle/oradata/orcl/example01.dbf' to '/oracle2/oradata/orcl/example01.dbf';
alter database rename file '/oracle/oradata/orcl/indx01.dbf' to '/oracle2/oradata/orcl/indx01.dbf';
alter database rename file '/oracle/oradata/orcl/odm01.dbf' to '/oracle2/oradata/orcl/odm01.dbf';
alter database rename file '/oracle/oradata/orcl/tools01.dbf' to '/oracle2/oradata/orcl/tools01.dbf';

alter database rename file '/oracle/oradata/orcl/users01.dbf' to '/oracle2/oradata/orcl/users01.dbf';
alter database rename file '/oracle/oradata/orcl/xdb01.dbf' to '/oracle2/oradata/orcl/xdb01.dbf';

alter database rename file '/oracle/oradata/orcl/redo01.log' to '/oracle2/oradata/orcl/redo01.log';
alter database rename file '/oracle/oradata/orcl/redo02.log' to '/oracle2/oradata/orcl/redo02.log';
alter database rename file '/oracle/oradata/orcl/redo03.log' to '/oracle2/oradata/orcl/redo03.log';


#重建控制文件
CREATE CONTROLFILE REUSE DATABASE "orcl" NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 453
LOGFILE
GROUP 1 '/oracle2/oradata/orcl/redo01.log' SIZE 100M,
GROUP 2 '/oracle2/oradata/orcl/redo02.log' SIZE 100M,
GROUP 3 '/oracle2/oradata/orcl/redo03.log' SIZE 100M
DATAFILE
'/oracle2/oradata/orcl/system01.dbf',
'/oracle2/oradata/orcl/undotbs01.dbf',
'/oracle2/oradata/orcl/cwmlite01.dbf',
'/oracle2/oradata/orcl/drsys01.dbf',
'/oracle2/oradata/orcl/example01.dbf',
'/oracle2/oradata/orcl/indx01.dbf',
'/oracle2/oradata/orcl/odm01.dbf',
'/oracle2/oradata/orcl/tools01.dbf',
'/oracle2/oradata/orcl/users01.dbf',
'/oracle2/oradata/orcl/xdb01.dbf'
CHARACTER SET ZHS16GBK
;
//RECOVER DATABASE
//ALTER SYSTEM ARCHIVE LOG ALL;
ALTER DATABASE OPEN;

#将临时文件添加到TEMP表空间中
alter tablespace TEMP add tempfile '/oracle2/oradata/orcl/temp01.dbf' size 20M;

[minajo21]

如果有x.dmp就方便多了。

[kssys]

有x.dmp，谢谢楼上朋友热心，麻烦提供一下有dmp的情况下应该怎么加上来。

[vc555]

你查查imp，exp的相关知识就有了。

[huanghuan999]

针对： *.dmp文件
步骤：
1 运行： cmd
2 执行： imp system/system@orcl file= F:\*.dmp fromuser=scott touser = tiger

[jacey_48557]

楼主，我有相同问题 呵呵 我有Pks,pkb文件不知道怎么附加


知道的话 还请赐教啊！谢谢了！