重建控制文件之后，只读表空间的状态变化

SQL> alter tablespace staging read only;

SQL> alter database backup controlfile to trace;

Database altered.

SQL> shutdown immediate;ITPUB个人空间
B]gT Vdic5]h8x,{
Database closed.
Ve$h8z,~m0Database dismounted.ITPUB个人空间'}R_i+R
ORACLE instance shut down.ITPUB个人空间A-^M!xUfb
SQL> startup nomount;
_(T6]2u x5i2Hh0ORACLE instance started.

Total System Global Area  167772160 bytes
M-^y;gZ.xH#UY0Fixed Size                  1218316 bytesITPUB个人空间|b#w)^,s
Variable Size              79694068 bytesITPUB个人空间5Le?])?G|1h
Database Buffers           83886080 bytesITPUB个人空间Y.`k \,v1u s0cGB
Redo Buffers                2973696 bytes

d0[%KiMM%f8sUgH T0SQL> CREATE CONTROLFILE REUSE DATABASE "TEST" NORESETLOGS  ARCHIVELOGITPUB个人空间2P.k%o.?:m8T1|i
    MAXLOGFILES 16
} rv XDHR0    MAXLOGMEMBERS 3
&bvo8c1o2JT ~0    MAXDATAFILES 100ITPUB个人空间uR7?G}VfF
    MAXINSTANCES 8ITPUB个人空间noG{;as,mzU
    MAXLOGHISTORY 292ITPUB个人空间`X.xqtI ?q4X
LOGFILE
Vp!Vh~Q0O$b|0  GROUP 1 (
EY#P&C0BpV0    '/oradata/test/redo01.log',ITPUB个人空间Y(`0ZZoBe
    '/oradata/test/redo01b.log'ITPUB个人空间,{!`8s![)T|
  ) SIZE 5M,ITPUB个人空间Wvc:r@7ey:X
  GROUP 2 (
V|'b%H4i[gvO0    '/oradata/test/redo02.log',ITPUB个人空间Bv{#Q \8q
    '/oradata/test/redo02b.log'ITPUB个人空间RFd-s
zG5l
  ) SIZE 5M,ITPUB个人空间`:tO!G&g&T*N
  GROUP 3 (
6G6UZ2}b/^0    '/oradata/test/redo03.log',
jd2g-b6bGi0    '/oradata/test/redo03b.log'
h/}3e9[*\(pK%lS0  ) SIZE 5M,
Y@+Qh
J5gCv0  GROUP 4 '/oradata/test/redo04.log'  SIZE 10MITPUB个人空间V7T.\5X${A8JA3s
-- STANDBY LOGFILEITPUB个人空间k;|qCt
DATAFILE
Z \Xk m$cs0  '/oradata/test/system01.dbf',ITPUB个人空间d)m\Mui
  '/oradata/test/undotbs01.dbf',ITPUB个人空间_'z4K c i}d#|h
  '/oradata/test/sysaux01.dbf',ITPUB个人空间gzra{} Rn
  '/oradata/test/users01.dbf',
)WA2nc~qFg0  '/oradata/test/ecc_view.dbf'ITPUB个人空间.P$nk\|(e%T+ZzZ'y
CHARACTER SET ZHS16GBKITPUB个人空间zPrvCb9En ymb
;ITPUB个人空间_Z.E8_(Wd
Control file created.

SQL>  select status, last_time, file#, CHECKPOINT_TIME, ENABLED from v$datafile;ITPUB个人空间;fui8\}ui)K
STATUS  LAST_TIME      FILE# CHECKPOIN ENABLEDITPUB个人空间_,xtN-c9oO C
------- --------- ---------- --------- ----------
)R9kjB(oU)y1K'[0SYSTEM  10-APR-08          1 10-APR-08 DISABLEDITPUB个人空间s lS Wxi
ONLINE  10-APR-08          2 10-APR-08 DISABLED
pL{E#]$b8p0ONLINE  10-APR-08          3 10-APR-08 DISABLED
f7XA]4p+KnS0ONLINE  10-APR-08          4 10-APR-08 DISABLED
!_o%HDt,Kz)T'Z0ONLINE  10-APR-08          5 10-APR-08 DISABLED

SQL> alter database open;

Database altered.

SQL>  select status, last_time, file#, CHECKPOINT_TIME, ENABLED from v$datafile;ITPUB个人空间2J9NcEG-s
STATUS  LAST_TIME      FILE# CHECKPOIN ENABLED
:}%K)I&_
u?&@6~ t.}
k0------- --------- ---------- --------- ----------
nxKvG;]0SYSTEM                     1 10-APR-08 READ WRITE
)O%tM1|.kv0ONLINE                     2 10-APR-08 READ WRITEITPUB个人空间K EtR,[%Lq7}
ONLINE                     3 10-APR-08 READ WRITE
#^^CPy@(j`0ONLINE                     4 10-APR-08 READ WRITEITPUB个人空间4h^'y,v}9NM*T8\
ONLINE                     5 10-APR-08 READ WRITEITPUB个人空间1\
WgK`2h&~i'M
OFFLINE 10-APR-08          6           READ ONLY

SQL> select file_id, file_name from dba_data_files;ITPUB个人空间/_2e!M4wbQ4nA)c-V
   FILE_ID FILE_NAMEITPUB个人空间DtJ/x
`[]Ff
---------- ---------------------------------------------------------------------         5 /oradata/test/ecc_view.dbfITPUB个人空间8e Q'i2s1rMr8~1R
         4 /oradata/test/users01.dbf
qY` F^Q)VT8zp0         3 /oradata/test/sysaux01.dbf
%Yu7Z!V5b6Y3Z0         2 /oradata/test/undotbs01.dbf
^}-@6kmF0         1 /oradata/test/system01.dbf
a!@%mm.vO0         6 /home/oracle/oracle/product/10.2.0/db_1/dbs/MISSING00006

6 rows selected.

--注意：在/home/oracle/oracle/product/10.2.0/db_1/dbs/下是没有MISSING00006这个文件存在的ITPUB个人空间j3wug7Jr"S.n:q
SQL> select file_name from dba_data_files;

FILE_NAMEITPUB个人空间:r!Y C E1b-X
--------------------------------------------------------------------------------/oradata/test/ecc_view.dbf
+b)M:q F"x&?8bF2On0/oradata/test/users01.dbfITPUB个人空间 E m n(n(Z Km
/oradata/test/sysaux01.dbfITPUB个人空间jJ)\EClm'F8z
/oradata/test/undotbs01.dbfITPUB个人空间"|tc@*~u Ua
/oradata/test/system01.dbf
P#I+~5S5I5t0/home/oracle/oracle/product/10.2.0/db_1/dbs/MISSING00006

6 rows selected.

SQL> alter database rename file 'MISSING00006' to '/oradata/test/staging.dbf';

Database altered.

SQL> select file_id, file_name from dba_data_files;

   FILE_ID FILE_NAMEITPUB个人空间,P j0X j]-Z3I
---------- ---------------------------------------------------------------------         5 /oradata/test/ecc_view.dbfITPUB个人空间
f0Ryv$u+^9So1j+e3~e
         4 /oradata/test/users01.dbf
!Rn6iM:YW&tsC0N0         3 /oradata/test/sysaux01.dbfITPUB个人空间6G3cq;Y7u"g-Z+k
         2 /oradata/test/undotbs01.dbf
Z8ct~rhi8s0         1 /oradata/test/system01.dbfITPUB个人空间9\ q7E.j$e$\)Sbg'Y
         6 /oradata/test/staging.dbf

6 rows selected.ITPUB个人空间3`X K#Vb/o&`T/a
SQL>  select status, last_time, file#, CHECKPOINT_TIME, ENABLED from v$datafile;
_KP {!Snux7d{0STATUS  LAST_TIME      FILE# CHECKPOIN ENABLED
"dw2g-Q:@\1p!zr
et0------- --------- ---------- --------- ----------
l i5hQ1|!bA4X$]hh0SYSTEM                     1 10-APR-08 READ WRITE
Z*US a\V0ONLINE                     2 10-APR-08 READ WRITEITPUB个人空间{+x-E,Wk8ff2u#Lir
ONLINE                     3 10-APR-08 READ WRITEITPUB个人空间kP8e [){5Y#O
ONLINE                     4 10-APR-08 READ WRITEITPUB个人空间i%h2fLU%aM{1_?M
ONLINE                     5 10-APR-08 READ WRITEITPUB个人空间6\ ^+o&U@b!|FLQ
OFFLINE 10-APR-08          6           READ ONLY

6 rows selected.

SQL> alter tablespace staging online;

Tablespace altered.

SQL> select status, last_time, file#, CHECKPOINT_TIME, ENABLED from v$datafile;

STATUS  LAST_TIME                FILE# CHECKPOINT_TIME     ENABLEDITPUB个人空间%yqR@^\d
------- ------------------- ---------- ------------------- ----------ITPUB个人空间]7Rn:u J4Hx
SYSTEM                               1 2008-04-10 15:37:18 READ WRITEITPUB个人空间UV Jk(k'X0@I.?
ONLINE                               2 2008-04-10 15:37:18 READ WRITE
[:bG{2s"Yi7Vj,L0ONLINE                               3 2008-04-10 15:37:18 READ WRITEITPUB个人空间M7wma|'p7i2l6Bs([eY
ONLINE                               4 2008-04-10 15:37:18 READ WRITE
g7r{,G&}#^,w0ONLINE                               5 2008-04-10 15:37:18 READ WRITE
)u9}&M~7p0ONLINE  2008-04-10 15:20:30          6                     READ ONLY

6 rows selected.

SQL> alter tablespace staging read write;

Tablespace altered.

SQL>  select status, last_time, file#, CHECKPOINT_TIME, ENABLED from v$datafile;
*t1D0x+YcC,u0STATUS  LAST_TIME                FILE# CHECKPOINT_TIME     ENABLEDITPUB个人空间s2A*daTfq
------- ------------------- ---------- ------------------- ----------
%rnH/Q9S4{0SYSTEM                               1 2008-04-10 16:06:20 READ WRITE
"Y'_d$x!`0ONLINE                               2 2008-04-10 16:06:20 READ WRITE
D5N A9QVv,m.c*C0ONLINE                               3 2008-04-10 16:06:20 READ WRITE
7uD&U5m(rw"H0ONLINE                               4 2008-04-10 16:06:20 READ WRITE
"dD1c$n.H0ONLINE                               5 2008-04-10 16:06:20 READ WRITEITPUB个人空间0UMw4z+{
ONLINE                               6 2008-04-10 16:10:51 READ WRITE

6 rows selected.
,N ?VFG@!N1MWj/g0