4 Comments

How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) 5 (1)

How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) This post presents a quick and efficient alternative to rebuilding a physical standby database in Oracle Database 11g Release 2 by using RMAN incremental backups to roll forward and resynchronize a physical standby database with the primary database or Fix ORA-10458 […]

 293 Total Views,  1 Views Today

0 Comments

Add & Drop Standby Redolog Files on Standby (Dataguard) in Oracle 0 (0)

Add & Drop Standby Redolog Files on Standby (Dataguard) in Oracle In this article, we are going to demonstrate add & drop standby redolog files on standby (dataguard) in Oracle. Drop or add standby redolog files require in case we resized/recreate redolog in PRIMARY so need to follow same on STANDBY database or some times […]

 554 Total Views,  1 Views Today

0 Comments

Steps to Create Active Physical Standby Dataguard Using RMAN Duplicate in Oracle 4 (1)

Steps to Create Active Physical Standby Dataguard Using RMAN Duplicate in Oracle In the previous article, we have configured a Physical STANDBYdatabase where we started MRP in mount state. In this article, we are going to demonstrate Steps to Create Active Physical Standby Dataguard Using RMAN Active Duplicate in Oracle database. Active dataguard features introduced […]

 1,175 Total Views,  1 Views Today

0 Comments

Step by Step Physical Standby Database Creation in Oracle 5 (3)

Step by Step Physical Standby Database Creation in Oracle Data Guard is used for disaster recovery and high availability. Due to any disaster, if our PRIMARY database got crash so, in that case, our STANDBY may become our PRIMARY database. Here, our client requirement, we need to create a STANDBY database using RMAN backup. Below […]

 996 Total Views,  5 Views Today

6 Comments

Step By Step Apply Combo Patch on Primary & Standby (DATAGUARD) Database in Oracle 5 (3)

Combo Patch Apply on Primary & Standby Database in Oracle In this article, we are going to demonstrate step by step apply combo patches on Oracle Primary & Standby (DATAGUARD) which released in January 2021, combo patch contains PSU (31985579) and  OJVM (32119956) patches. Below is the database, system,  patch id, etc. details. COMPONENTS PRIMARY […]

 1,593 Total Views,  3 Views Today

0 Comments

How To Recover Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby 5 (3)

Recover a Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE.Recovering the table from the standby database will also eliminate any required […]

 1,393 Total Views

2 Comments

How to check ASM diskgroup Size 5 (1)

Sometime we need to fetch ASM diskgroup utilization of database. Below is the sql query to find ASM diskgroup size in database which includes Name,Total_GB,Free_GB,Used_GB and Free_percentage of disk. Sql query to fetch ASM diksgroup size. Click here to get sample output . Reference: How to add disk into ASM diskgroup. click here Hope so […]

 1,081 Total Views,  6 Views Today

0 Comments

How to check tablespace size. 5 (2)

Below sql query is used to find total tablespace size of your database. which includes Tablespace name used size in MB, free size in MB and Total size in MB Sql command which fetch tablesapce size in GB Click here to get sample output We always encourage the technical person to visit section SCRIPTS to get more […]

 914 Total Views,  3 Views Today

Spread the Knowledge!

6 Comments

Resolve ORA-10562,10564,01110,10561,00600 at Standby database In Oracle 4.7 (21)

Resolve ORA-10562, 10564, 01110, 10561, 00600 at Standby database In Oracle In this article, we will resolve errors ORA-10562, 10564, 01110, 10561, 00600 at Standby. A few days back, we got an SYSAUX tablespace error at DBGURU STANDBY database and the error was as below: Errors in file /u02/app/oracle/diag/rdbms/dbguru/dbguru/trace/dbguru_mrp0_26696.trc:ORA-10562: Error occurred while applying redo to […]

 4,066 Total Views,  4 Views Today

Spread the Knowledge!