1.查詢系統使用的是哪一組日誌文件：SELECT * FROM V$LOG; 2.查詢正在使用的組所對應的日誌文件：SELECT * FROM V$LOGFILE; 3.強制日誌切換：ALTER SYSTEM SWITCH LOGFILE; 4.查詢歷史日誌：SELECT * FROM V$LOG_ ...
1.查詢系統使用的是哪一組日誌文件：
SELECT * FROM V$LOG;
2.查詢正在使用的組所對應的日誌文件：
SELECT * FROM V$LOGFILE;
3.強制日誌切換：
ALTER SYSTEM SWITCH LOGFILE;
4.查詢歷史日誌：
SELECT * FROM V$LOG_HISTORY;
5.查詢日誌的歸檔模式：
SELECT DBID,NAME,CREATED,LOG_MODE FROM V$DATABASE;
6.查詢歸檔日誌的信息：
SELECT RECID,STAMP,THREAD#,SEQUENCE#,NAME FROM V$ARCHIVED_LOG;
7.增加與刪除日誌文件組
ALTER DATABASE ADD LOGFILE GROUP 1 ('/home1/Oracle/oradata/ora8i/log1a.log'),'/home2/oracle/oradata/ora8i/log1b.log') SIZE 100M;
ALTER DATABASE DROP LOGFILE GROUP 1;
8.增加與刪除日誌成員
ALTER DATABASE ADD LOGFILE MEMBER '/home1/oracle/oradata/ora8i/log1a.log' TO GROUP 1,'/home1/oracle/oradata/ora8i/log2a.log' TO GROUP 2;
ALTER DATABASE DROP LOGFILE MEMBER '/home1/oracle/oradata/ora8i/log1a.log' ;
9.日誌文件移動
ALTER DATABASE RENAME FILE '/home1/oracle/oradata/ora8i/log1a.log' TO '/home2/oracle/oradata/ora8i/log1a.log';
執行該命令之前必須保證該日誌文件物理上已經移動到新目錄
10.清除日誌文件
ALTER DATABASE CLEAR LOGFILE '/home1/oracle/oradata/ora8i/log1a.log';
該命令用於不能用刪除組及組成員命令刪除日誌時使用
8.查看歸檔日誌占用空間：
SELECT SPACE_LIMIT/1024/1024/1024 AS "Quota_G",SPACE_USED/1024/1024 AS "Used_M",SPACE_USED/SPACE_LIMIT*100 "Used_%",SPACE_RECLAIMABLE AS RECLAIMABLE,NUMBER_OF_FILES AS FILES FROM V$RECOVERY_FILE_DEST ;
9.修改歸檔日誌空間大小
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=40G;
10.查看歸檔日誌列表
RMAN> LIST ARCHIVELOG ALL;
刪除歸檔日誌
RMAN> DELETE ARCHIVELOG UNTIL TIME 'sysdate-1' ;
雙機下也可以用
DELETE OBSOLETE;
CROSSCHECK ARCHIVELOG ALL;
DELETE EXPIRED ARCHIVELOG ALL;
11. 用LIST EXPIRED看看是否有失效的ARCHIVE LOG,證明沒有失效的ARCHIVE LOG:
RMAN> LIST EXPIRED ARCHIVELOG ALL;
