Translate this Page

 

How To Create Physical Standby Database – Oracle10g
Primary :

  • Host : primsvr
  • ORACLE_SID : orcl
  • service names : primdb

Standby :

  • Host : stbysvr
  • ORACLE_SID : orcl
  • service names : stbydb

Steps to configure Oracle Data Guard :

Continue reading »

 

In This Challenge, We have a Linux 32bit Server (RHEL 4) with 8GB Memory. But we can’t configure the database memory (SGA+PGA) more than 4GB.  To solve this problem then we could configure Very Large Memory (VLM) and Big SGA for Oracle RDBMS with ramfs and Hugepages.

Complete the following procedure to configure VLM on the computer:

1. Log in as a root user:

2. Edit the /etc/rc.local file and add the following entries to it to configure the computer to mount ramfs over the /dev/shm directory, whenever you start the computer: Continue reading »

 

When we did a cloning/recover the database with noarchivelog mode, we got the problem that some datafile need to be recover. It will be difficulty since no archivelog that can help us to recover it. Otherwise we can copy all datafiles from offline backup of the source database. But it will takes time to copy/ftp/restore especially if the database size are hundreds GB or even TB. But there is a solution to recover the database with noarchivelog mode, please check this out : 
When we did a cloning, startup nomount :           

$ sqlplus '/as sysdba' 
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Apr 13 13:54:43 2010 
Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 
Connected to an idle instance. 
SQL> startup nomount pfile=initMYDB.ora
ORACLE instance started. 
Total System Global Area 5251268608 bytes
Fixed Size 2091368 bytes
Variable Size 1040189080 bytes
Database Buffers 4194304000 bytes
Redo Buffers 14684160 bytes 
 

In our finance database (Oracle EBS 11.5.9), I found there is a big snapshot log. I found AP.MLOG$_AP_INVOICE_DISTRIBUT has size more than 21 GB and still growing. The size of the tablespace APD is 26 GB, so that snapshot log has consume more than 80% of tablespace APD.

First of all, I analyze which is the master table that used this snapshot log.

 

SELECT MASTER, log_table, snapshot_id

  FROM dba_snapshot_logs

 WHERE log_table = ‘MLOG$_AP_INVOICE_DISTRIBUT’;

  Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha