Category: Oracle DBA

  1. Home
  2. Oracle DBA
November 23, 2017

Memory and Process in Oracle generic note

MEMORY MANAGEMENT 11g ===================== http://blog.tanelpoder.com/2007/08/21/oracle-11g-internals-part-1-automatic-memory-management/ PGA+SGA=MEMORY_TARGET what are the shared memory IDs for my instance $ sysresv corresponding SysV SHM segments: $ ipcs -m mapped memory for an Oracle instance process – as the SGA should be definitely mapped there! $ pmap `pgrep -f lgwr` $ ls -l /dev/shm Removing Shared Memory Sometimes after an instance crash you may have […]

Read More
November 23, 2017

PLSQL Reference for DBA

PLSQL Reference for DBA PL/SQL stands for Procedural Language/SQL.PL/SQL extends SQL by adding control Structures found in other procedural language.PL/SQL combines the flexibility of SQL with Powerful feature of 3rd generation Language. The procedural construct and database access Are present in PL/SQL.PL/SQL can be used in both in database in Oracle Server and in Client side application development tools. Advantages […]

Read More
November 23, 2017

control files in general

What Is a Control File? Every Oracle database has a control file. A control file is a small binary file that records the physical structure of the database and includes: n The database name n Names and locations of associated datafiles and online redo log files n The timestamp of the database creation n The current log sequence number n […]

Read More
November 23, 2017

Redo log in general

Managing the Online Redo Log   Creating Online Redo Log Groups and Members Creating Online Redo Log Groups The following statement adds a new group of redo logs to the database: SQL>ALTER DATABASE ADD LOGFILE (‘/oracle/dbs/log1c.rdo’, ‘/oracle/dbs/log2c.rdo’) SIZE 500M; You can also specify the number that identifies the group using the GROUP option: SQL>ALTER DATABASE ADD LOGFILE GROUP 3  ‘/ORACLE/ORADATA/FRAME/REDO03.LOG’ […]

Read More
November 23, 2017

DBMS_CRYPTO example

SQL> CONN SYS/SYS AS SYSDBA Connected. SQL> set serveroutput on SQL> SQL> set linesize 121 SQL> SQL> DECLARE l_credit_card_no VARCHAR2(19) := ‘1234-5678-9012-3456’; l_ccn_raw RAW(128) := utl_raw.cast_to_raw(l_credit_card_no); l_key RAW(128) := utl_raw.cast_to_raw(‘abcdefgh’); l_encrypted_raw RAW(2048); l_decrypted_raw RAW(2048); BEGIN dbms_output.put_line(‘Original : ‘ || l_credit_card_no); l_encrypted_raw := dbms_crypto.encrypt(l_ccn_raw, dbms_crypto.des_cbc_pkcs5, l_key); dbms_output.put_line(‘Encrypted : ‘ || RAWTOHEX(utl_raw.cast_to_raw(l_encrypted_raw))); l_decrypted_raw := dbms_crypto.decrypt(src => l_encrypted_raw, typ => dbms_crypto.des_cbc_pkcs5, key => […]

Read More
November 22, 2017

FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL

FAST START FAILOVER (FSFO) CONFIGURATION USING  FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL   1.For data guard DGMGRL configuration and Far Sync setup please follow below link:- http://clouddba.co/step-step-oracle-active-data-guard-far-sync-rac/   2.Please check current database status DGMGRL> show database  ebilpd1;   Database – ebilpd1   Role:               PRIMARY Intended State:     TRANSPORT-ON Instance(s): EBILPD11 EBILPD12   Database Status: SUCCESS   DGMGRL> show […]

Read More
November 20, 2017

Script to sync check of applied archive log between 2 RAC databases

1.First create the shell script mentioning all environmental variables adjusted to your environment. vi dataguard_dr_sync_check.sh #!/bin/bash cd /u01/app/oracle/shells for k in ORCL do export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 export ORACLE_SID=$k $ORACLE_HOME/bin/sqlplus -S monitor@”$k”/xxx << EOF >> dataguard_dr_sync_check_orcl_`date +\%d\%m\%Y\%H`.log @dataguard_dr_sync_check_orcl.sql exit EOF done 2.For 2 node RAC,below will be dataguard_dr_sync_check_orcl.sql script .For 4 nodes,just add another 2 sql with thread and union […]

Read More
November 19, 2017

RMAN incremental Backup cumulative and differential

RMAN Incremental backup This backups only datafile blocks changed since specified previous backup. 1.This strategy could be followed to make incrementally updated backup .These incrementally updated backup will be used to make updated image copy will all roll forward image. 2.Reduce amount of time to take backup. 3.Save network bandwidth To be able to recover changes to objects created with […]

Read More
November 18, 2017

ASM overview and commands

  Automatic Storage Management (ASM) A.Overview of Automatic Storage Management (ASM) Automatic Storage Management (ASM) simplifies administration of Oracle related files by allowing the administrator to reference disk groups rather than individual disks and files, which are managed by ASM. The ASM functionality is an extention of the Oracle Managed Files (OMF) functionality that also includes striping and mirroring to […]

Read More

Debasis Maity

Translate

Ad

Please connect me in linkedin

Top Posts & Pages

Follow Us