Oracle DBA命令参考——alter database

上一篇 / 下一篇  2010-03-17 16:57:51 / 个人分类：技术

alter database：修改数据文件ITPUB个人空间 dN"vNu#A2Ef
alter database datafile 4 offline;
Y
l:a
G
y_Q7h9ql,h0alter database datafile '/opt/oracle/datafile/users01.dbf' offline;
!oO9Sw$Al/Cs(H0alter database datafile '/opt/oracle/datafile/users01.dbf' resize 100M;
5VcCEqs y)d0alter database datafile '/opt/oracle/datafile/users01.dbf' autoextend on next 100M maxsize 1000M;
8okS,A{[1AG0alter database datafile 4 end backup;

alter database：修改临时文件（tempfile）ITPUB个人空间yD6u!C
H
alter database tempfile 4 resize 100M;ITPUB个人空间gghyU"G
alter database tempfile 4 autoextend on next 100M maxsize 1000M;ITPUB个人空间&z.H-t p~a#X.B
alter database tempfile 4 drop including datafiles;ITPUB个人空间lT/W!m'dY#g
alter database tempfile 4 offline;

alter database：归档日志（archivelog）模式命令
_1]k#m-z-A0alter database archivelog;ITPUB个人空间%peb*M.b`
alter database noarchivelog;ITPUB个人空间P&xvc"gH
~4j wY
alter database force logging;ITPUB个人空间8U e9XSG X
alter database clear logfile '/opt/oracle/logfiles/redo01.rdo';
rl^Xgoi!|0alter database clear unarchived logfile '/opt/oracle/logfiles/redo01.rdo';ITPUB个人空间-t \p7r/E$_(_
alter database add supplemental log data;ITPUB个人空间Ga#S;D8N*k1p
alter database add supplemental log data (primary key,unique);ITPUB个人空间&nI!TOhXL U
alter database drop supplemental log data;

alter database：控制文件操作
(QN Y} }1co*g B0alter database backup controlfile to trace;
J