大佬教程收集整理的这篇文章主要介绍了Oracle Database 联机日志文件管理,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
sql> SELEct group#,SEQUENCE#,members,bytes,archived from v$log; GROUP# SEQUENCE# MEMBERS BYTES Status arCHIVED ---------- ---------- ---------- ---------- --------- --------- 1 4 1 52428800 INACTIVE YES 2 5 1 52428800 INACTIVE YES 3 6 1 52428800 CURRENT NO
sql> alter database drop logfile group 1; sql> host rR_470_11845@ -rf /u01/app/Oracle/oradata/king/redo01.log sql> alter database add logfile group 1 ('/u01/app/Oracle/oradata/king/redo01a.log','/u01/app/Oracle/oradata/king/redo01b.log') size 50M;
sql> alter database drop logfile group 2; sql> host rR_470_11845@ -rf /u01/app/Oracle/oradata/king/redo02.log sql> alter database add logfile group 2 ('/u01/app/Oracle/oradata/king/redo02a.log','/u01/app/Oracle/oradata/king/redo02b.log') size 50M;
sql> alter system switch logfile; sql> alter system checkpoint;
sql> alter database drop logfile group 3; sql> host rR_470_11845@ -rf /u01/app/Oracle/oradata/king/redo03.log sql> alter database add logfile group 3 ('/u01/app/Oracle/oradata/king/redo03a.log','/u01/app/Oracle/oradata/king/redo03b.log') size 50M;
sql> SELEct group#,member from v$logfile; GROUP# Status TS Type MEMBER ---------- --------- --------------- -------------------------------------------------- 3 ONliNE /u01/app/Oracle/oradata/king/redo03a.log 2 ONliNE /u01/app/Oracle/oradata/king/redo02a.log 1 ONliNE /u01/app/Oracle/oradata/king/redo01a.log 1 ONliNE /u01/app/Oracle/oradata/king/redo01b.log 2 ONliNE /u01/app/Oracle/oradata/king/redo02b.log 3 ONliNE /u01/app/Oracle/oradata/king/redo03b.log
sql> SELEct group#,archived from v$log; GROUP# SEQUENCE# MEMBERS BYTES Status arCHIVED ---------- ---------- ---------- ---------- --------- --------- 1 7 2 52428800 CURRENT NO 2 0 2 52428800 UNUSED YES 3 0 2 52428800 UNUSED YES
以上是大佬教程为你收集整理的Oracle Database 联机日志文件管理全部内容,希望文章能够帮你解决Oracle Database 联机日志文件管理所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。