-
Create a sample schema with 1millions rows in Oracle
Continue reading →: Create a sample schema with 1millions rows in OracleWe always to test the database for various reasons we will need to create a tables with a lot of data in it.We can use below script that will allow us to create a table and populate the table with…
-
How to Add/Drop/Rename Standby Redolog file
Continue reading →: How to Add/Drop/Rename Standby Redolog fileHow 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…
-
Oracle Active Data Guard Or Oracle GoldenGate
Continue reading →: Oracle Active Data Guard Or Oracle GoldenGateOracle 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…
-
TOAD USER SCRIPT
Continue reading →: TOAD USER SCRIPTSCRIPT 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…
-
Monitoring standby database made easy
Continue reading →: Monitoring standby database made easywe 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…
-
ORA-00301: error in adding log file ‘stdby02.log’ – file cannot be created
Continue reading →: ORA-00301: error in adding log file ‘stdby02.log’ – file cannot be createdSQL> 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…
-
How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases
Continue reading →: How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databasesHow 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…
-
Oracle Tablespace High water mark
Continue reading →: Oracle Tablespace High water markOracle 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…
-
RMAN Backup Optimization
Continue reading →: RMAN Backup OptimizationRMAN 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…
-
TRIGGER TO GET SERVERERROR ON DATABASE
Continue reading →: TRIGGER TO GET SERVERERROR ON DATABASELets 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…



