Blog Posts

How to Add/Drop/Rename Standby Redolog file

February 19, 2014

How to Drop/Rename Standby Redolog file in Oracle 11gWhile performing the dataguard Broker, we need to drop the standby database while switchover the standby . As it seems an easy task but it is bit tricky . Below are the steps to drop the redolog file from standby database : On Standby Database : SQL>…

Oracle Active Data Guard Or Oracle GoldenGate

February 17, 2014

Oracle Active Data Guard and Oracle GoldenGate Oracle Active Data Guard and Oracle Golden Gate are strategic capabilities within Oracle’s software portfolio. While they generally fall into the category of replication technologies, each has a very different area of focus.Oracle Active Data Guard provides the best data protection and availability for Oracle Database in the…

TOAD USER SCRIPT

February 6, 2014

SCRIPT TO CREATE TOAD USER : I really had to struggle a lot to get this script.Creating these objects as toad user will allow u to gathers stats for disk ,data file and table spaces growth and trending. This scipt need to be run as toad user to create all the tables & ddl needed…

Monitoring standby database made easy

February 5, 2014

we can use a simple trick to check if the standby database is up to date or not : The trick is we are going to create a table and populate it every minute on primary server with a scheduled job using a simple procedure.When we query the standby server we will see the table…

ORA-00301: error in adding log file ‘stdby02.log’ – file cannot be created

February 4, 2014

SQL> alter database add standby logfile ‘/u02/oracle/oradata/stdby01.log’ size 512M; Database altered. SQL> alter database add standby logfile ‘/u02/oracle/oradata/stdby02.log’ size 512M; Database altered. SQL> alter database drop standby logfile ‘/u02/oracle/oradata/stdby01.log’; Database altered. SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG; GROUP# THREAD# SEQUENCE# ARC STATU—— ———- ———- — —– 6 0 0 YES UNASS IGNED SQL> alter database drop…