Top Reviews

PostgreSQL 11 Streaming Replication/Hot Standby

To create PostgreSQL replication first we must install PostgreSQL on  Primary and  Standby server. On Primary and Standby: [root@localhost ]# yum -y install epel-release [root@localhost ]# yum -y install bash-completion [root@localhost ]# yum -y install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm [root@localhost ]# yum install postgresql11-server [root@localhost ]# yum install postgresql11-contrib On Primary: [root@localhost ]# /usr/pgsql-11/bin/postgresql-11-setup initdb Initializing database ……

Read more

RAC|ASM

Directory Index Full Today I encountered with short system hang in my 2 node RAC database.When I investigate the cause of the problem a saw “Kernel: EXT4-fs warning (device sda1): ext4_dx_add_entry:2021: Directory index full!” warning in the /var/log/messages file. Jan 22 14:45:09 mydb1 kernel: EXT4-fs warning (device sda1): ext4_dx_add_entry:2021: Directory index full! Jan 22 14:45:09 mydb1 kernel:…

Read more

Saving Archive logs in different destinations and changing log_archive_format

Resolving 101 SYS@ola> alter system set log_archive_dest_2 = ‘LOCATION=/u01/’; SYS@ola> alter system set log_archive_dest_2 = ‘LOCATION=/tmp/’; SYS@ola> SHOW PARAMETER LOG_ARCHIVE_FORMAT; NAME                                 TYPE        VALUE ———————————— ———– —————————— log_archive_format                   string      %t_%s_%r.dbf LOG_ARCHIVE_FORMAT-a We ignore the settings above alter system set LOG_ARCHIVE_FORMAT=’log%a_%d_%T_%S_%t_%s_%r.arc’ scope=spfile; SYS@ola> startup force; SYS@ola> SHOW PARAMETER LOG_ARCHIVE_FORMAT; NAME                                 TYPE        VALUE ———————————— ———– —————————— log_archive_format                   string     …

Read more

Scenario 1 – Restore control file from backup after loss of all control files

Condition: All copies of the control file have been deleted The data is in the order of files and online redo logs Our control file has backups Database archive works in log mode First we look at where our control files are located SQL> select name from v$controlfile; NAME ——————————————————————————– /u01/app/oracle/oradata/DB11G/control01.ctl /u01/app/oracle/oradata/DB11G/control02.ctl   We then…

Read more

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment