<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lk的窝]]></title><description><![CDATA[坚持！！]]></description><link>https://blog.youkuaiyun.com/lk_db</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lk_db]]></copyright><item><title><![CDATA[hgdb HAC集群中，计划重新初始化数据库使用原集群配置的操作方法（二）]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/123919581</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/123919581</guid><author>lk_db</author><pubDate>Sat, 02 Apr 2022 14:30:10 +0800</pubDate><description><![CDATA[续“hgdb HAC集群中，计划重新初始化数据库使用原集群配置的操作方法（一）”

1、停止所有节点的hghac服务并删除所有节点的data目录
[root@db ~]# systemctl stop hghac-vip
[root@db hgdbdata]# rm -rf data/
[root@db2 ~]# systemctl stop hghac-vip
[root@db2 hgdbdata]# rm -rf data/
[root@db3 ~]# systemctl stop hghac-vip
]]></description><category></category></item><item><title><![CDATA[HGDB进入与退出单用户模式]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/123573380</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/123573380</guid><author>lk_db</author><pubDate>Fri, 18 Mar 2022 14:04:00 +0800</pubDate><description><![CDATA[[highgo@db ~]$ /opt/HighGo6.0.2-cluster/bin/postgres --single -D /opt/HighGo6.0.2-cluster/data highgo
PostgreSQL stand-alone backend 12.3
backend&gt; vacuum freeze ;
backend&gt;

backend&gt; \q
2022-03-18 13:59:34.200 CST [65498] ERROR: syntax error at ...]]></description><category></category></item><item><title><![CDATA[hgdb HAC集群中，计划重新初始化数据库使用原集群配置的操作方法（一）]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/123571928</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/123571928</guid><author>lk_db</author><pubDate>Fri, 18 Mar 2022 12:49:19 +0800</pubDate><description><![CDATA[1、所有节点停止hghac服务，删除原data目录，重新在主节点initdb（原配置的HAC集群文件不变）
[root@db data]# systemctl stop hghac-vip
[root@db data]# initdb -e sm4 -c "echo 12345678" -D /db/hgdbdata/data

2、启动节点1的HAC服务，此时集群信息显示异常
[root@db data]# /opt/HighGo/tools/hghac/hghactl -c /opt/HighGo/t.]]></description><category></category></item><item><title><![CDATA[瀚高安全版数据库版本检查是否启用了SM4加密]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/123571865</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/123571865</guid><author>lk_db</author><pubDate>Fri, 18 Mar 2022 12:43:09 +0800</pubDate><description><![CDATA[（1）测试用数据库版本
highgo=# select version();
                     version                      
----------------------------------------------------------------------------------------------
HighGo Security Enterprise...]]></description><category></category></item><item><title><![CDATA[HGDB安全版用户解锁]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/123571110</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/123571110</guid><author>lk_db</author><pubDate>Fri, 18 Mar 2022 11:48:19 +0800</pubDate><description><![CDATA[使用syssso用户登录数据库：

[root@db data]# psql -U syssso -d highgo
Password for user syssso:
NOTICE: 
-------------------------------------------
Login User: syssso
Login time: 2022-03-17 15:20:30.646187+08
Login Address: [local]
Last Login Status: SUCCESS
L...]]></description><category></category></item><item><title><![CDATA[HGDB确认数据库采用了sm3的连接认证方式]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/123571065</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/123571065</guid><author>lk_db</author><pubDate>Fri, 18 Mar 2022 11:46:36 +0800</pubDate><description><![CDATA[highgo=# select * from pg_user;
  usename   | usesysid | usecreatedb | usesuper | userepl | usebypassrls | passwd |    valuntil    | useconfig
----------------+----------+-------------+----------+---------+--------------+----------+---------...]]></description><category></category></item><item><title><![CDATA[HGDB HAC集群导致时间线变化的操作演示]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/123570046</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/123570046</guid><author>lk_db</author><pubDate>Fri, 18 Mar 2022 11:32:08 +0800</pubDate><description><![CDATA[（1）停止所有节点的HAC
[root@db data]# systemctl stop hghac-vip
[root@db data]# /opt/HighGo/tools/hghac/hghactl -c /opt/HighGo/tools/hghac/hghac.yaml list
+ Cluster: ha (7072987311974756506) -----+---------+----+-----------+
| Member | Host        | Role  ...]]></description><category></category></item><item><title><![CDATA[hgdb hac集群重启后所有节点显示Replica，无Leader节点的原因之一]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/123569900</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/123569900</guid><author>lk_db</author><pubDate>Fri, 18 Mar 2022 11:12:42 +0800</pubDate><description><![CDATA[1、瀚高HAC集群重启后，所有节点显示Replica；无法启动主节点
[root@db ~]# /opt/HighGo/tools/hghac/hghactl -c /opt/HighGo/tools/hghac/hghac.yaml list
+ Cluster: ha (7072987311974756506) -----+---------+----+-----------+
| Member | Host        | Role  | State  | TL | Lag i...]]></description><category></category></item><item><title><![CDATA[12c rman备份归档日志及注意事项]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/99978568</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/99978568</guid><author>lk_db</author><pubDate>Wed, 21 Aug 2019 17:27:40 +0800</pubDate><description><![CDATA[Oracle 12c中，可以从CDB$ROOT中备份归档日志：
RMAN&gt; backup archivelog all;
RMAN&gt; backup archivelog all delete input;

如下命令显示了如何备份那些没有备份两次的归档日志：
RMAN&gt; backup archivelog all not backed up 2 times;

当连接到PDB时，...]]></description><category></category></item><item><title><![CDATA[RAC中ora.hisdg.db中hisdg指的是db_unique_name]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/92846047</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/92846047</guid><author>lk_db</author><pubDate>Wed, 19 Jun 2019 20:59:22 +0800</pubDate><description><![CDATA[$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME      TARGET STATE    SERVER          STATE_DETAILS

----------------------...]]></description><category></category></item><item><title><![CDATA[Linux使用samba读写windows共享目录]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/90700479</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/90700479</guid><author>lk_db</author><pubDate>Thu, 30 May 2019 16:53:03 +0800</pubDate><description><![CDATA[实验环境：
服务端：
Windows 2008R2
192.168.80.68

客户端：
[root@11g ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.9 (Santiago)
192.168.80.232

1、在windows上创建共享文件夹E:\sharelinux（步骤略）

2、在linu...]]></description><category></category></item><item><title><![CDATA[pg更改数据库用户密码的注意事项]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/90577253</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/90577253</guid><author>lk_db</author><pubDate>Sun, 26 May 2019 16:17:37 +0800</pubDate><description><![CDATA[postgres=# alter user postgres9.6 with password highgo123;
ERROR: syntax error at or near ".6"
LINE 1: alter user postgres9.6 with password highgo123;
 ^
postgres=# alter u...]]></description><category></category></item><item><title><![CDATA[12cR2 PDB锁定概要文件]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/89450532</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/89450532</guid><author>lk_db</author><pubDate>Mon, 22 Apr 2019 14:01:48 +0800</pubDate><description><![CDATA[首先创建锁定概要文件：
SQL&gt; create lockdown profile APP_DBA_PROFILE;
Lockdown Profile created.
SQL&gt; select PROFILE_NAME,status from dba_lockdown_profiles;
PROFILE_NAME   STATUS
----------------- -------...]]></description><category></category></item><item><title><![CDATA[限制公共用户访问指定PDB的元数据信息（CONTAINER_DATA）]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/89449615</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/89449615</guid><author>lk_db</author><pubDate>Mon, 22 Apr 2019 12:48:04 +0800</pubDate><description><![CDATA[如下举例：让C##TEST用户查询v$session的公共数据，但这些数据只能来自CDB(CON_ID=0)、CDB$ROOT(CON_ID=1)和orclpdb2（CON_ID=4）：
SQL&gt; show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL&gt; show pdbs
  CON_ID CON_NA...]]></description><category></category></item><item><title><![CDATA[Oracle 12cR2多租户架构下，PDB被拔出删除后，在原CDB中删除common user，当PDB重新插入时，该PDB中的此common user也被删除]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/89448305</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/89448305</guid><author>lk_db</author><pubDate>Mon, 22 Apr 2019 11:20:49 +0800</pubDate><description><![CDATA[1、原12cR2多租户架构数据库中已经创建了公共用户C##TEST：
SQL&gt; select * from cdb_sys_privs where grantee like 'C##%';

GRANTEE       PRIVILEGE                ADM COM INH   CON_ID
----------------...]]></description><category></category></item><item><title><![CDATA[在PDB中赋予公共用户create session权限，默认该公共用户仅能连接该PDB，无法连接其他PDB]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/89447107</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/89447107</guid><author>lk_db</author><pubDate>Mon, 22 Apr 2019 10:37:04 +0800</pubDate><description><![CDATA[创建公共用户：
SQL&gt; create user C##TEST identified by test container=all;
User created.
SQL&gt; select username,common from dba_users where oracle_maintained='N';
USERNAME   COM
------------------
C##TE...]]></description><category></category></item><item><title><![CDATA[用户和角色定义实际上都存储在同样的数据字典表中，即USER$，其中的TYPE#列定义了是用户（1）还是角色（0）]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/89446459</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/89446459</guid><author>lk_db</author><pubDate>Mon, 22 Apr 2019 10:11:33 +0800</pubDate><description><![CDATA[SQL&gt; select user,name,type# from user$ order by 1;

USER              NAME                TYPE#
------------------------------ ------------------------------ ----------...]]></description><category></category></item><item><title><![CDATA[Oracle 12c为PDB创建专用监听]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/89393657</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/89393657</guid><author>lk_db</author><pubDate>Fri, 19 Apr 2019 09:48:55 +0800</pubDate><description><![CDATA[在某些情况下，需要为一个或多个PDB使用特定的专用监听端口。这就需要创建新的监听，并确保PDB注册到它上面。
在下面的例子中，我们创建新的监听LISTENER_PDB，使用的端口为1522，修改listener.ora文件添加如下内容：
LISTENER_PDB =
 (DESCRIPTION_LIST =
  (DESCRIPTION =
   (ADDRESS = (PROTOCO...]]></description><category></category></item><item><title><![CDATA[PDB中限制表空间所能使用的最大空间，以及占用的CDB级别的最大临时表空间]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/89380832</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/89380832</guid><author>lk_db</author><pubDate>Thu, 18 Apr 2019 15:57:55 +0800</pubDate><description><![CDATA[SQL&gt; show pdbs
  CON_ID CON_NAME            OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
    4 ORCLPDB2            READ WRITE N...]]></description><category></category></item><item><title><![CDATA[查看PDB的操作历史]]></title><link>https://blog.youkuaiyun.com/lk_db/article/details/89379890</link><guid>https://blog.youkuaiyun.com/lk_db/article/details/89379890</guid><author>lk_db</author><pubDate>Thu, 18 Apr 2019 15:28:02 +0800</pubDate><description><![CDATA[PDB创建之后，它的生命周期中最简单的事件就是启动和关闭。在实际操作中，对PDB的操作要远远比启动和关闭复杂，cdb_pdb_history视图提供了对这个内容进行回顾的方法。
SQL&gt; col pdb_name format a10
SQL&gt; select pdb_name,op_timestamp,operation from cdb_pdb_history order by 2;...]]></description><category></category></item></channel></rss>