Oracle导机迁移全过程

104上 scp 到 25上
scp /opt/Oracle/111/dbs/initORCL.ora root@10.1.0.25:/opt/oracle/111/dbs/initORCL.ora
scp /opt/oracle/111/dbs/spfileORCL.ora root@10.1.0.25:/opt/oracle/111/dbs/spfileORCL.ora
scp /opt/oracle/111/dbs/orapwORCL root@10.1.0.25:/opt/oracle/111/dbs/orapwORCL
scp /opt/oracle/oradata/orcl/control01.ctl root@10.1.0.25:/opt/oracle/oradata/orcl/control01.ctl
scp /opt/oracle/flash_recovery_area/orcl/control02.ctl root@10.1.0.25:/opt/oracle/oradata/orcl/control02.ctl
scp /opt/oracle/oradata/orcl/system01.dbf root@10.1.0.25:/opt/oracle/oradata/orcl/system01.dbf
scp /opt/oracle/oradata/orcl/sysaux01.dbf root@10.1.0.25:/opt/oracle/oradata/orcl/sysaux01.dbf
scp /opt/oracle/oradata/orcl/undotbs01.dbf root@10.1.0.25:/opt/oracle/oradata/orcl/undotbs01.dbf
scp /opt/oracle/oradata/orcl/users01.dbf root@10.1.0.25:/opt/oracle/oradata/orcl/users01.dbf
scp /opt/oracle/111/TBS_FALABELLA.DBF root@10.1.0.25:/opt/oracle/oradata/orcl/TBS_FALABELLA.DBF
scp /opt/oracle/oradata/orcl/FALABELLA_SO.DBF root@10.1.0.25:/opt/oracle/oradata/orcl/FALABELLA_SO.DBF
scp /opt/oracle/oradata/orcl/temp01.dbf root@10.1.0.25:/opt/oracle/oradata/orcl/temp01.dbf
scp /opt/oracle/111/TBS_FALABELLA_TEMP.DBF root@10.1.0.25:/opt/oracle/oradata/orcl/TBS_FALABELLA_TEMP.DBF
scp /opt/oracle/oradata/orcl/FALABELLA_SO_TEMP.DBF root@10.1.0.25:/opt/oracle/oradata/orcl/FALABELLA_SO_TEMP.DBF
scp /opt/oracle/oradata/orcl/redo01.log root@10.1.0.25:/opt/oracle/oradata/orcl/redo01.log
scp /opt/oracle/oradata/orcl/redo02.log root@10.1.0.25:/opt/oracle/oradata/orcl/redo02.log
scp /opt/oracle/oradata/orcl/redo03.log root@10.1.0.25:/opt/oracle/oradata/orcl/redo03.logchown -R oracle:dba /opt/oracle/111/dbs/initORCL.ora
chown -R oracle:dba /opt/oracle/111/dbs/spfileORCL.ora
chown -R oracle:dba /opt/oracle/111/dbs/orapwORCL
chown -R oracle:dba /opt/oracle/oradata/orcl/control01.ctl
chown -R oracle:dba /opt/oracle/oradata/orcl/control02.ctl
chown -R oracle:dba /opt/oracle/oradata/orcl/system01.dbf
chown -R oracle:dba /opt/oracle/oradata/orcl/sysaux01.dbf
chown -R oracle:dba /opt/oracle/oradata/orcl/undotbs01.dbf
chown -R oracle:dba /opt/oracle/oradata/orcl/users01.dbf
chown -R oracle:dba /opt/oracle/oradata/TBS_FALABELLA.DBF
chown -R oracle:dba /opt/oracle/oradata/orcl/FALABELLA_SO.DBF
chown -R oracle:dba /opt/oracle/oradata/orcl/temp01.dbf
chown -R oracle:dba /opt/oracle/oradata/TBS_FALABELLA_TEMP.DBF
chown -R oracle:dba /opt/oracle/oradata/orcl/FALABELLA_SO_TEMP.DBF
chown -R oracle:dba /opt/oracle/oradata/orcl/redo01.log
chown -R oracle:dba /opt/oracle/oradata/orcl/redo02.log
chown -R oracle:dba /opt/oracle/oradata/orcl/redo03.logvi /opt/oracle/111/dbs/initORCL.ora
/opt/oracle/flash_recovery_area/orcl/control02.ctl /opt/oracle/oradata/orcl/control02.ctl
startup nomount pfile="/opt/oracle/111/dbs/initORCL.ora";
create spfile from pfile
shutdown immediate;
startup mount;alter database rename file "/opt/oracle/oradata/TBS_FALABELLA.DBF" to "/opt/oracle/oradata/orcl/TBS_FALABELLA.DBF";
alter database rename file "/opt/oracle/oradata/TBS_FALABELLA_TEMP.DBF" to "/opt/oracle/oradata/orcl/TBS_FALABELLA_TEMP.DBF";alter database open;sqlplus 执行脚本文件时如何传参数Oracle 更改 db_name 的方法相关资讯 Oracle数据库 Oracle入门教程 oracle数据库教程

Oracle数据库全球化（03月01日）
Oracle数据库日期过滤方法性能比较（02/02/2015 13:20:26）
Oracle数据库安装中端口被占用问题（10/29/2014 07:42:24）

在CentOS 6.6上搭建C++运行环境并（10/10/2015 19:44:40）
Oracle数据库无法使用localhost和（11/14/2014 16:39:10）
使用SQLT来构建Oracle测试用例（08/28/2014 06:17:41）

本文评论查看全部评论（0）