修改了控制文件的路径
*.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