Oracle基礎 05 聯機日誌 redolog

--兩個相關檢視
v$log
v$logfile

alter system switch logfile;  --強制日誌切換
alter system checkpoint;      --強制檢查點

--新增日誌組
alter database add logfile group 4 ('/u01/app/oracle/oradata/dbtest/redo04a.log',
'/u01/app/oracle/redofile/redo04b.log') size 50M;

--刪除日誌組
alter database drop logfile group 4;

--新增日誌成員
alter database add logfile member
'/u01/app/oracle/redofile/redo01b.log' to group 1;

alter system switch logfile;   --使新增的成員可用

--刪除日誌成員
alter database drop logfile member
'/u01/app/oracle/redofile/redolog4c.log';

-- 移動日誌成員(mount下)
alter database rename file '/u01/app/oracle/redofile/redolog5a.log',
'/u01/app/oracle/redofile/redolog5b.log' to
'/u01/app/oracle/oradata/dbtest/redolog5a.log','/u01/app/oracle/oradata/dbtest/redolog5b.log';
alter database open;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/27633655/viewspace-1080313/，如需轉載，請註明出處，否則將追究法律責任。