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

 43 Total Views,  1 Views Today

0 Comments

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

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

 195 Total Views,  2 Views Today

0 Comments

Step by Step Physical Standby Database Creation in Oracle 4.7 (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 […]

 262 Total Views,  1 Views Today

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

 808 Total Views,  2 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,184 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  524 Total Views, […]

 524 Total Views,  1 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 […]

 351 Total Views,  2 Views Today

Spread the love

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. Few days back, we got 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 data block […]

 3,326 Total Views,  5 Views Today

Spread the love