oracle 12c 数据迁移,ORACLE 12C 冷备份方式的数据迁移

修改了控制文件的路径

*.control_files=‘/u01/app/oracle/oradata/test/controlfile/control01.ctl‘

重建控制文件

startup mount

alter database backup controlfile to trace as ‘/tmp/crontol_trace‘;

cat /tmp/crontol_trace | grep -v ^- | grep -v ^$ > /tmp/ctl.sql

修改控制文件里的路径,因为我们有onlinelog所以选择noresetlog模式

vi /tmp/ctl.sql

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "TEST" NORESETLOGS  ARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 ‘/u01/app/oracle/oradata/test/onlinelog/redo01.log‘  SIZE 50M BLOCKSIZE 512,

GROUP 2 ‘/u01/app/oracle/oradata/test/onlinelog/redo02.log‘  SIZE 50M BLOCKSIZE 512,

GROUP 3 ‘/u01/app/oracle/oradata/test/onlinelog/redo03.log‘  SIZE 50M BLOCKSIZE 512

DATAFILE

‘/u01/app/oracle/oradata/test/datafile/system01.dbf‘,

‘/u01/app/oracle/oradata/test/datafile/sysaux01.dbf‘,

‘/u01/app/oracle/oradata/test/datafile/undotbs01.dbf‘,

‘/u01/app/oracle/oradata/test/datafile/users01.dbf‘,

‘/u01/app/oracle/oradata/test/datafile/qwerty.dbf‘,

‘/u01/app/oracle/oradata/test/datafile/testbig.dbf‘,

‘/u01/app/oracle/oradata/test/datafile/data_01.dbf‘

CHARACTER SET AL32UTF8

;

RECOVER DATABASE

ALTER SYSTEM ARCHIVE LOG ALL;

ALTER DATABASE OPEN;

ALTER TABLESPACE TEMP ADD TEMPFILE ‘/u01/app/oracle/oradata/test/datafile/temp01.dbf‘ REUSE;

ALTER TABLESPACE TEMP ADD TEMPFILE ‘/u01/app/oracle/oradata/test/datafile/temp02.dbf‘ REUSE;

ALTER TABLESPACE TEMP_ASYNC ADD TEMPFILE ‘/u01/app/oracle/oradata/test/datafile/temp_async_01.dbf‘ REUSE;

修改完毕后，将数据库启动到nomount状态

shutdown immediate

startup nomout;

运行重建控制文件的sql语句

@/tmp/ctl.sql

SQL> select status from v$instance;

STATUS

------------

OPEN

至此，已经完成数据库的迁移。

本文出自 “Sysdba” 博客，请务必保留此出处http://sysdba.blog.51cto.com/10492366/1702149

ORACLE 12C 冷备份方式的数据迁移

标签：冷备份   oracle数据库迁移   12c

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：http://sysdba.blog.51cto.com/10492366/1702149