redo logfile_standby redo logfile used 512-CSDN博客

本文链接：https://blog.csdn.net/shanshuizhizun/article/details/9060861

1 add logfile group

1.1 添加日志文件组，组号系统自动生成

alter database add logfile('/u01/app/oracle/oradata/db01/redo041.log','/u01/app/oracle/oradata/db01/redo042.log')
size 100M blocksize 512;

1.2 添加日志文件组，指定组号

alter database add logfile group 5 ('/u01/app/oracle/oradata/db01/redo051.log','/u01/app/oracle/oradata/db01/redo052.log')
size 50M blocksize 512;

2 add logfile member

ALTER DATABASE ADD LOGFILE MEMBER '/u01/app/oracle/oradata/db01/redo053.log' TO GROUP 5;

3 重命名日志文件
3.1 SHUTDOWN
3.2 mv /u01/app/oracle/oradata/db01/redo051.log /u01/app/oracle/oradata/db01/redo053.log
3.3
CONNECT / as SYSDBA
STARTUP MOUNT
3.4
ALTER DATABASE 
  RENAME FILE '/u01/app/oracle/oradata/db01/redo051.log' to '/u01/app/oracle/oradata/db01/redo053.log'
3.5 ALTER DATABASE OPEN;

4 drop logfile group

ALTER DATABASE DROP LOGFILE GROUP 5;
5 drop logfile member
ALTER DATABASE DROP LOGFILE MEMBER '/u01/app/oracle/oradata/db01/redo043.log';

6 switch logfile
ALTER SYSTEM SWITCH LOGFILE;
--status
SELECT * FROM v$log;