control files in general
What Is a Control File? Every Oracle database has a control file. A control file is a small binary file…
7 years ago
Redo log in general
Managing the Online Redo Log Creating Online Redo Log Groups and Members Creating Online Redo Log Groups The following…
7 years ago
Materialized View Example
ORASOA side: create table tab1(c1 char(10),c2 char(10),c3 char(10)); begin for i in 1..10000 loop insert into…
7 years ago
All about table and constraints in Oracle
CREATING ORACLE DATABASE OBJECTS CREATING TEMPORARY TABLES SQL>CREATE GLOBAL TEMPORARY TABLE TEMP_EMP (EMPNO NUMBER,ENAME VARCHAR2(10)) CREATING ONE TABLE…
7 years ago
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)…
7 years ago
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…
7 years ago
Step by Step Oracle Active Data Guard Far Sync RAC
Step by Step Oracle Active Data Guard Far Sync RAC Active Data Guard Far Sync, a new capability with…
7 years ago
Clean *.trc ,*.trm and *.aud older than 1 day clean oracle home
#!/bin/bash . /home/oracle/.bash_profile export log=/u01/app/oracle/shells/clean_rdbms_audit.log echo $ORACLE_HOME | tee $log echo "DELETING AUDIT LOGS FROM RDBMS" | tee -a $log…
7 years ago
Tablespace usage considering autoextend on
This script will show tablespaces from all databases in server which are full by 85 percent.This script will take care…
7 years ago
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…
7 years ago