redo文件管理.docxVIP

redo文件管理1. 查看数据库版本　SQL select * from v$version;　BANNER　---------------------------------　/ \t _blankOracle Database 11g Enterprise Edition Release .0 - Production　PL/SQL Release .0 - Production　CORE.0Production　TNS for Linux: Version .0 - Production　NLSRTL Version .0 - Production　2. 查看重做日志文件　SQL select * from v$logfile;　GROUP# STATUS TYPE MEMBER IS_　---------- ------- ------- ------------------ ---　3 ONLINE /home/oracle/app/oracle/oradata/orcl/redo03.log NO　2 ONLINE /home/oracle/app/oracle/oradata/orcl/redo02.log NO　1 ONLINE /home/oracle/app/oracle/oradata/orcl/redo01.log NO　3. 查看重做日志组信息　SQL select group#,bytes,members from v$log;　GROUP#BYTES MEMBERS　---------- ---------- ----------　1??????? 1　2??????? 1　3??????? 1　4. 查看重做日志和重做日志组状态　SQL select a.group#,a.member,b.status,b.bytes　from v$logfile a,v$log b　where a.group#=b.group#;　GROUP# MEMBER STATUS BYTES　---------- -------------------------- ---------------- ----------　3 /home/oracle/app/oracle/oradata/orcl/redo03.log CURRENT2 /home/oracle/app/oracle/oradata/orcl/redo02.log INACTIVE1 /home/oracle/app/oracle/oradata/orcl/redo01.log INACTIVE4. 添加重做日志组　每个重做日志组可以添加一个或者多个重做日志文件　语法：　alter database add logfile group 组序号（文件名1,文件名2,……文件n） size 文件大小；　SQL alter database add logfile group 4（/home/oracle/app/oracle/oradata/orcl/redo04_01.log,　/home/oracle/app/oracle/oradata/orcl/redo04_02.log） size 100M;　SQL select a.group#,a.member,b.bytes/1024/1024 M,b.status　from v$logfile a,v$log b　where a.group#=b.group#;　GROUP# MEMBER M STATUS　---------- -------------------------- ---------- ----------------　3 /home/oracle/app/oracle/oradata/orcl/redo03.log 50 CURRENT　2 /home/oracle/app/oracle/oradata/orcl/redo02.log 50 INACTIVE　1 /home/oracle/app/oracle/oradata/orcl/redo01.log 50 INACTIVE　4 /home/oracle/app/oracle/oradata/orcl/redo04_01.log 100 UNUSED　4 /home/oracle/app/oracle/oradata/orcl/redo04_02.log 100 UNUSED　绿色标记：刚创建的重做日志文件名称，大小，状态。其中文件名为redo04_01.log和red04_02.log,文件大小100M,