💡 No more data to read from socket Cách fix chạy 2 câu lệnh sau SQL> alter system set “_sql_plan_directive_mgmt_control” = 0; System altered. SQL> alter system set “_optimizer_dsdir_usage_control” =…
Mình chia sẻ trigger bắt thông tin log in: Thông tin log lưu trong bảng log_login Exclude lưu trong bảng exclude_login Chỉ action với database primary, standby thì bỏ qua…
[root@server1 ~]# su postgres [postgres@server1 root]$ psql -f all.sql bash: psql: command not found Chạy câu lệnh sau export PATH=/opt/PostgreSQL/9.5/bin:$PATH
Below are the steps for enabling archive mode or wal archiving in postgres. STEPS TO ENABLE ARCHIVE MODE IN POSTGRES: 1. Check archive setting in the postgres config file: postgres=#select…
Cách flashback cả database về thời thời điểm bất kỳ: SQL> select * from V$FLASHBACK_DATABASE_LOG; SQL> Shutdown immediate; SQL> Startup mount; SQL> flashback database to timestamp TO_TIMESTAMP( ‘2022-03-04 19:00:00′,’YYYY-MM-DD HH24:MI:SS’);…
Before start with this article, please check our previous guide how to install and configure openfiler. How to install Oopenfiler how to make Iscsi target disks in Openfiler Now we…
In this article, I will show you Postgresql installation and its streaming replication configuration of two PostgreSQL instances on different hosts. Our goal is to install Postgres 9.5 on master…
iLO Standard Trial License Key: 34T6L-4C9PX-X8D9C-GYD26-8SQWM iLO 1 Advanced License Keys: 247RH-ZPJ8S-7B17D-FCE55-DDD17 iLO 2/3/4 Advanced License Keys: 34T6L-4C9PX-X8D9C-GYD26-8SQWM 35DPH-SVSXJ-HGBJN-C7N5R-2SS4W 35SCR-RYLML-CBK7N-TD3B9-GGBW2