Oracle数据库可以运行在2种模式下:归档模式(archivelog)和非归档模式(noarchivelog) 归档模式可以提高Oracle数据库的可恢复性,出产数据库都应该运行在此模式下,归档模式应该和响应的备份策略相连系,只有归档模式没有响应的备份策略只会带来麻烦。. e6 T- b8 ~# w/ K
本文简单介绍若何启用和封锁数据库的归档模式。1 O' z2 e# [& `/ ~! t% F6 i: E
1.shutdown normal或shutdown immediate封锁数据库 0 ~: `7 W1 M d# ?3 B
[oracle@jumper oracle]$ sqlplus "/ as sysdba"% ^( K) D2 Q0 w) V9 w3 N
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Oct 15 15:48:36 2005
* V, O5 t8 w0 K$ V9 k9 h Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
2 b/ d! @& y. A. z Connected to:
$ ^! K7 G; J- M: u Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production' Y- B3 H; X5 ^' s
With the Partitioning option
0 u# Q) q% q- i6 C7 } JServer Release 9.2.0.4.0 - Production* n7 n* p) e& T% k# d* K" E
SQL> shutdown immediate;
) ?, k6 P n( D4 K Database closed.: d, Z% j* D9 H7 }. T& H
Database dismounted.
* P5 \& f) `4 O3 g- |- x: T U, p ORACLE instance shut down., l( ^, D) [9 e2 g
2.启动数据库到mount状况 - y. w; D6 |# Q) G! R& s) O* \
SQL> startup mount;" U' K; R, Y; r/ a
ORACLE instance started.
& l! A* ~: T( [+ ^" }% B! L7 f; K Total System Global Area 101782828 bytes
- [3 c+ }3 }4 X: d. m; @3 I Fixed Size 451884 bytes
: F: }9 `' G: q' R- Z Variable Size 37748736 bytes+ a- y: h# E! F" j: \' p
Database Buffers 62914560 bytes
: Y( O) w6 v% q; Y Redo Buffers 667648 bytes
3 R" ], d# R9 ~ P) i7 b Database mounted.
' q0 _3 A2 m1 n+ ~9 `3.启用或遏制归档模式
$ M5 w9 M' v( b% k! c/ W C$ ] 如不美观要启用归档模式,此处使用: D6 y) e. ]7 U2 R
alter database archivelog 呼吁。5 I( L' p" W" u& g$ g4 X% z0 S
SQL> alter database archivelog;9 Y5 J" C% n3 E8 i7 y l2 A9 }; e
Database altered.0 ?. E# P" A4 d
SQL> alter database open;# }% W8 G7 R7 m w }9 \" q
0 P. J ?; L: c. w Database altered. |