yum install dstat tree lsof
[root@localhost ~]# mkdir /opt/software
[root@localhost ~]# mv GaussDB_100_1.0.1-CLUSTER-REDHAT7.5-64bit.tar.gz /opt/software/
[root@localhost ~]#
groupadd dbgrp
useradd -g dbgrp -d /home/omm -m -s /bin/bash omm
passwd omm
mkdir -p /opt/software/gaussdb
cd /opt/software/gaussdb
[root@localhost gaussdb]# ll /opt/software/gaussdb/GaussDB_100_1.0.1-DATABASE-REDHAT-64bit.tar.gz
-rwx------. 1 root root 8038086 Feb 14 06:42 /opt/software/gaussdb/GaussDB_100_1.0.1-DATABASE-REDHAT-64bit.tar.gz
/opt/software/gaussdb/GaussDB_100_1.0.1-DATABASE-REDHAT-64bit
python install.py -U omm:dbgrp -R /opt/gaussdb/app -D /opt/gaussdb/data -C LSNR_ADDR=127.0.0.1,192.168.18.128 -C LSNR_PORT=1888
[root@localhost GaussDB_100_1.0.1-DATABASE-REDHAT-64bit]# python install.py -U omm:dbgrp -R /opt/gaussdb/app -D /opt/gaussdb/data -C LSNR_ADDR=127.0.0.1,192.168.18.128 -C LSNR_PORT=1888
Checking runner.
Checking parameters.
End check parameters.
Checking user.
End check user.
Checking old install.
End check old install.
Checking kernel parameters.
Checking directory.
Checking integrality of run file...
Decompressing run file.
Setting user env.
Checking data dir and config file
Initialize db instance.
Creating database.
Creating database succeed.
Changing file permission due to security audit.
Install successfully, for more detail information see /home/omm/zengineinstall.log.
[root@localhost GaussDB_100_1.0.1-DATABASE-REDHAT-64bit]#
[root@localhost ~]# cat /home/omm/zengineinstall.log
[2020-02-14 06:47:22] Begin init...
[2020-02-14 06:47:22] Installer runs on python version : 2.7.5
[2020-02-14 06:47:22] End init
[2020-02-14 06:47:23] Using run file as : /opt/software/gaussdb/GaussDB_100_1.0.1-DATABASE-REDHAT-64bit/GaussDB_100_1.0.1-RUN-REDHAT-64bit.tar.gz
[2020-02-14 06:47:23] Checking runner.
[2020-02-14 06:47:23] Check runner user id and group id is : 0, 0
[2020-02-14 06:47:23] End check runner is root
[2020-02-14 06:47:23] Checking parameters.
[2020-02-14 06:47:23] Program path is separated with data path!
[2020-02-14 06:47:23] Using omm:dbgrp to install database
[2020-02-14 06:47:23] Using install program path : /opt/gaussdb/app
[2020-02-14 06:47:23] Using option : all
[2020-02-14 06:47:23] Using install data path : /opt/gaussdb/data
[2020-02-14 06:47:23] Using set config parameters : ['LSNR_ADDR=127.0.0.1,192.168.18.128', 'LSNR_PORT=1888']
[2020-02-14 06:47:23] End check parameters.
[2020-02-14 06:47:23] Checking user.
[2020-02-14 06:47:23] Check user cmd: id -g omm | grep -q -w 0
[2020-02-14 06:47:23] Check user cmd: id -gn omm
[2020-02-14 06:47:23] End check user.
[2020-02-14 06:47:23] Checking old install.
[2020-02-14 06:47:23] Using user profile : /home/omm/.bashrc
[2020-02-14 06:47:23] End check old install.
[2020-02-14 06:47:23] Checking kernel parameters.
[2020-02-14 06:47:27] End check kernel parameters
[2020-02-14 06:47:27] Checking directory.
[2020-02-14 06:47:27] Preparing path [/opt/gaussdb/app].
[2020-02-14 06:47:27] Path [/opt/gaussdb/app] does not exist. Please create it.
[2020-02-14 06:47:27] cmd path chown -R omm:dbgrp /opt/gaussdb; chmod -R 700 /opt/gaussdb
[2020-02-14 06:47:27] check [/opt/gaussdb/app] user permission
[2020-02-14 06:47:27] Preparing path [/opt/gaussdb/data].
[2020-02-14 06:47:27] Path [/opt/gaussdb/data] does not exist. Please create it.
[2020-02-14 06:47:27] cmd path chown omm:dbgrp /opt/gaussdb/data; chmod 700 /opt/gaussdb/data
[2020-02-14 06:47:27] check [/opt/gaussdb/data] user permission
[2020-02-14 06:47:27] Database program install path available size: 47726M
[2020-02-14 06:47:27] The partition of path "/opt/gaussdb/app": Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rhel-root 48G 1.2G 47G 3% /
[2020-02-14 06:47:27] The partition of path "/opt/gaussdb/data": Filesystem Size Used Avail Use% Mounted on
/dev/mapper/rhel-root 48G 1.2G 47G 3% /
[2020-02-14 06:47:27] Database data directory available size: 47726M
[2020-02-14 06:47:27] End check dir.
[2020-02-14 06:47:27] Checking integrality of run file...
[2020-02-14 06:47:27] Check integrality of bin file ok
[2020-02-14 06:47:27] End check integrality of bin file
[2020-02-14 06:47:27] Decompressing run file.
[2020-02-14 06:47:27] decompress bin file executable cmd: chmod 700 "/opt/software/gaussdb/GaussDB_100_1.0.1-DATABASE-REDHAT-64bit/GaussDB_100_1.0.1-RUN-REDHAT-64bit.tar.gz"
[2020-02-14 06:47:27] Decompress cmd: tar -xvf "/opt/software/gaussdb/GaussDB_100_1.0.1-DATABASE-REDHAT-64bit/GaussDB_100_1.0.1-RUN-REDHAT-64bit.tar.gz" -C "/opt/gaussdb/app" && cp -rf /opt/gaussdb/app/GaussDB_100_1.0.1-RUN-REDHAT-64bit/add-ons /opt/gaussdb/app/GaussDB_100_1.0.1-RUN-REDHAT-64bit/admin /opt/gaussdb/app/GaussDB_100_1.0.1-RUN-REDHAT-64bit/bin /opt/gaussdb/app/GaussDB_100_1.0.1-RUN-REDHAT-64bit/cfg /opt/gaussdb/app/GaussDB_100_1.0.1-RUN-REDHAT-64bit/lib /opt/gaussdb/app/GaussDB_100_1.0.1-RUN-REDHAT-64bit/package.xml /opt/gaussdb/app && rm -rf /opt/gaussdb/app/GaussDB_100_1.0.1-RUN-REDHAT-64bit
[2020-02-14 06:47:27] /opt/gaussdb/app/admin/scripts/sql_dialect/ora-dialect.sql file exists in package /opt/software/gaussdb/GaussDB_100_1.0.1-DATABASE-REDHAT-64bit/GaussDB_100_1.0.1-RUN-REDHAT-64bit.tar.gz
[2020-02-14 06:47:27] Successfully Install zenith application
[2020-02-14 06:47:27] Change app permission cmd: chmod 700 /opt/gaussdb/app -R&& find '/opt/gaussdb/app'/add-ons -type f | xargs chmod 500 && find '/opt/gaussdb/app'/admin -type f | xargs chmod 600 && find '/opt/gaussdb/app'/lib -type f | xargs chmod 500&& find '/opt/gaussdb/app'/bin -type f | xargs chmod 500 && chmod 400 '/opt/gaussdb/app'/package.xml
[2020-02-14 06:47:27] Change owner cmd: chown omm:dbgrp -R /opt/gaussdb/app
[2020-02-14 06:47:27] End decompress bin file.
[2020-02-14 06:47:27] Setting user env.
[2020-02-14 06:47:27] End set user env.
[2020-02-14 06:47:27] Change privilege cmd: chmod 700 /opt/gaussdb/data/ -R
[2020-02-14 06:47:27] Change owner cmd: chown omm:dbgrp -R "/opt/gaussdb/data"
[2020-02-14 06:47:27] Initialize db instance.
[2020-02-14 06:47:27] config Parameters is empty, so just return.
[2020-02-14 06:47:27] Successfully Initialize zenith instance.
[2020-02-14 06:47:27] Creating database.
[2020-02-14 06:47:30] Instance start log output:starting instance(nomount)
instance started
.
[2020-02-14 06:47:30] start instance successfully, pid = 11242
[2020-02-14 06:47:30] create zenith database ...
[2020-02-14 06:48:38] Execute sql file /opt/gaussdb/app/admin/scripts/create_database.sample.sql output:
connected.
SQL>
Succeed.
SQL>
[2020-02-14 06:48:38] Creating database succeed.
[2020-02-14 06:48:38] Changing file permission due to security audit.
[2020-02-14 06:48:39] Successfully install zenith instance.
[2020-02-14 06:48:39] Install successfully, for more detail information see /home/omm/zengineinstall.log.
[root@localhost ~]# top
top - 06:47:48 up 44 min, 4 users, load average: 0.30, 0.08, 0.07
Tasks: 184 total, 2 running, 182 sleeping, 0 stopped, 0 zombie
%Cpu(s): 1.5 us, 56.6 sy, 0.0 ni, 41.4 id, 0.5 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 7992336 total, 2753428 free, 464172 used, 4774736 buff/cache
KiB Swap: 8257532 total, 8257532 free, 0 used. 7173648 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11242 omm 20 0 4882276 280904 4768 R 101.0 3.5 0:17.58 zengine
11320 root 20 0 116088 2420 1424 S 4.0 0.0 0:00.04 dhclient-script
772 dbus 20 0 66392 2620 1896 S 1.0 0.0 0:00.17 dbus-daemon
774 root 20 0 21668 1280 972 S 1.0 0.0 0:00.56 irqbalance
11319 root 20 0 162096 2388 1576 R 1.0 0.0 0:00.06 top
查看目录
[root@localhost gaussdb]# tree
.
├── app
│?? ├── add-ons
│?? │?? ├── liblz4.so -> liblz4.so.1.8.3
│?? │?? ├── liblz4.so.1 -> liblz4.so.1.8.3
│?? │?? ├── liblz4.so.1.8.3
│?? │?? ├── libpcre.so -> libpcre.so.1.2.10
│?? │?? ├── libpcre.so.1 -> libpcre.so.1.2.10
│?? │?? ├── libpcre.so.1.2.10
│?? │?? ├── libuuid.so -> libuuid.so.1.0.0
│?? │?? ├── libuuid.so.1.0.0
│?? │?? ├── libz.so -> libz.so.1.2.11
│?? │?? ├── libz.so.1 -> libz.so.1.2.11
│?? │?? ├── libz.so.1.2.11
│?? │?? ├── libzstd.so -> libzstd.so.1.3.8
│?? │?? ├── libzstd.so.1 -> libzstd.so.1.3.8
│?? │?? └── libzstd.so.1.3.8
│?? ├── admin
│?? │?? └── scripts
│?? │?? ├── add_standby_log.sample.sql
│?? │?? ├── create_database.sample.sql
│?? │?? ├── initdb.sql
│?? │?? ├── initplsql.sql
│?? │?? ├── initview.sql
│?? │?? ├── initwsr.sql
│?? │?? ├── readme.md
│?? │?? ├── sql_dialect
│?? │?? │?? └── ora-dialect.sql
│?? │?? └── upgrade
│?? │?? ├── degrade_whitelist
│?? │?? ├── initdb_01.sql
│?? │?? ├── SYS_AUDIT_degrade_1.sql
│?? │?? ├── SYS_AUDIT_upgrade_1.sql
│?? │?? ├── SYS_DIRECTORIES_degrade_1.sql
│?? │?? ├── SYS_DIRECTORIES_upgrade_1.sql
│?? │?? ├── SYS_DISTRIBUTE_RULES_degrade_2.sql
│?? │?? ├── SYS_DISTRIBUTE_RULES_upgrade_2.sql
│?? │?? ├── SYS_EXTERNAL_TABLES_degrade_2.sql
│?? │?? ├── SYS_EXTERNAL_TABLES_upgrade_2.sql
│?? │?? ├── SYS_HISTGRAM_ABSTR_degrade_2.sql
│?? │?? ├── SYS_HISTGRAM_ABSTR_degrade_3.sql
│?? │?? ├── SYS_HISTGRAM_ABSTR_upgrade_2.sql
│?? │?? ├── SYS_HISTGRAM_ABSTR_upgrade_3.sql
│?? │?? ├── SYS_HISTGRAM_degrade_2.sql
│?? │?? ├── SYS_HISTGRAM_upgrade_2.sql
│?? │?? ├── SYS_INDEX_PARTS_degrade_2.sql
│?? │?? ├── SYS_INDEX_PARTS_upgrade_2.sql
│?? │?? ├── SYS_PART_OBJECTS_degrade_2.sql
│?? │?? ├── SYS_PART_OBJECTS_upgrade_2.sql
│?? │?? ├── SYS_PENDING_DIST_TRANS_degrade_2.sql
│?? │?? ├── SYS_PENDING_DIST_TRANS_upgrade_2.sql
│?? │?? ├── SYS_PENDING_TRANS_degrade_2.sql
│?? │?? ├── SYS_PENDING_TRANS_upgrade_2.sql
│?? │?? ├── SYS_REBALANCE_TASK_degrade_1.sql
│?? │?? ├── SYS_REBALANCE_TASK_degrade_2.sql
│?? │?? ├── SYS_REBALANCE_TASK_upgrade_1.sql
│?? │?? ├── SYS_REBALANCE_TASK_upgrade_2.sql
│?? │?? ├── SYS_RSRC_CONTROL_GROUPS_degrade_1.sql
│?? │?? ├── SYS_RSRC_CONTROL_GROUPS_upgrade_1.sql
│?? │?? ├── SYS_RSRC_GROUP_MAPPINGS_degrade_1.sql
│?? │?? ├── SYS_RSRC_GROUP_MAPPINGS_upgrade_1.sql
│?? │?? ├── SYS_RSRC_PLAN_RULES_degrade_1.sql
│?? │?? ├── SYS_RSRC_PLAN_RULES_upgrade_1.sql
│?? │?? ├── SYS_RSRC_PLANS_degrade_1.sql
│?? │?? ├── SYS_RSRC_PLANS_upgrade_1.sql
│?? │?? ├── SYS_SEQUENCES_degrade_2.sql
│?? │?? ├── SYS_SEQUENCES_upgrade_2.sql
│?? │?? ├── SYS_SHADOW_INDEX_PARTS_degrade_2.sql
│?? │?? ├── SYS_SHADOW_INDEX_PARTS_degrade_3.sql
│?? │?? ├── SYS_SHADOW_INDEX_PARTS_upgrade_2.sql
│?? │?? ├── SYS_SHADOW_INDEX_PARTS_upgrade_3.sql
│?? │?? ├── SYS_STORAGE_degrade_1.sql
│?? │?? ├── SYS_STORAGE_upgrade_1.sql
│?? │?? ├── SYS_SUB_INDEX_PARTS_degrade_1.sql
│?? │?? ├── SYS_SUB_INDEX_PARTS_upgrade_1.sql
│?? │?? ├── SYS_SUB_LOB_PARTS_degrade_1.sql
│?? │?? ├── SYS_SUB_LOB_PARTS_upgrade_1.sql
│?? │?? ├── SYS_SUB_PART_COLUMNS_degrade_1.sql
│?? │?? ├── SYS_SUB_PART_COLUMNS_upgrade_1.sql
│?? │?? ├── SYS_SUB_PART_TEMPLATE_degrade_1.sql
│?? │?? ├── SYS_SUB_PART_TEMPLATE_upgrade_1.sql
│?? │?? ├── SYS_SUB_TABLE_PARTS_degrade_1.sql
│?? │?? ├── SYS_SUB_TABLE_PARTS_upgrade_1.sql
│?? │?? ├── SYS_TABLE_PARTS_degrade_2.sql
│?? │?? ├── SYS_TABLE_PARTS_upgrade_2.sql
│?? │?? └── upgrade_whitelist
│?? ├── bin
│?? │?? ├── Common.py
│?? │?? ├── GaussLog.py
│?? │?? ├── shutdowndb.sh
│?? │?? ├── sql_process.py
│?? │?? ├── uninstall.py
│?? │?? ├── zctl.py
│?? │?? ├── zencrypt
│?? │?? ├── zengine
│?? │?? └── zsql
│?? ├── lib
│?? │?? ├── libzeclient.so
│?? │?? ├── libzecommon.so
│?? │?? └── libzeprotocol.so
│?? └── package.xml
└── data
├── archive_log
├── cfg
│?? ├── zengine.ini
│?? ├── zengine.ini_bak
│?? └── zhba.conf
├── data
│?? ├── cntl1
│?? ├── cntl2
│?? ├── cntl3
│?? ├── log1
│?? ├── log2
│?? ├── log3
│?? ├── log4
│?? ├── log5
│?? ├── log6
│?? ├── sysaux
│?? ├── system
│?? ├── temp1_01
│?? ├── temp1_02
│?? ├── temp2_01
│?? ├── temp2_02
│?? ├── temp2_undo
│?? ├── undo
│?? ├── user1
│?? ├── user2
│?? ├── user3
│?? ├── user4
│?? └── user5
├── dbs
│?? ├── zenith_key1
│?? └── zenith_key2
├── log
│?? ├── audit
│?? │?? └── zengine.aud
│?? ├── oper
│?? │?? └── zsql.olog
│?? ├── run
│?? │?? └── zengine.rlog
│?? ├── zenith_alarm.log
│?? └── zenithstatus.log
├── protect
│?? ├── gsdb_uds_emerg.server
│?? ├── kstora.file
│?? ├── kstorb.file
│?? └── priv.bin
├── trc
│?? └── zengine_smon_00003.trc
└── zengine.lck
19 directories, 130 files
[root@localhost scripts]# ll /opt/gaussdb/data/
total 4
drwx------. 2 omm dbgrp 6 Feb 14 06:47 archive_log
drwx------. 2 omm dbgrp 65 Feb 14 06:48 cfg
drwx------. 2 omm dbgrp 4096 Feb 14 06:48 data
drwx------. 2 omm dbgrp 44 Feb 14 06:47 dbs
drwx------. 5 omm dbgrp 90 Feb 14 06:47 log
drwx------. 2 omm dbgrp 89 Feb 14 06:47 protect
drwx------. 2 omm dbgrp 36 Feb 14 06:47 trc
-rw-------. 1 omm dbgrp 0 Feb 14 06:47 zengine.lck
[root@localhost scripts]# ll /opt/gaussdb/data/data/
total 21821440
-rw-------. 1 omm dbgrp 10485760 Feb 14 06:48 cntl1
-rw-------. 1 omm dbgrp 10485760 Feb 14 06:48 cntl2
-rw-------. 1 omm dbgrp 10485760 Feb 14 06:48 cntl3
-rw-------. 1 omm dbgrp 2147483648 Feb 14 06:52 log1
-rw-------. 1 omm dbgrp 2147483648 Feb 14 06:47 log2
-rw-------. 1 omm dbgrp 2147483648 Feb 14 06:48 log3
-rw-------. 1 omm dbgrp 2147483648 Feb 14 06:48 log4
-rw-------. 1 omm dbgrp 2147483648 Feb 14 06:48 log5
-rw-------. 1 omm dbgrp 2147483648 Feb 14 06:48 log6
-rw-------. 1 omm dbgrp 167772160 Feb 14 06:48 sysaux
-rw-------. 1 omm dbgrp 1073741824 Feb 14 06:48 system
-rw-------. 1 omm dbgrp 167772160 Feb 14 06:48 temp1_01
-rw-------. 1 omm dbgrp 167772160 Feb 14 06:48 temp1_02
-rw-------. 1 omm dbgrp 167772160 Feb 14 06:48 temp2_01
-rw-------. 1 omm dbgrp 167772160 Feb 14 06:48 temp2_02
-rw-------. 1 omm dbgrp 1073741824 Feb 14 06:48 temp2_undo
-rw-------. 1 omm dbgrp 1073741824 Feb 14 06:48 undo
-rw-------. 1 omm dbgrp 1073741824 Feb 14 06:48 user1
-rw-------. 1 omm dbgrp 1073741824 Feb 14 06:48 user2
-rw-------. 1 omm dbgrp 1073741824 Feb 14 06:48 user3
-rw-------. 1 omm dbgrp 1073741824 Feb 14 06:48 user4
-rw-------. 1 omm dbgrp 1073741824 Feb 14 06:48 user5
[root@localhost scripts]#
[root@localhost ~]# ps -ef|grep omm
omm 11242 1 18 06:47 ? 00:01:19 /opt/gaussdb/app/bin/zengine nomount -D /opt/gaussdb/data
[root@localhost ~]# su - omm
Last login: Fri Feb 14 06:47:30 CST 2020
[omm@localhost ~]$ cd /opt/gaussdb/app/bin
[omm@localhost bin]$ python zctl.py -t start
Zengine instance has already started.
[omm@localhost bin]$
连接数据库
zsql SYS/Changeme_123@127.0.0.1:1888
SQL> select dbid,NAME,STATUS,OPEN_STATUS,OPEN_COUNT,INIT_TIME,CURRENT_SCN from v$database;
DBID NAME STATUS OPEN_STATUS OPEN_COUNT INIT_TIME CURRENT_SCN
------------ -------------------------------- -------------------- -------------------- ------------ ---------------------- --------------------
68478422 GAUSS OPEN READ WRITE 1 2020-02-14 06:47:31 2355696115713
1 rows fetched.
SQL> select LOG_MODE from v$database;
LOG_MODE
------------------------------
ARCHIVELOG
1 rows fetched.
修改密码
ALTER USER SYS IDENTIFIED BY Root1234 REPLACE Changeme_123;
SQL> ALTER USER SYS IDENTIFIED BY Root1234 REPLACE Changeme_123;
Succeed.
SQL> [omm@localhost bin]$ zsql SYS/Root1234@127.0.0.1:1888
Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.
SQL> select sysdate,'hello enmotech' from dual;
SYSDATE 'HELLO ENMOTECH'
---------------------- ----------------
2020-02-14 07:00:35 hello enmotech
1 rows fetched.
SQL>
SQL> show help;
Show failed.
Usage:
SHOW AUTO[COMMIT]
SHOW EXITC[OMMIT]
SHOW CHARSET
SHOW HEA[DING]
SHOW SERVEROUT[PU]T
SHOW TRIMS[POOL]
SHOW SPOO[L]
SHOW LIN[ESIZE]
SHOW NUM[WIDTH]
SHOW PAGES[IZE]
SHOW TIM[ING]
SHOW FEED[BACK]
SHOW ECHO
SHOW VER[IFY]
SHOW TERM[OUT]
SHOW NEWP[AGE]
SHOW COLSEP
SHOW LONG
SHOW PARAMETER[S] [PARAMETER_NAME]
SHOW DEFINE
SHOW OPLOG
SHOW CONNECT[_TIMEOUT]
SHOW ZSQL_SSL[_MODE|_CA|_CERT|_KEY|_CRL|_KEY_PASSWD|_CIPHER]
SHOW UDS_SERVER_PATH
SHOW UDS_CLIENT_PATH
SHOW BIND
创建备份
su - omm
mkdir -p /home/omm/backup
BACKUP DATABASE FULL FORMAT '/home/omm/backup/backup01.bak';
输出
SQL> BACKUP DATABASE FULL FORMAT '/home/omm/backup/backup01.bak';
Succeed.
[omm@localhost ~]$ ls -lart /home/omm/backup/backup01.bak/
total 466740
drwxr-xr-x. 3 omm dbgrp 26 Feb 14 07:04 ..
-rw-------. 1 omm dbgrp 10485760 Feb 14 07:04 ctrl_0_0.bak
-rw-------. 1 omm dbgrp 13770752 Feb 14 07:04 data_SYSTEM_0_0.bak
-rw-------. 1 omm dbgrp 8192 Feb 14 07:04 data_TEMP_1_0.bak
-rw-------. 1 omm dbgrp 8192 Feb 14 07:04 data_USERS_4_0.bak
-rw-------. 1 omm dbgrp 8192 Feb 14 07:04 data_TEMP2_9_0.bak
-rw-------. 1 omm dbgrp 8192 Feb 14 07:04 data_TEMP2_UNDO_11_0.bak
-rw-------. 1 omm dbgrp 172244992 Feb 14 07:04 data_UNDO_3_1.bak
-rw-------. 1 omm dbgrp 268427264 Feb 14 07:04 data_UNDO_3_0.bak
-rw-------. 1 omm dbgrp 2367488 Feb 14 07:04 data_SYSAUX_12_0.bak
-rw-------. 1 omm dbgrp 10603520 Feb 14 07:04 arch_1_0.bak
-rw-------. 1 omm dbgrp 4424 Feb 14 07:04 backupset
drwx------. 2 omm dbgrp 277 Feb 14 07:04 .
[omm@localhost ~]$
[omm@localhost ~]$ strings /home/omm/backup/backup01.bak/backupset
634979045189370_4160576638977
(/opt/gaussdb/data/data/cntl1, /opt/gaussdb/data/data/cntl2, /opt/gaussdb/data/data/cntl3)
SYSTEM
TEMP
UNDO
UNDO
USERS
TEMP2
TEMP2_UNDO
SYSAUX
查看表空间
SQL> col TABLESPACE_NAME format a20
SQL> select * from dba_tablespaces;
TABLESPACE_NAME PAGE_SIZE EXTENT_PAGES DATAFILE_COUNT TOTAL_SIZE USED_SIZE STATUS IN_MEMORY CONTENTS LOGGING BIGFILE
-------------------- -------------------- ------------ -------------- -------------------- -------------------- -------- --------- --------- ------- -------
SYSTEM 8192 8 1 1073741824 13778944 ONLINE FALSE PERMANENT Y N
TEMP 8192 16 2 335544320 24576 ONLINE FALSE TEMPORARY N N
UNDO 8192 1 1 1073741824 440680448 ONLINE FALSE PERMANENT Y N
USERS 8192 8 5 5368709120 49152 ONLINE FALSE PERMANENT Y N
TEMP2 8192 8 2 335544320 24576 ONLINE FALSE TEMPORARY N N
TEMP2_UNDO 8192 1 1 1073741824 16384 ONLINE FALSE TEMPORARY N N
SYSAUX 8192 8 1 167772160 69517312 ONLINE FALSE PERMANENT Y N
7 rows fetched.
SQL> create table t1(id int) tablespace users ;
Succeed.
SQL> insert into t1 values(1);
1 rows affected.
SQL> commit;
Succeed.
再次累计增量备份
BACKUP DATABASE INCREMENTAL LEVEL 1 CUMULATIVE FORMAT '/home/omm/backup/backup1_incr_cum01.bak'
SQL> BACKUP DATABASE INCREMENTAL LEVEL 1 CUMULATIVE FORMAT '/home/omm/backup/backup1_incr_cum01.bak'
2 ;
GS-00672, No valid base backupset, can not execute incremental backup
解决方法是先做0级别
BACKUP DATABASE INCREMENTAL LEVEL 0 FORMAT '/home/omm/backup/backup1_incr_level0.bak';
SQL> BACKUP DATABASE INCREMENTAL LEVEL 0 FORMAT '/home/omm/backup/backup1_incr_level0.bak';
Succeed.
[omm@localhost ~]$ ll /home/omm/backup/backup1_incr_level0.bak/
total 466904
-rw-------. 1 omm dbgrp 10603520 Feb 14 07:10 arch_1_0.bak
-rw-------. 1 omm dbgrp 101888 Feb 14 07:10 arch_2_0.bak
-rw-------. 1 omm dbgrp 4576 Feb 14 07:10 backupset
-rw-------. 1 omm dbgrp 10485760 Feb 14 07:10 ctrl_0_0.bak
-rw-------. 1 omm dbgrp 2367488 Feb 14 07:10 data_SYSAUX_12_0.bak
-rw-------. 1 omm dbgrp 13770752 Feb 14 07:10 data_SYSTEM_0_0.bak
-rw-------. 1 omm dbgrp 8192 Feb 14 07:10 data_TEMP_1_0.bak
-rw-------. 1 omm dbgrp 8192 Feb 14 07:10 data_TEMP2_9_0.bak
-rw-------. 1 omm dbgrp 8192 Feb 14 07:10 data_TEMP2_UNDO_11_0.bak
-rw-------. 1 omm dbgrp 268427264 Feb 14 07:10 data_UNDO_3_0.bak
-rw-------. 1 omm dbgrp 172244992 Feb 14 07:10 data_UNDO_3_1.bak
-rw-------. 1 omm dbgrp 73728 Feb 14 07:10 data_USERS_4_0.bak
在做一个累计增量备份
BACKUP DATABASE INCREMENTAL LEVEL 1 CUMULATIVE FORMAT '/home/omm/backup/backup1_incr_cum01.bak';
SQL> BACKUP DATABASE INCREMENTAL LEVEL 1 CUMULATIVE FORMAT '/home/omm/backup/backup1_incr_cum01.bak';
Succeed.
SQL>
[omm@localhost ~]$ ll /home/omm/backup/backup1_incr_cum01.bak
total 146684
-rw-------. 1 omm dbgrp 10603520 Feb 14 07:11 arch_1_0.bak
-rw-------. 1 omm dbgrp 101888 Feb 14 07:11 arch_2_0.bak
-rw-------. 1 omm dbgrp 26112 Feb 14 07:11 arch_3_0.bak
-rw-------. 1 omm dbgrp 5116 Feb 14 07:11 backupset
-rw-------. 1 omm dbgrp 10485760 Feb 14 07:11 ctrl_0_0.bak
-rw-------. 1 omm dbgrp 155648 Feb 14 07:11 data_SYSAUX_12_0.bak
-rw-------. 1 omm dbgrp 57344 Feb 14 07:11 data_SYSTEM_0_0.bak
-rw-------. 1 omm dbgrp 0 Feb 14 07:11 data_TEMP_1_0.bak
-rw-------. 1 omm dbgrp 0 Feb 14 07:11 data_TEMP2_9_0.bak
-rw-------. 1 omm dbgrp 0 Feb 14 07:11 data_TEMP2_UNDO_11_0.bak
-rw-------. 1 omm dbgrp 26951680 Feb 14 07:11 data_UNDO_3_0.bak
-rw-------. 1 omm dbgrp 101810176 Feb 14 07:11 data_UNDO_3_1.bak
-rw-------. 1 omm dbgrp 0 Feb 14 07:11 data_USERS_4_0.bak
[omm@localhost ~]$
[omm@localhost ~]$ strings /home/omm/backup/backup1_incr_cum01.bak/backupset
634979517667486_6291424378881
634979437507787_5836392370177
(/opt/gaussdb/data/data/cntl1, /opt/gaussdb/data/data/cntl2, /opt/gaussdb/data/data/cntl3)
SYSTEM
TEMP
UNDO
UNDO
USERS
TEMP2
TEMP2_UNDO
SYSAUX
/home/omm/backup/backup1_incr_level0.bak
聚合增量，关联了level0的备份
关闭数据库
SQL> shutdown immediate; Succeed. 文件夹改名字 [omm@localhost ~]$ mv /opt/gaussdb/data/data/ /opt/gaussdb/data/data.orig
执行恢复
启动到nomount状态
python zctl.py -t start -m NOMOUNT
[omm@localhost ~]$ cd /opt/gaussdb/app/bin/
[omm@localhost bin]$ python zctl.py -t start -m NOMOUNT
Successfully started instance.
[omm@localhost bin]$ ps -ef|grep omm
omm 11718 1 3 07:14 pts/0 00:00:00 /opt/gaussdb/app/bin/zengine nomount -D /opt/gaussdb/data
登录实例
zsql sys/Changeme_123@192.168.18.128:1888 密码是最早的了 [omm@localhost bin]$ zsql sys/Changeme_123@192.168.18.128:1888 Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y connected.
恢复数据文件
RESTORE DATABASE FROM '/home/omm/backup/backup1_incr_level0.bak';
SQL> RESTORE DATABASE FROM '/home/omm/backup/backup1_incr_level0.bak';
Succeed.
恢复数据库
SQL> recover database;
Succeed.
SQL> ALTER DATABASE OPEN read only;
Succeed.
SQL> select * from t1;
ID
------------
2
1 rows fetched.
恢复到了最近的时间点呢。
密码也是修改后的密码了
[omm@localhost ~]$ zsql sys/Root1234@192.168.18.128:1888
Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.
SQL> shutdown abort;
Succeed.
SQL> exit
SQL> select owner,OBJECT_NAME from dba_objects where object_type='TABLE';
OWNER OBJECT_NAME
---------------------------------------------------------------- ----------------------------------------------------------------
SYS EXP_TAB_ORDERS
SYS EXP_TAB_RELATIONS
SYS SYS_AUDIT
SYS SYS_BACKUP_SETS
SYS SYS_COLUMNS
SYS SYS_COMMENTS
SYS SYS_CONSTRAINT_DEFS
SYS SYS_DATA_NODES
SYS SYS_DEPENDENCIES
SYS SYS_DIRECTORIES
SYS SYS_DISTRIBUTE_RULES
SYS SYS_DISTRIBUTE_STRATEGIES
SYS SYS_DIST_DDL_LOGINFO
SYS SYS_DML_STATS
SYS SYS_DUMMY
SYS SYS_EXTERNAL_TABLES
SYS SYS_GARBAGE_SEGMENTS
SYS SYS_HISTGRAM
SYS SYS_HISTGRAM_ABSTR
SYS SYS_INDEXES
SYS SYS_INDEX_PARTS
SYS SYS_JOBS
SYS SYS_LINKS
SYS SYS_LOBS
SYS SYS_LOB_PARTS
SYS SYS_LOGIC_REPL
SYS SYS_OBJECT_PRIVS
SYS SYS_PART_COLUMNS
SYS SYS_PART_OBJECTS
SYS SYS_PART_STORES
SYS SYS_PENDING_DIST_TRANS
SYS SYS_PENDING_TRANS
SYS SYS_PRIVS
SYS SYS_PROCS
SYS SYS_PROC_ARGS
SYS SYS_PROFILE
SYS SYS_REBALANCE_TASK
SYS SYS_RECYCLEBIN
SYS SYS_ROLES
SYS SYS_RSRC_CONTROL_GROUPS
SYS SYS_RSRC_GROUP_MAPPINGS
SYS SYS_RSRC_PLANS
SYS SYS_RSRC_PLAN_RULES
SYS SYS_SEQUENCES
SYS SYS_SHADOW_INDEXES
SYS SYS_SHADOW_INDEX_PARTS
SYS SYS_SQL_MAPS
SYS SYS_STORAGE
SYS SYS_SUB_INDEX_PARTS
SYS SYS_SUB_LOB_PARTS
SYS SYS_SUB_PART_COLUMNS
SYS SYS_SUB_PART_TEMPLATE
SYS SYS_SUB_TABLE_PARTS
SYS SYS_SYNC_INFO
SYS SYS_SYNONYMS
SYS SYS_TABLES
SYS SYS_TABLE_PARTS
SYS SYS_TMP_SEG_STATS
SYS SYS_USERS
SYS SYS_USER_HISTORY
SYS SYS_USER_ROLES
SYS SYS_VIEWS
SYS SYS_VIEW_COLS
SYS T1
SYS WSR_CONTROL
SYS WSR_DBA_SEGMENTS
SYS WSR_EXCEPTION_LOG
SYS WSR_INSTANCE_SNAP
SYS WSR_LATCH
SYS WSR_LIBRARYCACHE
SYS WSR_LOCK_OBJECT
SYS WSR_LONGSQL
SYS WSR_PARAMETER
SYS WSR_SEGMENT
SYS WSR_SESSION_EVENTS
SYS WSR_SESSION_SQL
SYS WSR_SNAPSHOT
SYS WSR_SQLAREA
SYS WSR_SQLPLAN
SYS WSR_SQLTEXT
SYS WSR_SQL_LIST
SYS WSR_SQL_LIST_PLAN
SYS WSR_SYSTEM
SYS WSR_SYSTEM_EVENT
SYS WSR_SYS_STAT
SYS WSR_TRANSACTION
SYS WSR_WAITSTAT
87 rows fetched.
SQL> desc SYS_BACKUP_SETS
Name Null? Type
----------------------------------- -------- ------------------------------------
RECID NOT NULL BINARY_BIGINT
TYPE NOT NULL BINARY_INTEGER
STAGE NOT NULL BINARY_INTEGER
STATUS NOT NULL BINARY_INTEGER
INCREMENTAL_LEVEL NOT NULL BINARY_INTEGER
TAG NOT NULL VARCHAR(64 BYTE)
SCN NOT NULL BINARY_BIGINT
LSN NOT NULL BINARY_BIGINT
DEVICE_TYPE NOT NULL BINARY_INTEGER
BASE_TAG NOT NULL VARCHAR(64 BYTE)
DIR NOT NULL VARCHAR(256 BYTE)
RESETLOGS NOT NULL BINARY_INTEGER
POLICY NOT NULL VARCHAR(128 BYTE)
RCY_ASN NOT NULL BINARY_INTEGER
RCY_OFFSET NOT NULL BINARY_BIGINT
RCY_LFN NOT NULL BINARY_BIGINT
LRP_ASN NOT NULL BINARY_INTEGER
LRP_OFFSET NOT NULL BINARY_BIGINT
LRP_LFN NOT NULL BINARY_BIGINT
START_TIME NOT NULL TIMESTAMP(6)
COMPLETION_TIME NOT NULL TIMESTAMP(6)
SQL> select STATUS,INCREMENTAL_LEVEL,TAG,SCN,LSN,DEVICE_TYPE ,DIR from SYS_BACKUP_SETS;
STATUS INCREMENTAL_LEVEL TAG SCN LSN DEVICE_TYPE DIR
------------ ----------------- ---------------------------------------------------------------- -------------------- -------------------- ------------ ----------------------------------------------------------------
0 0 634979045189370_4160576638977 4160576638977 48112 0 /home/omm/backup/backup01.bak
0 0 634979437507787_5836392370177 5836392370177 41925 0 /home/omm/backup/backup1_incr_level0.bak
2 rows fetched.
SQL> select distinct object_type from dba_objects;
OBJECT_TYPE
---------------
TABLE
TABLE PARTITION
INDEX
VIEW
DYNAMIC VIEW
PROCEDURE
SEQUENCE
SYNONYM
8 rows fetched.
SQL> select owner,OBJECT_NAME from dba_objects where object_type='VIEW';
OWNER OBJECT_NAME
---------------------------------------------------------------- ----------------------------------------------------------------
SYS ADM_2PC_PENDING
SYS ADM_ARGUMENTS
SYS ADM_BACKUP_SET
SYS ADM_COL_COMMENTS
SYS ADM_CONSTRAINTS
SYS ADM_DATA_FILES
SYS ADM_DBLINK_TABLES
SYS ADM_DBLINK_TAB_COLUMNS
SYS ADM_DEPENDENCIES
SYS ADM_FREE_SPACE
SYS ADM_HISTOGRAMS
SYS ADM_HIST_DBASEGMENTS
SYS ADM_HIST_INSTANCE_SNAP
SYS ADM_HIST_LATCH
SYS ADM_HIST_LIBRARYCACHE
SYS ADM_HIST_LOCK_OBJECT
SYS ADM_HIST_LONGSQL
SYS ADM_HIST_PARAMETER
SYS ADM_HIST_SEGMENT
SYS ADM_HIST_SESSION_EVENTS
SYS ADM_HIST_SESSION_SQL
SYS ADM_HIST_SNAPSHOT
SYS ADM_HIST_SQLAREA
SYS ADM_HIST_SQLPLAN
SYS ADM_HIST_SQLTEXT
SYS ADM_HIST_SYSSTAT
SYS ADM_HIST_SYSTEM
SYS ADM_HIST_SYSTEM_EVENT
SYS ADM_HIST_TRANSACTION
SYS ADM_HIST_WAITSTAT
SYS ADM_HIST_WR_CONTROL
SYS ADM_INDEXES
SYS ADM_IND_COLUMNS
SYS ADM_IND_PARTITIONS
SYS ADM_IND_STATISTICS
SYS ADM_JOBS
SYS ADM_JOBS_RUNNING
SYS ADM_OBJECTS
SYS ADM_PART_COL_STATISTICS
SYS ADM_PART_KEY_COLUMNS
SYS ADM_PART_STORE
SYS ADM_PART_TABLES
SYS ADM_PROCEDURES
SYS ADM_PROFILES
SYS ADM_ROLES
SYS ADM_ROLE_PRIVS
SYS ADM_RSRC_CONTROL_GROUPS
SYS ADM_RSRC_GROUP_MAPPINGS
SYS ADM_RSRC_PLANS
SYS ADM_RSRC_PLAN_RULES
SYS ADM_SEGMENTS
SYS ADM_SEQUENCES
SYS ADM_SOURCE
SYS ADM_SYNONYMS
SYS ADM_SYS_PRIVS
SYS ADM_TABLES
SYS ADM_TABLESPACES
SYS ADM_TAB_COLS
SYS ADM_TAB_COLUMNS
SYS ADM_TAB_COL_STATISTICS
SYS ADM_TAB_COMMENTS
SYS ADM_TAB_DISTRIBUTE
SYS ADM_TAB_MODIFICATIONS
SYS ADM_TAB_PARTITIONS
SYS ADM_TAB_PRIVS
SYS ADM_TAB_STATISTICS
SYS ADM_TRIGGERS
SYS ADM_USERS
SYS ADM_VIEWS
SYS ADM_VIEW_COLUMNS
SYS ALL_ARGUMENTS
SYS ALL_COL_COMMENTS
SYS ALL_CONSTRAINTS
SYS ALL_CONS_COLUMNS
SYS ALL_DBLINK_TABLES
SYS ALL_DBLINK_TAB_COLUMNS
SYS ALL_DB_LINKS
SYS ALL_DEPENDENCIES
SYS ALL_DISTRIBUTE_RULES
SYS ALL_DIST_RULE_COLS
SYS ALL_HISTOGRAMS
SYS ALL_INDEXES
SYS ALL_IND_COLUMNS
SYS ALL_IND_PARTITIONS
SYS ALL_IND_STATISTICS
SYS ALL_JOBS
SYS ALL_OBJECTS
SYS ALL_PART_COL_STATISTICS
SYS ALL_PART_KEY_COLUMNS
SYS ALL_PART_STORE
SYS ALL_PART_TABLES
SYS ALL_PROCEDURES
SYS ALL_SEQUENCES
SYS ALL_SOURCE
SYS ALL_SYNONYMS
SYS ALL_TABLES
SYS ALL_TAB_COLS
SYS ALL_TAB_COLUMNS
SYS ALL_TAB_COL_STATISTICS
SYS ALL_TAB_COMMENTS
SYS ALL_TAB_DISTRIBUTE
SYS ALL_TAB_MODIFICATIONS
SYS ALL_TAB_PARTITIONS
SYS ALL_TAB_STATISTICS
SYS ALL_TRIGGERS
SYS ALL_USERS
SYS ALL_USER_SYS_PRIVS
SYS ALL_VIEWS
SYS ALL_VIEW_COLUMNS
SYS DBA_ARGUMENTS
SYS DBA_BACKUP_SET
SYS DBA_COL_COMMENTS
SYS DBA_CONSTRAINTS
SYS DBA_DATA_FILES
SYS DBA_DBLINK_TABLES
SYS DBA_DBLINK_TAB_COLUMNS
SYS DBA_DEPENDENCIES
SYS DBA_FREE_SPACE
SYS DBA_HISTOGRAMS
SYS DBA_INDEXES
SYS DBA_IND_COLUMNS
SYS DBA_IND_PARTITIONS
SYS DBA_IND_STATISTICS
SYS DBA_JOBS
SYS DBA_JOBS_RUNNING
SYS DBA_OBJECTS
SYS DBA_PART_COL_STATISTICS
SYS DBA_PART_KEY_COLUMNS
SYS DBA_PART_STORE
SYS DBA_PART_TABLES
SYS DBA_PROCEDURES
SYS DBA_PROFILES
SYS DBA_ROLES
SYS DBA_ROLE_PRIVS
SYS DBA_SEGMENTS
SYS DBA_SEQUENCES
SYS DBA_SOURCE
SYS DBA_SYNONYMS
SYS DBA_SYS_PRIVS
SYS DBA_TABLES
SYS DBA_TABLESPACES
SYS DBA_TAB_COLS
SYS DBA_TAB_COLUMNS
SYS DBA_TAB_COL_STATISTICS
SYS DBA_TAB_COMMENTS
SYS DBA_TAB_DISTRIBUTE
SYS DBA_TAB_MODIFICATIONS
SYS DBA_TAB_PARTITIONS
SYS DBA_TAB_PRIVS
SYS DBA_TAB_STATISTICS
SYS DBA_TRIGGERS
SYS DBA_USERS
SYS DBA_VIEWS
SYS DBA_VIEW_COLUMNS
SYS DB_ARGUMENTS
SYS DB_COL_COMMENTS
SYS DB_CONSTRAINTS
SYS DB_CONS_COLUMNS
SYS DB_DBLINK_TABLES
SYS DB_DBLINK_TAB_COLUMNS
SYS DB_DB_LINKS
SYS DB_DEPENDENCIES
SYS DB_DIRECTORIES
SYS DB_DISTRIBUTE_RULES
SYS DB_DIST_RULE_COLS
SYS DB_HISTOGRAMS
SYS DB_INDEXES
SYS DB_IND_COLUMNS
SYS DB_IND_PARTITIONS
SYS DB_IND_STATISTICS
SYS DB_JOBS
SYS DB_NODE_INFO
SYS DB_OBJECTS
SYS DB_PART_COL_STATISTICS
SYS DB_PART_KEY_COLUMNS
SYS DB_PART_STORE
SYS DB_PART_TABLES
SYS DB_PROCEDURES
SYS DB_SEQUENCES
SYS DB_SOURCE
SYS DB_SYNONYMS
SYS DB_TABLES
SYS DB_TAB_COLS
SYS DB_TAB_COLUMNS
SYS DB_TAB_COL_STATISTICS
SYS DB_TAB_COMMENTS
SYS DB_TAB_DISTRIBUTE
SYS DB_TAB_MODIFICATIONS
SYS DB_TAB_PARTITIONS
SYS DB_TAB_STATISTICS
SYS DB_TRIGGERS
SYS DB_USERS
SYS DB_USER_SYS_PRIVS
SYS DB_VIEWS
SYS DB_VIEW_COLUMNS
SYS DB_VIEW_DEPENDENCIES
SYS MY_ARGUMENTS
SYS MY_COL_COMMENTS
SYS MY_CONSTRAINTS
SYS MY_CONS_COLUMNS
SYS MY_DEPENDENCIES
SYS MY_FREE_SPACE
SYS MY_HISTOGRAMS
SYS MY_INDEXES
SYS MY_IND_COLUMNS
SYS MY_IND_PARTITIONS
SYS MY_IND_STATISTICS
SYS MY_JOBS
SYS MY_OBJECTS
SYS MY_PART_COL_STATISTICS
SYS MY_PART_KEY_COLUMNS
SYS MY_PART_STORE
SYS MY_PART_TABLES
SYS MY_PROCEDURES
SYS MY_ROLE_PRIVS
SYS MY_SEGMENTS
SYS MY_SEQUENCES
SYS MY_SOURCE
SYS MY_SQL_MAPS
SYS MY_SYNONYMS
SYS MY_SYS_PRIVS
SYS MY_TABLES
SYS MY_TAB_COLS
SYS MY_TAB_COLUMNS
SYS MY_TAB_COL_STATISTICS
SYS MY_TAB_COMMENTS
SYS MY_TAB_DISTRIBUTE
SYS MY_TAB_MODIFICATIONS
SYS MY_TAB_PARTITIONS
SYS MY_TAB_PRIVS
SYS MY_TAB_STATISTICS
SYS MY_TRIGGERS
SYS MY_USERS
SYS MY_VIEWS
SYS MY_VIEW_COLUMNS
SYS ROLE_SYS_PRIVS
SYS USER_ARGUMENTS
SYS USER_COL_COMMENTS
SYS USER_CONSTRAINTS
SYS USER_CONS_COLUMNS
SYS USER_DEPENDENCIES
SYS USER_FREE_SPACE
SYS USER_HISTOGRAMS
SYS USER_INDEXES
SYS USER_IND_COLUMNS
SYS USER_IND_PARTITIONS
SYS USER_IND_STATISTICS
SYS USER_JOBS
SYS USER_OBJECTS
SYS USER_PART_COL_STATISTICS
SYS USER_PART_KEY_COLUMNS
SYS USER_PART_STORE
SYS USER_PART_TABLES
SYS USER_PROCEDURES
SYS USER_ROLE_PRIVS
SYS USER_SEGMENTS
SYS USER_SEQUENCES
SYS USER_SOURCE
SYS USER_SQL_MAPS
SYS USER_SYNONYMS
SYS USER_SYS_PRIVS
SYS USER_TABLES
SYS USER_TAB_COLS
SYS USER_TAB_COLUMNS
SYS USER_TAB_COL_STATISTICS
SYS USER_TAB_COMMENTS
SYS USER_TAB_DISTRIBUTE
SYS USER_TAB_MODIFICATIONS
SYS USER_TAB_PARTITIONS
SYS USER_TAB_PRIVS
SYS USER_TAB_STATISTICS
SYS USER_TRIGGERS
SYS USER_USERS
SYS USER_VIEWS
SYS USER_VIEW_COLUMNS
SYS V$ALL_TRANSACTION
SYS V$ARCHIVED_LOG
SYS V$ARCHIVE_DEST_STATUS
SYS V$ARCHIVE_GAP
SYS V$ARCHIVE_PROCESSES
SYS V$BACKUP_PROCESS
SYS V$BUFFER_POOL
SYS V$BUFFER_POOL_STATISTICS
SYS V$CONTROLFILE
SYS V$DATABASE
SYS V$DATAFILE
SYS V$DB_OBJECT_CACHE
SYS V$DC_POOL
SYS V$DYNAMIC_VIEW
SYS V$DYNAMIC_VIEW_COLUMN
SYS V$FREE_SPACE
SYS V$GLOBAL_TRANSACTIONS
SYS V$HA_SYNC_INFO
SYS V$HBA
SYS V$INSTANCE
SYS V$JOBS_RUNNING
SYS V$LATCH
SYS V$LIBRARYCACHE
SYS V$LOCK
SYS V$LOCKED_OBJECT
SYS V$LOGFILE
SYS V$LONGSQL
SYS V$MANAGED_STANDBY
SYS V$ME
SYS V$OPEN_CURSOR
SYS V$PARAMETER
SYS V$PL_MANAGER
SYS V$PL_REFSQLS
SYS V$REACTOR_POOL
SYS V$REPL_STATUS
SYS V$RESOURCE_MAP
SYS V$SEGMENT_STATISTICS
SYS V$SESSION
SYS V$SESSION_EVENT
SYS V$SESSION_WAIT
SYS V$SGA
SYS V$SGASTAT
SYS V$SPINLOCK
SYS V$SQLAREA
SYS V$SQLPOOL
SYS V$SYSSTAT
SYS V$SYSTEM
SYS V$SYSTEM_EVENT
SYS V$TABLESPACE
SYS V$TEMP_POOL
SYS V$TEMP_UNDO_SEGMENT
SYS V$TRANSACTION
SYS V$UNDO_SEGMENT
SYS V$USER_ADVISORY_LOCKS
SYS V$USER_ASTATUS_MAP
SYS V$USER_PARAMETER
SYS V$VERSION
SYS V$VM_FUNC_STACK
SYS V$WAITSTAT
SYS V$XACT_LOCK
335 rows fetched.
select owner,OBJECT_NAME from dba_objects where object_type='DYNAMIC VIEW';
SQL> select owner,OBJECT_NAME from dba_objects where object_type='DYNAMIC VIEW';
OWNER OBJECT_NAME
-------- --- -----------------------
SYS DV_LOG_FILES
SYS DV_DATABASE
SYS DV_PARAMETERS
SYS DV_SESSIONS
SYS DV_DATA_FILES
SYS DV_VERSION
SYS DV_INSTANCE
SYS DV_REPL_STATUS
SYS DV_HA_SYNC_INFO
SYS DV_BACKUP_PROCESSES
SYS DV_CONTROL_FILES
SYS DV_LIBRARY_CACHE
SYS DV_BUFFER_POOLS
SYS DV_BUFFER_POOL_STATS
SYS DV_BUFFER_PAGE_STATS
SYS DV_BUFFER_INDEX_STATS
SYS DV_TEMP_POOLS
SYS DV_OBJECT_CACHE
SYS DV_LOCKS
SYS DV_TABLESPACES
SYS DV_SPINLOCKS
SYS DV_ARCHIVED_LOGS
SYS DV_ARCHIVE_GAPS
SYS DV_ARCHIVE_THREADS
SYS DV_ARCHIVE_DEST_STATUS
SYS DV_GMA
SYS DV_LOCKED_OBJECTS
SYS DV_SQLS
SYS DV_STANDBYS
SYS DV_TRANSACTIONS
SYS DV_ALL_TRANS
SYS DV_UNDO_SEGMENTS
SYS DV_TEMP_UNDO_SEGMENT
SYS DV_SESSION_WAITS
SYS DV_SESSION_EVENTS
SYS DV_SYS_EVENTS
SYS DV_ME
SYS DV_SYS_STATS
SYS DV_MEM_STATS
SYS DV_SYSTEM
SYS DV_RESOURCE_MAP
SYS DV_USER_ASTATUS_MAP
SYS DV_OPEN_CURSORS
SYS NLS_SESSION_PARAMETERS
SYS DV_PL_MANAGER
SYS DV_DYNAMIC_VIEW_COLS
SYS DV_USER_PARAMETERS
SYS DV_FREE_SPACE
SYS DV_LONG_SQL
SYS DV_GMA_STATS
SYS DV_HBA
SYS DV_SEGMENT_STATS
SYS DV_WAIT_STATS
SYS DV_LATCHS
SYS DV_VM_FUNC_STACK
SYS DV_PL_REFSQLS
SYS DV_SQL_POOL
SYS DV_RUNNING_JOBS
SYS DV_DC_POOLS
SYS DV_REACTOR_POOLS
SYS DV_USER_ADVISORY_LOCKS
SYS DV_SESSION_SHARED_LOCKS
SYS DV_XACT_LOCKS
SYS DV_XACT_SHARED_LOCKS
SYS DV_EMERG_POOL
SYS DV_CONNPOOL_STATS
SYS DV_GLOBAL_TRANSACTIONS
SYS DV_DC_RANKINGS
SYS DV_WHITELIST
SYS DV_RSRC_CONTROL_GROUP
SYS DV_DYNAMIC_VIEWS
71 rows fetched.
SQL> select * from DV_DYNAMIC_VIEWS;
USER_NAME NAME ID COLUMN_COUNT
---------------------------------------------------------------- ---------------------------------------------------------------- ------------ ------------
SYS DV_LOG_FILES 0 11
SYS DV_LIBRARY_CACHE 1 7
SYS DV_SESSIONS 2 58
SYS DV_BUFFER_POOLS 3 6
SYS DV_BUFFER_POOL_STATS 4 11
SYS DV_BUFFER_PAGE_STATS 5 5
SYS DV_BUFFER_INDEX_STATS 6 3
SYS DV_PARAMETERS 7 10
SYS DV_TEMP_POOLS 8 12
SYS DV_OBJECT_CACHE 9 9
SYS DV_LOCKS 10 7
SYS DV_TABLESPACES 21 12
SYS DV_SPINLOCKS 22 5
SYS DV_ARCHIVED_LOGS 11 35
SYS DV_ARCHIVE_GAPS 12 3
SYS DV_ARCHIVE_THREADS 13 6
SYS DV_ARCHIVE_DEST_STATUS 14 10
SYS DV_DATABASE 15 31
SYS DV_GMA 16 2
SYS DV_LOCKED_OBJECTS 17 10
SYS DV_SQLS 23 31
SYS DV_REPL_STATUS 18 3
SYS DV_STANDBYS 19 8
SYS DV_HA_SYNC_INFO 20 16
SYS DV_VERSION 32 1
SYS DV_TRANSACTIONS 33 13
SYS DV_ALL_TRANS 34 12
SYS DV_UNDO_SEGMENTS 37 10
SYS DV_TEMP_UNDO_SEGMENT 38 10
SYS DV_INSTANCE 40 8
SYS DV_SESSION_WAITS 24 9
SYS DV_SESSION_EVENTS 25 10
SYS DV_SYS_EVENTS 26 9
SYS DV_ME 27 10
SYS DV_DATA_FILES 28 10
SYS DV_SYS_STATS 29 4
SYS DV_MEM_STATS 30 4
SYS DV_SYSTEM 31 5
SYS DV_RESOURCE_MAP 35 3
SYS DV_USER_ASTATUS_MAP 36 2
SYS DV_BACKUP_PROCESSES 39 8
SYS DV_OPEN_CURSORS 41 12
SYS NLS_SESSION_PARAMETERS 42 2
SYS DV_PL_MANAGER 43 12
SYS DV_DYNAMIC_VIEW_COLS 44 8
SYS DV_USER_PARAMETERS 45 10
SYS DV_FREE_SPACE 46 6
SYS DV_LONG_SQL 47 10
SYS DV_CONTROL_FILES 48 5
SYS DV_GMA_STATS 49 4
SYS DV_HBA 50 3
SYS DV_SEGMENT_STATS 53 8
SYS DV_WAIT_STATS 54 3
SYS DV_LATCHS 55 6
SYS DV_VM_FUNC_STACK 51 2
SYS DV_PL_REFSQLS 52 5
SYS DV_SQL_POOL 56 17
SYS DV_RUNNING_JOBS 57 3
SYS DV_DC_POOLS 58 9
SYS DV_REACTOR_POOLS 59 16
SYS DV_USER_ADVISORY_LOCKS 60 4
SYS DV_SESSION_SHARED_LOCKS 61 3
SYS DV_XACT_LOCKS 62 4
SYS DV_XACT_SHARED_LOCKS 63 3
SYS DV_EMERG_POOL 64 4
SYS DV_CONNPOOL_STATS 65 18
SYS DV_GLOBAL_TRANSACTIONS 66 7
SYS DV_DC_RANKINGS 67 3
SYS DV_WHITELIST 68 4
SYS DV_RSRC_CONTROL_GROUP 69 17
SYS DV_DYNAMIC_VIEWS 70 4
71 rows fetched.
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
