💡 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process Cause: The archive logs seems that it is not yet applied in the standby database. Select …
-
-
💡 ORA-00845: MEMORY_TARGET not supported on this system Bạn sẽ gặp lỗi ORA-00845 nếu Shared Memory File System không đủ để cung cấp cho Instance. GIẢI PHÁP / SOLUTION Tăng Shared Memory …
-
💡 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