As part of the password change policy, we have to change the password of sys user. This can be difficult at times if we do not do it correctly. One of the scenario is as below: Database type: RAC two nodes on primary with one node dataguard Location of password file on primary: under ASM […]
Data Guard
Warning: ORA-16829: fast-start failover configuration is lagging
Using DGMGRL, you can change property values directly by using the command-line utility. It includes commands to create an observer process that monitors the whole configuration, including the primary and standby, to evaluate if a failover is necessary, and to initiate FSFO. You might encounter the error “ORA-16829: fast-start failover configuration is lagging” while checking […]
Oracle DGMGRL (Data Guard Manager) Command Line Reference (Cheat Sheet)
Using DGMGRL, you can change property values directly by using the command-line utility. It includes commands to create an observer process that monitors the whole configuration, including the primary and standby, to evaluate if a failover is necessary, and to initiate FSFO. It’s also possible to add new standby databases to the configuration. Instead of […]
Oracle Data Guard Command Line Reference (Cheat Sheet)
Oracle Data Guard offers the maximum protection, maximum availability, and maximum performance modes to help enterprises balance data availability against system performance requirements. Oracle Data Guard is designed specifically for the creation and management of standby databases used as part of an overall Disaster Recovery plan. If your Disaster Recovery plans include creating a standby […]
Configuring Data Guard in Oracle Cloud Infrastructure (OCI)
Working with Oracle Data Guard Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. The Oracle Cloud Infrastructure Database Data Guard implementation requires two databases: one in a primary role and one in a standby role. The two databases make an Oracle Data Guard association. Most of your applications access […]
Oracle Data Guard – Tempfiles created at primary are not automatically created at standby
Question: You created a temporary datafile in the Primary database, but it did not get created in the Standby database. How to create tempfiles at standby node? New tempfiles are not added automatically in the Physical Standby database because no redo is generated. Tempfiles in the Standby are only used when your Standby is opened […]
Oracle Data Guard 12c New Feature: Far Sync Standby
A Far Sync Standby Database is a cascading Standby Database that acts as a Redo Log Repository for a Terminal Database. It does not contain any datafiles. Only Log Transport Services are active on a Far Sync Standby Database. The Advantage of a Far Sync Standby Database is that it can be a local ArchiveLog […]
How to Verify if Oracle Active Data Guard is Enabled
Question: How to identify if Active Data Guard (ADG) is enabled on a Standby database? The concept of an Active Data Guard, also known as Real-Time Query, is when it allows read-only access on the Physical standby node at the same time as applying archived transactions from the Primary node. For that to happen, the […]
How to Clone a Pluggable Database from an RMAN Container Database Backup
The following steps will show you how to perform a backup of a container database (CDB), including only the pieces required to migrate a subset of pluggable databases (PDB) with no disruption of application activity to the source PDBs. The backup and all datafiles contained in it will be consistent to a single point in […]
Oracle 12c: Unplug/Plug PDB to new CDB using RMAN Active Database Duplication
This method takes advantage of a new feature of RMAN in 12c allowing you to clone database files and apply incrementals to those files from an active database without requiring staging areas. In addition, the source PDB application activity can continue while the cloning and incremental applies are being performed. To get the datafiles in […]