八、打开数据库 RMAN> ALTER DATABASE OPEN;
' Q4 p* R2 V( {4 e& s database opened) {/ i' s4 K- C3 }( V4 k% p8 r
RMAN>
0 P3 y W0 E3 Z, J: ] 九、迁移临时文件
: f2 c/ S7 L& C. z8 |; ?2 [ 由于临时文件不会被迁移,所以我们只需要删除原来的增加新的就可以。- P9 D% z+ S+ _1 _/ o+ `4 O5 S, W
SQL> SELECT NAME FROM V$TEMPFILE;
" v( e7 s! O9 K- J \ NAME
' f$ D5 l5 G2 `/ D( y- p6 {+ Z- I( y --------------------------------------------------
2 K9 I- M& H h; k. g /u01/oradata/TOASM/temp01.dbf& R+ U+ |& h4 d1 j* Y; \% l R3 [
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '+DGROUP1';$ L! e# R/ \/ A! J
Tablespace altered.1 @9 p, P6 Y8 H$ h! w' a5 A. [
SQL> ALTER TABLESPACE TEMP DROP TEMPFILE '/u01/oradata/TOASM/temp01.dbf';
; Q M5 ~; c% m1 K) ?% m Tablespace altered.
# S* g s4 b. c! p0 z SQL> SELECT NAME FROM V$TEMPFILE;
1 o, a1 E; J, n1 K# x h) u NAME
* L" h- [7 v8 p+ I5 { --------------------------------------------------9 s) \* Y4 a9 X4 U+ {; N7 I
+DGROUP1/toasm/tempfile/temp.263.683428909' \4 i& N, X7 p3 K. V" x; J
SQL>
7 V n- t2 ^' b# O 十、增加新的ONLINE REDOLOGS 到ASM8 \! F# H: t/ `7 g% Z" l0 T8 l" m
SQL> SELECT * FROM V$LOG;7 u1 i3 I$ p8 ` t& `5 ^) l
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
" {9 H% W8 e; D2 O- R2 k+ ` ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------$ t J6 i7 V/ X: `' p$ E6 j+ ]
1 1 5 10485760 1 YES INACTIVE 473286 06-APR-09
0 |9 t" A! ^% ? f 2 1 6 10485760 1 NO CURRENT 474627 06-APR-099 P) E# t" i5 P1 j$ v0 _" h
3 1 4 10485760 1 YES INACTIVE 472097 06-APR-09
! g7 h! N; h4 W/ P5 A7 a# q9 F- e; A SQL> ALTER DATABASE ADD LOGFILE '+DGROUP1' SIZE 10M;8 G, e. Q6 \7 m) W
Database altered.
6 K. A. Y9 Q6 |# H# S0 [" | SQL> ALTER DATABASE ADD LOGFILE '+DGROUP1' SIZE 10M;0 x# m' n1 L/ _+ W* |
Database altered.
; t$ n& M' O' [- q. L SQL> ALTER DATABASE ADD LOGFILE '+DGROUP1' SIZE 10M;: v: n' a0 L6 s% E/ `
Database altered.
9 ]# q; n! m/ A9 A2 r SQL> ALTER DATABASE DROP LOGFILE GROUP 1;
5 Q7 n# O7 W- M" W+ t Database altered.% h3 U3 Z. E( k
SQL> ALTER SYSTEM SWITCH LOGFILE;3 q: @% G8 Z9 q+ r. V
System altered.# i0 N) t* I+ J8 n2 i! ]
SQL> ALTER SYSTEM SWITCH LOGFILE;
; O% f. ^3 H9 C System altered.( u* ]* o/ b6 ?9 e y
SQL> SQL> ALTER DATABASE DROP LOGFILE GROUP 2;7 [6 j) L, J9 W7 R. T
ALTER DATABASE DROP LOGFILE GROUP 2# s ~0 I- Z4 B0 N% H& L
, E2 B# n, F+ B3 Y; ~ * |