Oracle11g redo log 创建、添加、删除（重做日志组，重做日志文件）

时间：2022-11-09 11:55:59浏览次数：67

标签：log dagl app oradata oracle 日志 u01 重做

select group#, sequence#, members, bytes, status, archived from v$log;
select group#, status, type, member from v$logfile;
添加redo组
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo04a.log','/u01/app/oracle/oradata/dagl/redo04b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo05a.log','/u01/app/oracle/oradata/dagl/redo05b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo06a.log','/u01/app/oracle/oradata/dagl/redo06b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo07a.log','/u01/app/oracle/oradata/dagl/redo07b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo08a.log','/u01/app/oracle/oradata/dagl/redo08b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo09a.log','/u01/app/oracle/oradata/dagl/redo09b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo01a.log','/u01/app/oracle/oradata/dagl/redo01b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo02a.log','/u01/app/oracle/oradata/dagl/redo02b.log') size 500M;
alter database add logfile ('/u01/app/oracle/oradata/dagl/redo03a.log','/u01/app/oracle/oradata/dagl/redo03b.log') size 500M;

alter database add logfile member '/u01/app/oracle/oradata/dagl/redo04b.log' to group 4;

删除redo logfile
alter database drop logfile member'/u01/app/oracle/oradata/orcl/redo09b.log';
删除redo log
alter database drop logfile group 2;

标签：log,dagl,app,oradata,oracle,日志,u01,重做
From： https://www.cnblogs.com/102x/p/16873141.html

shell: logging
#!/bin/bash#asmalltoolforloggingsommething##1.readyourinput#2.savetologsfile>>~/logs/$(date+%F)#logDir='2-logs'read-p"好记性不如......
tempdb日志文件暴增分析
背景某医院信息科接到CIS系统磁盘空间不足告警，通过排查发现tempdb的日志文件暴增，已经涨到了130G左右，并且还在持续增长中。需要我们紧急排查原因。现象登陆到服务器里，确......
018.MyBatis日志管理
1.SLF4j与Logback 2.自定义使用logback日志2.1 pom.xml<dependency><groupId>ch.qos.logback</groupId><artifactId>log......
spdlog日志库源码：sinks系列类
目录sinks系列类简介特点sinks继承体系sink类sink类声明日志等级阈值sink子类null_sink类模板base_sink类模板basic_file_sink类模板文件工具类file_helperdaily_file_sink......
logrotate机制与原理
日志实在是太有用了，它记录了程序运行时各种信息。通过日志可以分析用户行为，记录运行轨迹，查找程序问题。可惜磁盘的空间是有限的，就像飞机里的黑匣子，记录的信息再重要也只能记......
mysql 5.7安装及使用binlog日志恢复数据库
目录mysql5.7安装及使用binlog日志恢复数据库binlog日志介绍安装mysql5.7开启Binlog日志查看binlog日志状态和内容通过Binlog恢复数据清理MySQL的binlog日志自动删除手动......
日志根据业务和等级拆分
日志根据业务和等级拆分1导入依赖<dependencyManagement><dependencies><dependency><groupId>org.apache.logging.log4j</g......
k8s+log-pilot日志收集
github地址：https://github.com/AliyunContainerService/log-pilot介绍log-pilot是一个很棒的docker日志工具。可以从dockerlog-pilot主机收集日志并将它们发送到您的......
SpringBoot日志
SpringBoot使用的slf4j+logback：官网文档：https://docs.spring.io/spring-boot/docs/current/reference/html/features.html#features.logging.shutdown-hook日志输......
AccessLog日志配置
server.tomcat.accesslog.prefix=accessserver.tomcat.accesslog.suffix=.logserver.tomcat.accesslog.file-date-format=-yyyyMMddHH 有的时候我们要使用日志......

Oracle11g redo log 创建、添加、删除（重做日志组，重做日志文件）

相关文章

赞助商

阅读排行