Welcome to here my friends who are interesting on Oracle Tech,we enhanced our ability of oracle tech through communication together. I share my experience referred to testing, actual case and ideas of studying. All articles of the space is only my point of view, <<Version3.0-Oracle Database 10g-Administration Workshop I>> <<Version3.0-Oracle Database 10g-Administration Workshop II>> <<Oracle Data Integrator Administration and Development>> <<深入浅出...

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

上一篇 / 下一篇  2008-08-15 13:38:12

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.
V e$h8z,~m0Database dismounted.ITPUB个人空间'}R_i+R
ORACLE instance shut down.ITPUB个人空间A-^M!x Ufb
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-szG5l
  ) SIZE 5M,ITPUB个人空间`:tO!G&g&T*N
  GROUP 3 (
6G6UZ2}b/^0    '/oradata/test/redo03.log',
jd2g-b6bG i0    '/oradata/test/redo03b.log'
h/}3e9[*\(pK%lS0  ) SIZE 5M,
Y@+QhJ5gCv0  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{} R n
  '/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)VT8z p0         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&?8b F2On0/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!zret0------- --------- ---------- --------- ----------
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 A9Q Vv,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


TAG:

heming96的个人空间 引用 删除 heming96   /   2008-08-22 10:53:29
oracle 就是有这个问题 rman恢复数据库的时候,如果有readonly 表空间也会出这种问题
 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

Open Toolbar