ARCH wait on SENDREQ

PROBLEM: ARCHIVE process get hang on Primary Database The problem has been that the standby hardware have some faulty backpane. This has caused processes in the standby to go into what is called as “D” state where the processes gets stuck in a kernel call. So the RFS processes on the standby are getting hung […]

Read More

Prepare standby and configure primary database for far sync

This depend on distance between primary and standby and network bandwidth. So this feature that came with 12c resolve this situation. We are preparing a database one more. This database take archive–log primary database and then send this archive–log to standby. Primary and far sync standby database are sync, whereas far sync standby database and physical standby database are async. Let’s begin with creating the physical standby with FAR SYNC instance in place. First of […]

Read More

Create Far Sync Standby Database

This depend on distance between primary and standby and network bandwidth. So this feature that came with 12c resolve this situation. We are preparing a database one more. This database take archive–log primary database and then send this archive–log to standby. Primary and far sync standby database are sync, whereas far sync standby database and […]

Read More

Data Guard Archive Tracing

You can trace the archive logs on either the primary or the standby database by setting the log_archive_trace initialization parameter

Trace files located in user_dump_dest location. On the primary database, the log_archive_trace parameter controls the output of the ARCn (archiver) FAL (fetcharchived log) LGWR (log writer) background processes. On the standby databases, it traces […]

Read More

FAR SYNC in Oracle 12C Database

Oracle introduced a new feature for DataGuard called Far Sync. This configuration is design to support synchronous redo transport between primary and standby database which are far apart. In usual configuration synchronous redo transport between data centre in Europe and US is possible but inefficient from the primary database performance perspective. Every commit has to be written […]

Read More

Creation of Physical Standby in Oracle One Node

Introduction:- Data plays an important role in business operations on a day to day life. Without data, we can not perform our business operations. Data helps to generate business reports, With the help of data, all kind of business’s departments( Hr, Top management, Technical Departments, Accounts Departments etc.) can achieve their goals on time. Loss of data […]

Read More

Convert Physical Standby To Snapshot Standby Database

What is snapshot standby: Snapshot standby is a feature in Oracle 11g that allows doing a read-write operation on the standby database.  i. e we can convert the physical standby database to snapshot standby. On that, we can do all types of testing or can be used as a development database (which is an exact […]

Read More

How to apply PSU patch on standby database

To apply psu patch on  physical standby database setup, 1st patch need to be applied on standby, and then on primary. Below are the steps.  Download patch from oracle support. Check the database_role for both dbs PRIMARY> select database_role from v$database; DATABASE_ROLE —————- PRIMARY STANDBY> select database_role from v$database; SDATABASE_ROLE —————- PHYSICAL STANDBY 2.Run below […]

Read More

ORA-01274: cannot add data file

PROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Primary database:

— Error in alert log of standby database File #5 added to control file as ‘UNNAMED00005’ because the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL The file should be manually created to continue. MRP0: Background Media Recovery terminated […]

Read More