redo logfile

来源：互联网发布：开淘宝店卖虚拟产品编辑：程序博客网时间：2024/05/21 17:04

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