Author: parwez

Point in time recovery using pgBackRest for PostgreSQL

pgBackRest aims to be a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms that are optimized for database-specific requirements . It is used to […]

 50 total views,  3 views today

pgAdmin Installation for RHEL 7 and use cases for PostgreSQL server

pgAdmin is the leading Open Source management tool for Postgres, the world’s most advanced Open Source database. It provides a powerful graphical interface that simplifies the creation, maintenance and use of database objects. If we […]

 102 total views,  2 views today

Where does PostgreSQL datafile get stored?

If we talk about database , at high level all databases are simply data store and stored as a set of files on disk. In PostgreSQL inside the data directory , you will see many […]

 47 total views,  3 views today

Backup/Restore Postgres DB from AWS S3 using WAL-G

WAL-G  is an archival restoration tool for Postgres(beta for MySQL, MariaDB, MongoDB and SQLServer) It is an continuous arching tool used to easily set up and recover from physical backup in Postgres. It mainly handles the storage […]

 124 total views,  3 views today

Different location of datafile, errors RMAN-06094: datafile 31 must be restored ,RMAN-06571: datafile 31 does not have recoverable copy

I was trying to sync my standby database with incremental backup from production due to huge archive log gap of more than 500 archive. While trying to catalog the datafile for switching, the switching was […]

 193 total views,  4 views today

Grid patching was failing with Failed to bring down CRS servic(Clean of ‘ora.gipcd’ on ‘host’ failed)

We were trying to patch out GI home with Oct 2020 PSU, but the patch was not proceeding and every time it failed , when it was trying to bring the CRS down Executing patch […]

 295 total views,  8 views today

ORA-01450: maximum key length (6398) exceeded while doing impdp

Today while performing logical import of data(impdp) , I faced this unique error , which was failing to create index on the imported tables column’s. The whole errors looks like below Failing sql is: CREATE […]

 157 total views,  2 views today

0602-101 Out of memory saving lines for undo

I was trying to open alert log for one of the issue happening in the database , was unable to open the alert log . The opening of file failing with ex: 0602-101 Out of […]

 218 total views,  1 views today

PRVG-13602 : NTP daemon is not synchronized with any external time source on node “exa01”. Result: Clock synchronization check using Network Time Protocol(NTP) failed

I was trying to add some node in our existing 6 node clusters, out ./cluvfy stage -pre crsinst was failing because of NTP sync error . [grid@exa01 bin]$ ./cluvfy stage -pre crsinst -n exa05 -verbose […]

 553 total views,  4 views today

Infiniband Oct 2020(19.3.13.0.0.201022) patch was failing upgradeIBSwitch.sh: No such file or directory

I was trying to apply the InfiniBand switch patch(October 2020 19.3.13.0.0.201022 ) to our exadata x5-2 box but it was failing with error saying upgradeIBSwitch.sh: No such file or directory root@exa01 patch_19.3.13.0.0.201022]# ./patchmgr -ibswitches ib_group […]

 406 total views,  3 views today