Database Blog

Converting Snapshot Standby Database into Physical Standby Database

Oracle uses restore point and Flashback Database feature to accomplish this conversion of snapshot standby database to physical standby database. Restore point and Flashback Database concepts were first introduced in…

Read More

Converting Physical Standby Database into Snapshot Standby Database

There are three restrictions where we cannot convert to a snapshot. a) If it is the only standby of a Maximum Protection configuration.b) If it is the target of a…

Read More

Script to generate Schema creation,grants and roles in a database for an existing schema without connecting to TOAD

Please change accordingly as per the need. set long 20000 longchunksize 20000 pagesize 0 linesize 1000 feedback off verify off trimspool on column ddl format a1000 begin    dbms_metadata.set_transform_param (dbms_metadata.session_transform,…

Read More

Asadmin with Remote GlassFish

 I’ve  faced issue while  working  with Amazon EC2, I’m starting to appreciate how useful theGlassFish asadmin tool is with a remote system. Here are some steps to get GlassFish set up for…

Read More

CP Admin in R12.2.5

CP Admin in R12

Read More

RAC Grid Infrastucture Startup Sequence and Important Logfile Location

RAC Grid Infrastucture Startup Sequence and Important Logfile Location

Read More

Setting up a GoldenGate replication with mapping between different columns

Setting up a GoldenGate replication with mapping between different columns

Read More

Adding Custom Fields to a Replicated Record Using SQLEXEC

Adding Custom Fields to a Replicated Record Using SQLEXEC

Read More

Adding Custom Fields for a Replicated Record Using

Adding Custom Fields for a Replicated Record Using

Read More

Untitled

Performing a healthcheck of a live GoldenGate configuration How to do it… The state of a GoldenGate replication can be checked by performing the following steps on both source and…

Read More