</p> RMAN> SWITCH DATAFILE 6 TO COPY;) U$ S. g/ ^% z8 W) ~- V/ x* x
datafile 6 switched to datafile copy "+DGROUP1/toasm/datafile/users.265.683431079"
# a4 k1 b& @& C6 [7 }" P4 N( S RMAN> SQL 'ALTER DATABASE DATAFILE 6 ONLINE';
% m& m& p; }/ k$ F B; ~ RMAN> RECOVER DATAFILE 6;
1 ]6 Q# D8 J) l6 G2 ~/ Z Starting recover at 06-APR-09
a4 Q+ U$ s2 V% W. V, E! ` U) w using channel ORA_DISK_1
, m% S. O; r9 i starting media recovery
) |, z/ n, g4 L' E# G4 u9 A5 u$ |, x media recovery complete, elapsed time: 00:00:01
& Z" t% [. h6 } Finished recover at 06-APR-09! d( h8 Q& X" P. W ]
RMAN> SQL 'ALTER DATABASE DATAFILE 6 ONLINE';
3 Y+ i0 m Z8 h Y# {/ _5 R7 x sql statement: ALTER DATABASE DATAFILE 6 ONLINE4 x4 j! a1 X! V: Q; H$ Q! z; n
RMAN> REPORT SCHEMA;6 H: e% @1 Y3 x$ L% ~
Report of database schema
# a7 {5 M# w6 S, R List of Permanent Datafiles# Q0 }$ S7 U3 c! |9 h$ c
===========================
4 B- j7 O9 o9 a! n# O' F# j File Size(MB) Tablespace RB segs Datafile Name8 a/ }8 f* Y, Y9 d
---- -------- -------------------- ------- ------------------------
& `2 p; b: U- D" k* h 1 480 SYSTEM *** +DGROUP1/toasm/datafile/system.258.6834283377 H+ n @1 W6 V; \
2 25 UNDOTBS1 *** +DGROUP1/toasm/datafile/undotbs1.260.683428483* L9 W9 ?1 d# g; \5 g
3 230 SYSAUX *** +DGROUP1/toasm/datafile/sysaux.259.6834284218 g& S. u2 L8 m1 h9 \
4 5 USERS *** +DGROUP1/toasm/datafile/users.262.683428489
1 C- Q( H/ T& |. k, E! `) h 5 100 EXAMPLE *** +DGROUP1/toasm/datafile/example.261.683428467
, c, q/ U% `" Q4 y ] 6 10 USERS *** +DGROUP1/toasm/datafile/users.265.683431079
: U6 t6 M. j9 g: p% R7 A List of Temporary Files- j7 K, g8 W3 c" p/ A) E" f; {
=======================" {9 M* @& b. V2 N
File Size(MB) Tablespace Maxsize(MB) Tempfile Name* r: x+ N. V! x
---- -------- -------------------- ----------- --------------------$ H2 W+ f! K# o3 o; j: I
2 100 TEMP 32767 +DGROUP1/toasm/tempfile/temp.263.683428909, {# v& T ]( [( e& b
RMAN> |