Root Reserved Pages概述

  Root dbspace的primary chunk的前12页是系统保留页。从第2页开始,页成对分组以相互支持;它们会交替更新,以防止不完整的更新破坏关键恢复数据。Root Reserved Pages是数据库的核心组成部分,它包含了数据库系统的元数据和关键信息。以下是有关这些保留页的一些信息:

Page zero
  第0页包含了SinoDB版权和版本信息,最小页面大小以及系统创建的日期和时间。这是一个重要的信息页,通常包含数据库引擎的版本和创建日期。

Configuration page
  第1页包含了服务器上次联机时存储在系统配置文件中的信息的副本。这些信息来自数据库配置文件(通常是$INFORMIXDIR/etc/$ONCONFIG),它们对于数据库的运行非常关键。

Checkpoint/logical log pages
  第2页和第3页是检查点/逻辑日志页。当前检查点/逻辑日志页面提供最后一个检查点的位置、日期和时间,以及每个逻辑日志的位置和当前状态。

Dbspace pages
  第4页和第5页是关于dbspace(数据库空间)的页面。当前dbspace页面上的每个条目都跟踪dbspace的状态、位置、数据和创建时间。

Primary chunk pages
  第6页和第7页是关于主数据块的页面。它们包含了有关服务器上每个主块的信息,包括区块路径名、大小、偏移量和状态等信息。

Mirror chunk pages
  第8页和第9页是镜像块页。这些页的结构与主块页相同。

Archive pages
  第10页和第11页(0xa和0xb)是归档页。这些页面包含有关在服务器上执行的最新存档的信息。

  使用oncheck -pr命令可以查看这些保留页的信息。这对于数据库管理员和运维人员来说是非常有用的,因为它们包含了关键的数据库配置和状态信息,可以帮助监视数据库的健康和性能。

  以下是oncheck -pr一个用于查看这些保留页信息的例子:

[sinodbms@node31 ~]$ oncheck -pr
Validating Sinoregal SinoDB Dynamic Server reserved pages

Validating PAGE_PZERO...

Identity                       Sinoregal SinoDB Dynamic
                                Server Copyright 2001,
                               2023  Sinoregal Corporat
Database system state          0
Database system flags          0x9
    64-bit server                 
    BigChunk page flags are not in use
Page Size                      2048 (b)
Date/Time created              09/17/2023 22:59:21
Version number of creator      29
UID of rootdbs creator         1001
Index Page Logging             OFF
HA Disk Owner                  <null>

Validating PAGE_CONFIG...

ROOTNAME                       rootdbs  
ROOTPATH                       /home/sinodbms/chunks/rootdbs  
ROOTOFFSET                     0 (k)
ROOTSIZE                       300000 (k)
MIRROR                         0  
MIRRORPATH                     /home/sinodbms/tmp/demo_on.root_mirror  
MIRROROFFSET                   0 (k)
DBSERVERNAME                   sinodb0918  
SERVERNUM                      18  
MSGPATH                        /home/sinodbms/tmp/online.log  
TAPEDEV                        /dev/null  
TAPESIZE                       0 (k)
TAPEBLK                        32 (k)
LTAPEDEV                       /dev/null  
LTAPESIZE                      0 (k)
LTAPEBLK                       32 (k)
PHYSFILE                       50000 (k)
PHYSBUFF                       128 (k)
LOGFILES                       6  
LOGSIZE                        10000 (k)
LOGBUFF                        64 (k)
DYNAMIC_LOGS                   2  
LTXHWM                         70 (%)
LTXEHWM                        80 (%)
RESIDENT                       0  
CLEANERS                       8  
SHMBASE                        0x44000000  
CKPTINTVL                      300 (s)
DBSPACETEMP                      
PLOG_OVERFLOW_PATH             /home/sinodbms/tmp  
BTSCANNER                      num=1,threshold=5000,rangesize=-1,alice=6,compression=med  
RTO_SERVER_RESTART             0 (s)
RAS_PLOG_SPEED                 25000  
RAS_LLOG_SPEED                 0  
AUTO_TUNE_SERVER_SIZE          OFF  
AUTO_LLOG                      0  
AUTO_LRU_TUNING                1  
AUTO_CKPTS                     1  
AUTO_AIOVPS                    1  
BACKUP_FILTER                    
RESTORE_FILTER                   
STORAGE_FULL_ALARM             600,3  
CONVERSION_GUARD               2  
RESTORE_POINT_DIR              /home/sinodbms/tmp  
SP_AUTOEXPAND                  1  
SP_THRESHOLD                   0  
FULL_DISK_INIT                 0  
AUTO_READAHEAD                 1,128  
UNSECURE_ONSTAT                0  
DISK_ENCRYPTION                  
SHMVIRTSIZE                    32656 (k)
STACKSIZE                      64 (k)
SHMADD                         8192  
SHMTOTAL                       0 (k)
ALARMPROGRAM                   /home/sinodbms/etc/alarmprogram.sh  
VP_MEMORY_CACHE_KB             0  
LOW_MEMORY_RESERVE             0  
LOW_MEMORY_MGR                 0  
SBSPACENAME                      
SYSSBSPACENAME                   
SBSPACETEMP                      
DS_MAX_QUERIES                 2  
DS_TOTAL_MEMORY                512  
DS_MAX_SCANS                   1048576  
OPTCOMPIND                     2  
MAX_PDQPRIORITY                100  
DIRECTIVES                     1  
OPT_GOAL                       -1  
AUTO_REPREPARE                 1  
JVPLOGFILE                     /home/sinodbms/tmp/jvp.log  
ENCRYPT_CIPHERS                  
ENCRYPT_MAC                    medium  
ENCRYPT_CDR                    0  
ENCRYPT_HDR                    0  
ENCRYPT_SWITCH                   
ENCRYPT_SMX                    0  
CONSOLE                        /home/sinodbms/tmp/online.con  
DEADLOCK_TIMEOUT               60 (s)
LOCKS                          20000  
ONDBSPACEDOWN                  2  
TXTIMEOUT                      300 (s)
RA_PAGES                         
FILLFACTOR                     90 (%)
OFF_RECVRY_THREADS             10  
ON_RECVRY_THREADS              1  
DATASKIP                       off  
HETERO_COMMIT                  0  
SYSALARMPROGRAM                /home/sinodbms/etc/evidence.sh  

Validating PAGE_1CKPT & PAGE_2CKPT...
      Using check point page PAGE_1CKPT.

Time stamp of checkpoint       0x2da2ad
Time of checkpoint             10/12/2023 23:19:18
Physical log begin address     1:263
Physical log size              25000 (p)
Physical log position at Ckpt  8514
Logical log unique identifier  31
Logical log position at Ckpt   0xf60018 (Page 3936, byte 24)
Checkpoint Interval            3055
DBspace descriptor page        1:4
Chunk descriptor page          1:7
Mirror chunk descriptor page   1:8

Log file number                1
Unique identifier              31
Log contains last checkpoint:  Page 3936, byte 24
Log file flags                 0x3        Log file in use
&                                         Current log file
Physical location              1:25263
Log size                       5000 (p)
Number pages used              3937
Date/Time file filled          -
Time stamp                     -

Log file number                2
Unique identifier              26
Log file flags                 0x5        Log file in use
&                                         Log file has been backed up
Physical location              1:30263
Log size                       5000 (p)
Number pages used              5000
Date/Time file filled          10/08/2023 01:11:01
Time stamp                     0x25f988

Log file number                3
Unique identifier              27
Log file flags                 0x5        Log file in use
&                                         Log file has been backed up
Physical location              1:35263
Log size                       5000 (p)
Number pages used              5000
Date/Time file filled          10/09/2023 01:00:00
Time stamp                     0x27541a

Log file number                4
Unique identifier              28
Log file flags                 0x5        Log file in use
&                                         Log file has been backed up
Physical location              1:40263
Log size                       5000 (p)
Number pages used              5000
Date/Time file filled          10/10/2023 01:00:00
Time stamp                     0x28fb15

Log file number                5
Unique identifier              29
Log file flags                 0x5        Log file in use
&                                         Log file has been backed up
Physical location              1:45263
Log size                       5000 (p)
Number pages used              5000
Date/Time file filled          10/11/2023 01:00:00
Time stamp                     0x2aa1f0

Log file number                6
Unique identifier              30
Log file flags                 0x5        Log file in use
&                                         Log file has been backed up
Physical location              1:50263
Log size                       5000 (p)
Number pages used              5000
Date/Time file filled          10/12/2023 01:00:01
Time stamp                     0x2c4875

Validating PAGE_1DBSP & PAGE_2DBSP...
      Using DBspace page PAGE_1DBSP.

DBspace number                 1
DBspace name                   rootdbs
Flags                          0x1        No mirror chunks
Number of chunks               1
First chunk                    1
Date/Time created              09/17/2023 22:59:21
Partition table page number    14
Logical Log Unique Id          0
Logical Log Position           0x0
Oldest Logical Log Unique Id   31
Last Logical Log Unique Id     0
Expand Size (Chunk Create)     10.0%
Expand size (Chunk Extend)     10000k
DBspace archive status         No archives have occurred.


Validating PAGE_1PCHUNK & PAGE_2PCHUNK...
      Using primary chunk page PAGE_2PCHUNK.

Chunk number                   1
Flags                          0x20040    Chunk is online
Chunk path                     /home/sinodbms/chunks/rootdbs
Chunk offset                   0 (p)
Chunk size                     150000 (p)
Number of free pages           79205
DBspace number                 1

Validating PAGE_1ARCH & PAGE_2ARCH...
      Using archive page PAGE_1ARCH.

No archives have occurred.


DR has not been initialized.