Oracle导机迁移全过程

2014-11-24 18:35:20 · 作者: · 浏览: 0

chown -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.log


vi /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;