1 alter database：修改數(shù)據(jù)文件
alter database datafile 4 offline;
alter database datafile '/opt/oracle/datafile/users01.dbf' offline;
alter database datafile '/opt/oracle/datafile/users01.dbf' resize 100M;
alter database datafile '/opt/oracle/datafile/users01.dbf' autoextend on next 100M maxsize 1000M;
alter database datafile 4 end backup;
alter database tablesapce sysaux add datafile ‘/opt/oracle/oradate/ora11g/sysaux02.dbf’ size 500M;
2 alter database：修改臨時(shí)文件（tempfile）
alter database tempfile 4 resize 100M;
alter database tempfile 4 autoextend on next 100M maxsize 1000M;
alter database tempfile 4 drop including datafiles;
alter database tempfile 4 offline;
3 alter database：歸檔日志（archivelog）模式命令
alter database archivelog;
alter database noarchivelog;
alter database force logging;
alter database clear logfile '/opt/oracle/logfiles/redo01.rdo';
alter database clear unarchived logfile '/opt/oracle/logfiles/redo01.rdo';
alter database add supplemental log data;
alter database add supplemental log data (primary key,unique);
alter database drop supplemental log data;
4 alter database：控制文件操作
alter database backup controlfile to trace;
alter database backup controlfile to trace as '/opt/oracle/logfile_backup/backup_logfile.trc' reuse resetlogs;
alter database backup controlfile to '/opt/oracle/logfile_backup/backup_logfile.ctl';
5 alter database：創(chuàng)建數(shù)據(jù)文件
alter database create datafile '/opt/oracle/datafile/users01.dbf' as '/opt/oracle/datafile/users01.dbf';
alter database create datafile 4 as '/opt/oracle/datafile/users01.dbf';
alter database create datafile '/opt/oracle/datafile/users01.dbf' as new;
6 alter database：日志文件命令
alter database add logfile group 2 ('/opt/oracle/logfiles/redo02a.rdo','/opt/oracle/logfile/redo02b.rdo') size 300M reuse;
alter database add logfile member '/opt/oracle/logfiles/redo02c.rdo' to gourp 2
alter database add logfile thread 3 group 2 ('/opt/oracle/logfiles/redo02a.rdo','/opt/oracle/logfiles/redo02b.rdo') size 300M reuse;
alter database drop logfile group 3
alter database drop logfile member '/opt/oracle/logfiles/redo02b.rdo';
7 alter database：安裝和打開(kāi)數(shù)據(jù)庫(kù)
alter database mount;
alter database open;
8 alter database：移動(dòng)或重命名數(shù)據(jù)庫(kù)文件或聯(lián)機(jī)重做日志
注意：數(shù)據(jù)庫(kù)必須已經(jīng)安裝才能重命名或移動(dòng)聯(lián)機(jī)重做日志。數(shù)據(jù)庫(kù)必須已經(jīng)安裝或數(shù)據(jù)文件處于脫機(jī)狀態(tài)時(shí)，才能移動(dòng)數(shù)據(jù)庫(kù)中的數(shù)據(jù)文件。
alter database rename file '/ora/datafile/oldfile.dbf' to '/ora/datafile/newfile.dbf';
9 alter database：以只讀方式打開(kāi)數(shù)據(jù)庫(kù)
alter database open read only;
10 alter database：使用resetlogs打開(kāi)數(shù)據(jù)
alter database open resetlogs;
11 alter database：恢復(fù)數(shù)據(jù)庫(kù)
對(duì)數(shù)據(jù)庫(kù)的恢復(fù)，建議使用recover命令代替。

?

轉(zhuǎn)載于:https://www.cnblogs.com/freshbreeze/archive/2013/05/31/3111071.html

總結(jié)

以上是生活随笔為你收集整理的Oracle命令--alter 操作的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。