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

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;

相关内容