v$log 中group#的使用原則,

來源:互聯網
上載者:User

v$log 中group#的使用原則,
本文是原創文章,轉載請註明出處:

當前的group#是4,5,6SQL> select group#,status from v$log;    GROUP# STATUS---------- ----------------         4 INACTIVE         5 CURRENT         6 INACTIVE然後執行了下列語句:ALTER DATABASE ADD LOGFILE ('/arch/redo/redo7.log') size 1024M;ALTER DATABASE ADD LOGFILE ('/arch/redo/redo8.log') size 1024M;ALTER DATABASE ADD LOGFILE ('/arch/redo/redo9.log') size 1024M;ALTER DATABASE ADD LOGFILE ('/arch/redo/redo10.log') size 1024M;ALTER DATABASE ADD LOGFILE ('/arch/redo/redo11.log') size 1024M;ALTER DATABASE ADD LOGFILE ('/arch/redo/redo12.log') size 1024M;然後:SQL> select group#,status from v$log;    GROUP# STATUS---------- ----------------         1 UNUSED         2 UNUSED         3 UNUSED         4 INACTIVE         5 CURRENT         6 INACTIVE         7 UNUSED         8 UNUSED         9 UNUSEDredo 組 添加時, group#的使用原則就是 從1開始,有空著的group#就選擇(就複用)另外請注意,group#是 db層級的id號,不是 instance層級的id號。這一點跟datafile 的管理是不同的:datafile的 號是不重用的。

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.