文件系统迁移到ASM

磁盘组要先建好,然后备份到磁盘组里,然后用备份恢复控制文件和数据文件,然后启动库,日志和temp都后面手动添加新的,删除旧的!!!
1、首先打开归档，确认归档路径SQL> archive log list
– 建磁盘组 cd /u01/app/oracle/product/11.2.0/grid/bin - - > ./asmca
2、查询下数据库文件结构SQL> select name from v$datafile;

SQL> select name from v$controlfile;

SQL> select member from v$logfile;

SQL> select name from v$tempfile;
3、全库做备份：open状态就可以

[oracle@edsir1p8-PROD4 ~]$ rman target /RMAN> BACKUP as copy database format ‘+DATA1’;
RMAN> EXIT-- 创建测试表 testrc-- 切归档 (强制归档)
SQL> alter system archive log current;
4、 查看asm磁盘组中备份的控制文件的路径
RMAN> list backup of controlfile;
specification does not match any backup in the repository

RMAN> list copy of controlfile;
5、修改spfile文件中控制文件的路径信息[oracle@edsir1p8-PROD4 ~]$ sqlplus / as sysdbaSQL> alter system set control_files=’+DATA1/prod4/controlfile/backup.260.91208958’ scope=spfile;
SQL>shutdown immediate
SQL> startup mount;

– 修改控制文件里的指针信息；
rman target /
RMAN> switch database to copy; 此处如果出现报错可以重新备份再次操作这一步
RMAN> recover database;注意命令!!!
RMAN> alter database open resetlogs;
指定resetlogs，会执行下列 1）将当前的在线重做日志文件归档，然后清空其内容并将日志文件序列号重置为1 2）重置控制文件中关于在线重做日志文件的元数据 3）更新数据文件和在线重做日志文件的resetlogs scn等信息
6、创建新的临时表空间文件，并删除旧的
SQL> alter tablespace temp add tempfile ‘+DATA1’ size 200M;
SQL> alter database tempfile ‘/u01/app/oracle/oradata/PROD4/PROD4/temp01.dbf’ drop;
SQL> select name from v$tempfile;

7、把redo添加新的成员，删除老的成员，查看原来有多少组，就添加多少成员
SQL> select member from vKaTeX parse error: Expected 'EOF', got '#' at position 207: …L> select group#̲,status,member …logfile;
– 初始化新加的logfile
SQL> alter system switch logfile;–最少执行三遍
SQL> select group#,status,member from vKaTeX parse error: Expected 'EOF', got '#' at position 37: …L> select group#̲,members,status…log;
SQL> alter system switch logfile;
– 删除旧的logfile member(如果无法删除，说明该文件还在使用，我们可以进行手工切换之后，再删除)
SQL> alter database drop logfile member ‘/u01/app/oracle/oradata/PROD4/PROD4/redo03.log’;
SQL> alter database drop logfile member ‘/u01/app/oracle/oradata/PROD4/PROD4/redo02.log’;
SQL> alter database drop logfile member ‘/u01/app/oracle/oradata/PROD4/PROD4/redo01.log’;