Arvind Toorpu

Blog Posts

  • 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 we will see the table…

  • 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                                 IGNED SQL> alter database drop…

  • 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  with a common table t1…

  • 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 FROM dba_extents GROUP BY file_id)…

  • 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 not backed up anymore. Nice…

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts