ORACLE 加大記錄檔

標籤：size   作業系統   eset   system   控制檔案   ada   控制   lte   rac   

--建立臨時記錄檔
alter database add logfile group 4 (‘/u01/app/oracle/oradata/orcl/redo04.log‘) size 10m;
alter database add logfile group 5 (‘/u01/app/oracle/oradata/orcl/redo05.log‘) size 10m;
alter database add logfile group 6 (‘/u01/app/oracle/oradata/orcl/redo06.log‘) size 100m;
--切換記錄檔
alter system switch logfile;
alter system switch logfile;
--刪除舊檔案
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
--作業系統刪掉1,2,3
--建立3個
alter database add logfile group 1 (‘/u01/app/oracle/oradata/orcl/redo01.log‘) size 200m;
alter database add logfile group 2 (‘/u01/app/oracle/oradata/orcl/redo02.log‘) size 200m;
alter database add logfile group 3 (‘/u01/app/oracle/oradata/orcl/redo03.log‘) size 200m;
--切換記錄檔
alter system switch logfile;
alter system switch logfile;
--刪舊日誌組
alter database drop logfile group 4;
--作業系統刪掉4，5
--備份控制檔案
SQL> connect / as sysdba

SQL> alter database backup controlfile to trace resetlogs

ORACLE 加大記錄檔