longs-to-clob
In the development environment, a quick copy of a database with a different dbname or sid may be required. In such cases, we need to use rman duplicate or standard rman restore method. In this post, we will change the dbname by doing a quick copy. Steps Perform a backup of the primary standby database

Read More

Hi mate, How is your day going so far? I wish you luck to achieve what you’re hardworking for. this post I wanted to handle on the Exadata installation process. All IP addresses must be statically assigned, including dynamically assigned (DHCP) addresses.All RDMA Network structure IP addresses must be in the same subnet with a

Read More

Oracle RAC provides clustering by allowing multiple computers to run Oracle RDBMS software simultaneously while accessing a single database. In a non-RAC Oracle database, a single instance accesses a single database. The database consists of a collection of data files , control files and redo logs located on disk . Example contains a collection of

Read More

Oracle Streams
Starting from Oracle HA (High Availability) products, Oracle Dataguard, RAC and RMAN are the most commonly used products. Oracle Streams emerges as a replication product, but mainly uses Oracle Logical Standby technology. Oracle Streams generally consists of three different processes called Apply, Propagate and Capture. Apply is the process that runs the LCR records in

Read More

golden-gate-step-by-step
Oracle’s GoldenGate is a software solution that enables DML, DDL, DCL and TCL replication of existing data between databases. If you want to explain this sentence briefly, thanks to Oracle GoldenGate, we can transfer and operate the records of the transactions performed on the source database on the target databases we want, in real time

Read More

oracle-block-corruption
This post describes how to repair multiple or single-block corruption of data files, including system data files, in the Oracle database. Block corruption is a common source of database outages. Database block becomes corrupted when its content is different from what the Oracle database expects to find. If block corruption is not prevented or repaired,

Read More

Oracle cluster check
Today I received an email from Anuj Agarwal, founder of Feedspot .Thank you for your attention. I will try to be worthy.

Read More