• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Data Guard

How to Change sys password in oracle 12c on RAC and dataguard

by admin

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 […]

Filed Under: Data Guard, oracle, RAC

Warning: ORA-16829: fast-start failover configuration is lagging

by admin

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 […]

Filed Under: Data Guard, oracle

Oracle DGMGRL (Data Guard Manager) Command Line Reference (Cheat Sheet)

by admin

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 […]

Filed Under: Data Guard, oracle

Oracle Data Guard Command Line Reference (Cheat Sheet)

by admin

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 […]

Filed Under: Data Guard, oracle

Configuring Data Guard in Oracle Cloud Infrastructure (OCI)

by admin

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 […]

Filed Under: Data Guard, oracle

Oracle Data Guard – Tempfiles created at primary are not automatically created at standby

by admin

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 […]

Filed Under: Data Guard, oracle

Oracle Data Guard 12c New Feature: Far Sync Standby

by admin

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 […]

Filed Under: Data Guard, oracle, oracle 12c

How to Verify if Oracle Active Data Guard is Enabled

by admin

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 […]

Filed Under: Data Guard, oracle

How to Clone a Pluggable Database from an RMAN Container Database Backup

by admin

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 […]

Filed Under: Data Guard, oracle, oracle 12c

Oracle 12c: Unplug/Plug PDB to new CDB using RMAN Active Database Duplication

by admin

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 […]

Filed Under: ASM, Data Guard, oracle, oracle 12c

Next Page »

Primary Sidebar

Recent Posts

  • ncat Command Examples in Linux
  • ncat: command not found
  • nautilus Command Examples in Linux
  • namei: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright