Posts

Oracle 26ai- Installing Oracle Grid Infrastructure for a Standalone Server Using the Command-Line Interface

By -
  Before Oracle AI Database 26ai , Oracle Grid Infrastructure could be installed using a response file . For example( using a response file ): ./gridSetup.sh -silent \ INVENTORY_LOCATION=/oraInventory \ SELECTED_LANGUAGES=en \ ORACLE_BASE=/grid/base \ oracle.install.option=HA_CONFIG \ oracle.install.asm.OSDBA=asmdba \ oracle.install.asm.OSOPER=asmoper \ oracle.install.asm.OSASM=asmadmin \ oracle.install.crs.config.autoConfigureClusterNodeVIP= false \ oracle.install.asm.diskGroup.name=ASM \ oracle.install.asm.diskGroup.redundancy=EXTERNAL \ oracle.install.asm.diskGroup.diskDiscoveryString= 'ORCL:*' \ oracle.install.asm.diskGroup.disks=ORCL\:ASM01 \ oracle.install.asm.SYSASMPassword=Your_Password \ oracle.install.asm.monitorPassword=Your_Password \ -ignorePrereqFailure At the end of the installation, the installer displays a message similar to the following: As install user, execute the following command to complete the configuration. /grid/19.25/gridSetup.sh -execut...
Post a Comment
Read more

Point-in-Time Recovery (PITR) with pg_basebackup in PostgreSQL 18

By -
  pg_basebackup is a useful tool for creating a base backup of a PostgreSQL cluster. When combined with continuous WAL archiving, it can be used to perform Point-in-Time Recovery (PITR) . In this article, I will demonstrate how to create a base backup using pg_basebackup and then perform PITR to a specific point in time. 1. Check the Current PostgreSQL Cluster First, let’s check the current state of the PostgreSQL cluster. psql (18.0) WARNING: Console code page (720) differs from Windows code page (1256) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details. Type "help" for help . postgres=# \l List of databases Name | Owner | Encoding | Locale Provider | Collate | Ctype | Locale | ICU Rules | Access privileges -----------+----------+----------+-----------------+-------------...
Post a Comment
Read more