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

SQL> alter tablespace staging read only;

SQL> alter database backup controlfile to trace;

Database altered.

SQL> shutdown immediate;ITPUB个人空间!mMN Zp;Z4h%b
Database closed.ITPUB个人空间D"l J'X-A1?#_F0v+M
Database dismounted.
#U&Vxm'SG/HS`m0ORACLE instance shut down.ITPUB个人空间POiEA.x ~(Y[
SQL> startup nomount;ITPUB个人空间 i
^a7[0BbIX3Wqt
ORACLE instance started.

Total System Global Area  167772160 bytes
Gtp:~q&QI6Z/I0Fixed Size                  1218316 bytes
+XRfp[FS0Variable Size              79694068 bytesITPUB个人空间y1D)l6Y:J
Database Buffers           83886080 bytesITPUB个人空间/G7q.J;M9`)J({xl
Redo Buffers                2973696 bytes

ITPUB个人空间2GOmV$nQ
SQL> CREATE CONTROLFILE REUSE DATABASE "TEST" NORESETLOGS  ARCHIVELOG
1]|0`&]A"j$?7]0    MAXLOGFILES 16
7Zt8He Wo0    MAXLOGMEMBERS 3
2bWcDB-_P4tz0    MAXDATAFILES 100ITPUB个人空间D#D+F-ck(s8m4n aYg
    MAXINSTANCES 8
We5`\1pJ0    MAXLOGHISTORY 292ITPUB个人空间"J_xBq
LOGFILEITPUB个人空间A.ndhJS
  GROUP 1 (
8o#LUyI7]0    '/oradata/test/redo01.log',ITPUB个人空间HOQ,wM {3^
    '/oradata/test/redo01b.log'ITPUB个人空间3l7Cb&d&QQ2v
  ) SIZE 5M,
p X1bfkE\/\0q?ht0  GROUP 2 (
$k1x`:F7o&w{&K[0    '/oradata/test/redo02.log',
U ~
jc5W S;i0    '/oradata/test/redo02b.log'
8N \/YvR0  ) SIZE 5M,
/X4J1s5Q NhB'YNKp0  GROUP 3 (ITPUB个人空间.nh0o7RA
    '/oradata/test/redo03.log',ITPUB个人空间)]fm9Z w `3C@
    '/oradata/test/redo03b.log'ITPUB个人空间{u`[g3I)R3w
  ) SIZE 5M,ITPUB个人空间;[P\5rhO9c q%bB
  GROUP 4 '/oradata/test/redo04.log'  SIZE 10M
QQ/V5K!s/km0-- STANDBY LOGFILEITPUB个人空间I!~7{G#^9t'^r
DATAFILEITPUB个人空间Q!i2{E q
Vf5z"T`rs'N
  '/oradata/test/system01.dbf',
5@r%`WF\
Jv ^4T0  '/oradata/test/undotbs01.dbf',
$jsAP f0  '/oradata/test/sysaux01.dbf',
9g6WlzA d^0  '/oradata/test/users01.dbf',
@
I0{5w'Qo,ak/U^Mdq0  '/oradata/test/ecc_view.dbf'
G(G#WC e0CHARACTER SET ZHS16GBK
1LHj1[ vT\ K_ f0;
$Ue.x
wH5Y.s0Control file created.

SQL>  select status, last_time, file#, CHECKPOINT_TIME, ENABLED from v$datafile;ITPUB个人空间F:K1RA5d{
STATUS  LAST_TIME      FILE# CHECKPOIN ENABLED
p'j+t5MJ3o*u!e0------- --------- ---------- --------- ----------ITPUB个人空间@-])ysN8Z%gB
SYSTEM  10-APR-08          1 10-APR-08 DISABLEDITPUB个人空间L(f7uuU)I!O^8k e
ONLINE  10-APR-08          2 10-APR-08 DISABLED
lZO {)cdY@0ONLINE  10-APR-08          3 10-APR-08 DISABLEDITPUB个人空间e%[I_v%u
ONLINE  10-APR-08          4 10-APR-08 DISABLEDITPUB个人空间#U(]@2bf2p4if
ONLINE  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;
FEpBP.C
H+w9[z9Lp0STATUS  LAST_TIME      FILE# CHECKPOIN ENABLEDITPUB个人空间/@6l-q\5W0Cs,o0T Dx
------- --------- ---------- --------- ----------ITPUB个人空间F5b3ETija5H
SYSTEM                     1 10-APR-08 READ WRITEITPUB个人空间w!_fwY~
ONLINE                     2 10-APR-08 READ WRITEITPUB个人空间!sb9H7E7q*G:Ai
ONLINE                     3 10-APR-08 READ WRITEITPUB个人空间{ QNI4r1K0vw
ONLINE                     4 10-APR-08 READ WRITEITPUB个人空间*mYrz2ZZ2m
ONLINE                     5 10-APR-08 READ WRITEITPUB个人空间F&w'vE"~8V&Zj's
OFFLINE 10-APR-08          6           READ ONLY

SQL> select file_id, file_name from dba_data_files;ITPUB个人空间f0G7hT@
   FILE_ID FILE_NAMEITPUB个人空间I5F^tB;F
---------- ---------------------------------------------------------------------         5 /oradata/test/ecc_view.dbf
w4U"{$O,Scm0         4 /oradata/test/users01.dbfITPUB个人空间$jkwG bf|.a,g;j` S
         3 /oradata/test/sysaux01.dbfITPUB个人空间0y]9a(YG_7@p%V/q
         2 /oradata/test/undotbs01.dbf
4?!lG \z"|0         1 /oradata/test/system01.dbfITPUB个人空间v{ Q0? s.j9AxDp%T
         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个人空间z/XSi;C@"{6\,t1Jl
SQL> select file_name from dba_data_files;

FILE_NAME
7i/b ~j!l0--------------------------------------------------------------------------------/oradata/test/ecc_view.dbfITPUB个人空间_l ?dg]Tr@
/oradata/test/users01.dbf
0pMh[3y.fa0/oradata/test/sysaux01.dbf
PK:V*Efo-[W;^D0/oradata/test/undotbs01.dbf
!B W ^z2s9A-R0/oradata/test/system01.dbf
,~%IGM#~#rTu.l0i0/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_NAME
r:F,Z)izYB@0---------- ---------------------------------------------------------------------         5 /oradata/test/ecc_view.dbfITPUB个人空间0f"M.XUD(D!?'WD1M
         4 /oradata/test/users01.dbf
L `%X`u-}6x&r0         3 /oradata/test/sysaux01.dbf
i.o1H4Ca){m$b0         2 /oradata/test/undotbs01.dbf
X b5FI@N0         1 /oradata/test/system01.dbf
pC$YJ9k1B%M.s"z&D0         6 /oradata/test/staging.dbf

6 rows selected.ITPUB个人空间 dB8LD4Y?
SQL>  select status, last_time, file#, CHECKPOINT_TIME, ENABLED from v$datafile;ITPUB个人空间fFSU%v
STATUS  LAST_TIME      FILE# CHECKPOIN ENABLED
chR Mk#MNN%h0------- --------- ---------- --------- ----------
;H3O1]u$W/K'x ~Yp0SYSTEM                     1 10-APR-08 READ WRITE
"j-V)l4N#AnAk3`+p4Y0ONLINE                     2 10-APR-08 READ WRITEITPUB个人空间A.C z8g2d/i:G Ur
ONLINE                     3 10-APR-08 READ WRITE
+h#Lp'_Mg1aUO&I0ONLINE                     4 10-APR-08 READ WRITEITPUB个人空间'Ts/@x|$d
ONLINE                     5 10-APR-08 READ WRITE
4rB#a wF6D7Z}f0OFFLINE 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个人空间*msC%tE#?
------- ------------------- ---------- ------------------- ----------
RE0y$TY(cb-yNl0SYSTEM                               1 2008-04-10 15:37:18 READ WRITEITPUB个人空间8Tu'p,B+Wm
ONLINE                               2 2008-04-10 15:37:18 READ WRITEITPUB个人空间o pN
LQj4U+b
ONLINE                               3 2008-04-10 15:37:18 READ WRITE
j5NVh {hJr9]0ONLINE                               4 2008-04-10 15:37:18 READ WRITE
w9f%Gl!pd0ONLINE                               5 2008-04-10 15:37:18 READ WRITEITPUB个人空间/iMiz0j`h+e?
ONLINE  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;ITPUB个人空间#yNTn5l.MS3g
STATUS  LAST_TIME                FILE# CHECKPOINT_TIME     ENABLED

z{mc3W*}(t)C.]r#n0------- ------------------- ---------- ------------------- ----------
/E2^3z N{5H*wi4Uw0SYSTEM                               1 2008-04-10 16:06:20 READ WRITEITPUB个人空间2i Y ]'Cf \}
ONLINE                               2 2008-04-10 16:06:20 READ WRITE
._*m}$@Z(B0ONLINE                               3 2008-04-10 16:06:20 READ WRITEITPUB个人空间+Nvo)Rv
ONLINE                               4 2008-04-10 16:06:20 READ WRITE
:beP!mG.e d{0ONLINE                               5 2008-04-10 16:06:20 READ WRITE
D[Wv%C0q I0ONLINE                               6 2008-04-10 16:10:51 READ WRITE

6 rows selected.
q-k
M"d"}uZj4F0