oracle11G 移动数据库

数据库迁移项目需求：

数据库所有文件（数据文件、日志文件、临时文件、控制文件）都存放在光纤存储中，但是光纤IBM4800存储使用时间过长，超过3年，经常出现一些问题，而且光纤存储需要厂家维护，维护方面不是很方便，需要将数据库文件迁移到IBMV7000存储中。

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ogg-node1-> sqlplus / as  sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 19 19:13:48 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing option
select name from
(select name from v$controlfile
union
select name from v$datafile
union
select name from v$tempfile
union
  8  select member from v$logfile);
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/fast_recovery_area/gdb1/control02.ctl
/u01/app/oracle/oradata/gdb1/control01.ctl
/u01/app/oracle/oradata/gdb1/example.dbf
/u01/app/oracle/oradata/gdb1/ggs.dbf
/u01/app/oracle/oradata/gdb1/redo01.log
/u01/app/oracle/oradata/gdb1/redo02.log
/u01/app/oracle/oradata/gdb1/redo03.log
/u01/app/oracle/oradata/gdb1/sysaux01.dbf
/u01/app/oracle/oradata/gdb1/system01.dbf
/u01/app/oracle/oradata/gdb1/undotbs01.dbf
/u01/app/oracle/oradata/gdb1/users01.dbf
11 rows selected.

创建目录
[root@ogg-node1 ~]# mkdir /u02/app/oracle/oradata/gdb1/ -p
[root@ogg-node1 ~]# chown -R oracle.oinstall /u02/app/oracle/oradata/gdb1/


修改参数文件
control_files = '/u02/app/oracle/oradata/gdb1/control01.ctl


关闭数据库
SQL> shutdown immediate;


建数据文件 日志文件 数据库文件 控制文件 移到/u02/app/oracle/oradata/gdb1/目录下面
ogg-node1-> ll
total 3134456
-rw-r----- 1 oracle oinstall    9748480 Aug 19 19:33 control01.ctl
-rw-r----- 1 oracle oinstall 1572872192 Aug 19 19:29 example.dbf
-rw-r----- 1 oracle oinstall   10493952 Aug 19 19:29 ggs.dbf
-rw-r----- 1 oracle oinstall   52429312 Aug 19 19:25 redo01.log
-rw-r----- 1 oracle oinstall   52429312 Aug 19 19:29 redo02.log
-rw-r----- 1 oracle oinstall   52429312 Aug 19 19:25 redo03.log
-rw-r----- 1 oracle oinstall  576724992 Aug 19 19:29 sysaux01.dbf
-rw-r----- 1 oracle oinstall  786440192 Aug 19 19:29 system01.dbf
-rw-r----- 1 oracle oinstall   30416896 Aug 19 18:14 temp01.dbf
-rw-r----- 1 oracle oinstall   89137152 Aug 19 19:29 undotbs01.dbf
-rw-r----- 1 oracle oinstall    5251072 Aug 19 19:29 users01.dbf       
ogg-node1-> mv * /u02/app/oracle/oradata/gdb1/


重建控制文件
CREATE CONTROLFILE REUSE DATABASE "gdb1" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/u02/app/oracle/oradata/gdb1/redo01.log' SIZE 50M,
  GROUP 2 '/u02/app/oracle/oradata/gdb1/redo02.log' SIZE 50M,
  GROUP 3 '/u02/app/oracle/oradata/gdb1/redo03.log' SIZE 50M
DATAFILE
'/u02/app/oracle/oradata/gdb1/system01.dbf',
'/u02/app/oracle/oradata/gdb1/undotbs01.dbf',
'/u02/app/oracle/oradata/gdb1/example.dbf',
'/u02/app/oracle/oradata/gdb1/ggs.dbf',
'/u02/app/oracle/oradata/gdb1/users01.dbf',
'/u02/app/oracle/oradata/gdb1/sysaux01.dbf'
CHARACTER SET WE8ISO8859P1;


数据库为nomount状态
SQL> startup nomount;
ORACLE instance started.


Total System Global Area  776646656 bytes
Fixed Size    2257272 bytes
Variable Size  494931592 bytes
Database Buffers  276824064 bytes
Redo Buffers    2633728 bytes


CREATE CONTROLFILE REUSE DATABASE "gdb1" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
  5      MAXINSTANCES 8
    MAXLOGHISTORY 292
  7  LOGFILE
  GROUP 1 '/u02/app/oracle/oradata/gdb1/redo01.log' SIZE 50M,
  GROUP 2 '/u02/app/oracle/oradata/gdb1/redo02.log' SIZE 50M,
  GROUP 3 '/u02/app/oracle/oradata/gdb1/redo03.log' SIZE 50M
DATAFILE
'/u02/app/oracle/oradata/gdb1/system01.dbf',
'/u02/app/oracle/oradata/gdb1/undotbs01.dbf',
'/u02/app/oracle/oradata/gdb1/example.dbf',
'/u02/app/oracle/oradata/gdb1/ggs.dbf',
'/u02/app/oracle/oradata/gdb1/users01.dbf',
'/u02/app/oracle/oradata/gdb1/sysaux01.dbf'
 18  CHARACTER SET WE8ISO8859P1;


Control file created.
打开数据库:
SQL> alter database open resetlogs;
Database altered.
添加临时文件:
SQL> alter tablespace temp add tempfile '/u02/app/oracle/oradata/gdb1/temp01.dbf' reuse;
Tablespace altered.

SQL> alter database open;


Database altered.


select name from
  2  (select name from v$controlfile
union
  4  select name from v$datafile
union
  6  select name from v$tempfile
union
  8  select member from v$logfile);


NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/gdb1/control01.ctl
/u02/app/oracle/oradata/gdb1/example.dbf
/u02/app/oracle/oradata/gdb1/ggs.dbf
/u02/app/oracle/oradata/gdb1/redo01.log
/u02/app/oracle/oradata/gdb1/redo02.log
/u02/app/oracle/oradata/gdb1/redo03.log
/u02/app/oracle/oradata/gdb1/sysaux01.dbf
/u02/app/oracle/oradata/gdb1/system01.dbf
/u02/app/oracle/oradata/gdb1/undotbs01.dbf
/u02/app/oracle/oradata/gdb1/users01.dbf