八、打开数据库
RMAN> ALTER DATABASE OPEN;
database opened
RMAN>
九、迁移临时文件
由于临时文件不会被迁移，所以我们只需要删除原来的增加新的就可以。
SQL> SELECT NAME FROM V$TEMPFILE;
NAME
--------------------------------------------------
/u01/oradata/TOASM/temp01.dbf
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '+DGROUP1';
Tablespace altered.
SQL> ALTER TABLESPACE TEMP DROP TEMPFILE '/u01/oradata/TOASM/temp01.dbf';
Tablespace altered.
SQL> SELECT NAME FROM V$TEMPFILE;
NAME
--------------------------------------------------
+DGROUP1/toasm/tempfile/temp.263.683428909
SQL>
十、增加新的ONLINE REDOLOGS 到ASM
SQL> SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 5 10485760 1 YES INACTIVE 473286 06-APR-09
2 1 6 10485760 1 NO CURRENT 474627 06-APR-09
3 1 4 10485760 1 YES INACTIVE 472097 06-APR-09
SQL> ALTER DATABASE ADD LOGFILE '+DGROUP1' SIZE 10M;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE '+DGROUP1' SIZE 10M;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE '+DGROUP1' SIZE 10M;
Database altered.
SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
Database altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> SQL> ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 2
*
ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance TOASM (thread 1)
ORA-00312: online log 2 thread 1: '/u01/oradata/TOASM/redo02.log'
SQL> ALTER SYSTEM CHECKPOINT;
System altered.
SQL> ALTER DATABASE DROP LOGFILE GROUP 2;
Database altered.
SQL>ALTER DATABASE DROP LOGFILE GROUP 3;
Database altered.
SQL> SELECT MEMBER FROM V$LOGFILE;
MEMBER
--------------------------------------------------
+DGROUP1/toasm/onlinelog/group_4.275.683429043
+DGROUP1/toasm/onlinelog/group_5.276.683429047
+DGROUP1/toasm/onlinelog/group_6.264.683429049
SQL>
十一、最后删除原来的数据库文件
[oracle@ASM ~]$ ls -lh /u01/oradata/TOASM/
total 892M
-rw-r----- 1 oracle oinstall 6.8M Apr 6 01:05 control01.ctl
-rw-r----- 1 oracle oinstall 6.8M Apr 6 01:05 control02.ctl
-rw-r----- 1 oracle oinstall 6.8M Apr 6 01:05 control03.ctl
-rw-r----- 1 oracle oinstall 101M Apr 6 01:05 example01.dbf
-rw-r----- 1 oracle oinstall 11M Apr 6 01:17 redo01.log
-rw-r----- 1 oracle oinstall 11M Apr 6 01:24 redo02.log
-rw-r----- 1 oracle oinstall 11M Apr 6 01:17 redo03.log
-rw-r----- 1 oracle oinstall 231M Apr 6 01:05 sysaux01.dbf
-rw-r----- 1 oracle oinstall 481M Apr 6 01:05 system01.dbf
-rw-r----- 1 oracle oinstall 26M Apr 6 01:05 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5.1M Apr 6 01:05 users01.dbf
[oracle@ASM ~]$ rm -rf /u01/oradata/TOASM/*
[oracle@ASM ~]$ ls -lh /u01/oradata/TOASM/
total 0
[oracle@ASM ~]$
迁移完毕！
责任编辑：小草
您现在的位置： 