Oracle DBA命令參考——alter database

alter database：修改資料檔案
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：修改臨時檔案（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;

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;

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';

alter database：建立資料檔案
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;

alter database：資料檔案離線/聯機
參見“alter database：修改資料庫檔案”

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';

alter database：安裝和開啟資料庫
alter database mount;
alter database open;

alter database：移動或重新命名資料庫檔案或聯機重做日誌
注意：資料庫必須已經安裝才能重新命名或移動聯機重做日誌。資料庫必須已經安裝或資料檔案處於離線狀態時，才能移動資料庫中的資料檔案。
alter database rename file '/ora/datafile/oldfile.dbf' to '/ora/datafile/newfile.dbf';

alter database：以只讀方式開啟資料庫
alter database open read only;

alter database：使用resetlogs開啟資料
alter database open resetlogs;

alter database：恢復資料庫
對資料庫的恢復，建議使用recover命令代替。