Home

How to Add/Drop/Rename Standby Redolog file

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 :…
Continue reading →: How to Add/Drop/Rename Standby Redolog file
Oracle Active Data Guard Or Oracle GoldenGate

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…
Continue reading →: Oracle Active Data Guard Or Oracle GoldenGate
TOAD USER SCRIPT

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…
Continue reading →: TOAD USER SCRIPT
Monitoring standby database made easy

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…
Continue reading →: Monitoring standby database made easy
ORA-00301: error in adding log file ‘stdby02.log’ – file cannot be created

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 …
Continue reading →: ORA-00301: error in adding log file ‘stdby02.log’ – file cannot be created
How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases

How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases Lets now try to export tables from different schemas in Oracle 10g database on a Linux server. [oracle@localhost ~]$ sqlplus / as sysdba We are assuming that a1 and a2 are 2 schemas …
Continue reading →: How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases
Oracle Tablespace High water mark

Oracle Tablespace High water mark Tablespace High water mark Tablespace HWM col tablespace_name format a15col file_size format 99999col file_name format a50col hwm format 99999col can_save format 99999 SELECT tablespace_name, file_name, file_size, hwm, file_size-hwm can_saveFROM (SELECT /*+ RULE */ ddf.tablespace_name, ddf.file_name file_name,ddf.bytes/1048576 file_size,(ebf.maximum + de.blocks-1)*dbs.db_block_size/1048576 hwmFROM dba_data_files ddf,(SELECT file_id, MAX(block_id) maximum…
Continue reading →: Oracle Tablespace High water mark
RMAN Backup Optimization

RMAN Backup Optimization From 11G R1 onwards only undo data blocks containing undo data for not yet committed — or rolled back — transactions are backed up. Undo data in the undo tablespace still required to satisfy the undo retention but only containing undo records for already committed transactions are…
Continue reading →: RMAN Backup Optimization
TRIGGER TO GET SERVERERROR ON DATABASE

Lets create a trigger that will log all the errors in the database:It is better to create this trigger under SYS or DBA user’s so that you don’t have to grant all permission if you have to grant permissions separately. ——————————————————–— DDL for Trigger AFTER_ERROR——————————————————– CREATE OR REPLACE TRIGGER “AFTER_ERROR” AFTER SERVERERROR…
Continue reading →: TRIGGER TO GET SERVERERROR ON DATABASE
Find index skewed, rebuild

Find index skewed, rebuild Summary It is important to periodically examine your indexes to determine if they have become skewed and might need to be rebuilt. When an index is skewed, parts of an index are accessed more frequently than others. As a result, disk contention may occur, creating a…
Continue reading →: Find index skewed, rebuild