Ameer Khan

Oracle Version :- 11gOs Version:-    Rhel 6.4 To demonstrate this scenario we need some corrupted datablocks on some data files. It’s possible to perform Block Media Recovery with having only OS based “hot” backups and having NO RMAN backups. Step 1. Create a new user and a table in that schema[oracle@server1 ~]$ sqlplus / … Continue Reading

How to take Hot backup & restore in  Oracle 11gR2 database:- Step 1:-Prerequisites:-$Select log_mode from v$database;If the database is not in archivelog mode then put the database in the archive log modesql>shut immediate;sql>startup mount;sql>alter database archivelog ;sql>alter database open; Step 2:-Taking a hot backup- Now that we have prepared our database for a hot backup,… Continue Reading

ORA-00018 maximum number of sessions exceeded Cause: All session state objects are in use.Action: Increase the value of the SESSIONS initialization parameter. How to increase PROCESSES initialization parameter: 1.Login as sysdbasqlplus / as sysdba 2. Check Current Setting of Parameters:- SQL> show parameter sessions NAME                    … Continue Reading

Oracle GoldenGate Command InterpreterGGSCI   — (Oracle) GoldenGate Software Command Interpreter How to interpret:-oracle$cd $GGATEororacle$cd /i01/app/oracle/product/gg [oracle@prod gg]$ ./ggsci Commandsggsci> HELP [command] [object]ggsci> help GGSCI Command Summary: Object:          Command:SUBDIRS          CREATEER                   INFO, KILL, LAG, SEND, STATUS, START, STATS, STOPEXTRACT… Continue Reading

RMAN’s change tracking feature for incremental backups improves incremental backup performance by recordingchanged blocks in each datafile in a change tracking file. If change tracking is enabled, RMAN uses thechange tracking file to identify changed blocks for incremental backup, thus avoiding the need to scanevery block in the datafile. Prior to 10.2, all incremental backups… Continue Reading

Step 1:-Backup your current control file with a trace optionSQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Database altered. Step-2: List all the controlfiles SQL> select name from v$controlfile; NAME———————————————————/u01/app/oracle/oradata/prim/control01.ctl/u01/app/oracle/flash_recovery_area/prim/control02.ctl Step-3 Shutdown the databaseSQL> shut immediate;Database closed.Database dismounted.ORACLE instance shut down. Step 4:-Add one more controlfile[oracle@server1 prim]$cp /u01/app/oracle/oradata/prim/control01.ctl /home/oracle/Multiplexed_control_files/control03.ctl Step-5: Create PFILE using SPFILE[oracle@server1 dbs]$ sqlplus… Continue Reading

ORA-00000: normal, successful completion This error may occur in many circumstances you need to check environment variables:$ORACLE_HOME$ORACLE_BASE$ORACLE_SIDalso check /etc/hosts file it must contains correct hostname and ip.example: [oracle@oel6 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 1 9:12:17 2014 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected.SQL> startup;ORA-01012: not logged… Continue Reading

We need to create a trigger for this purpose. [oracle@server1 ~]$ sqlplus /  as sysdba SQL> create user sam identified by sam; User created. SQL> grant connect , resource to sam; Grant succeeded. SQL> conn sam/samConnected.SQL> exit [oracle@server1 ~]$ sqlplus /  as sysdbaSQL> CREATE OR REPLACE TRIGGER limit_connection         AFTER LOGON ON DATABASE … Continue Reading

How to kill session:1. identify which session to kill using following query:SQL>  select  s.sid,  s.serial#,  spid,  trim(s.machine) machine,  trim(s.module) module,  status from  v$session s,  v$process p where  paddr=addr  and module is not null order by 1,2      SID    SERIAL# SPID                 MACHINE              MODULE… Continue Reading

The below scripts will identify the Database Idle Session .When on firing the below the scripts, it will prompt for the number of minutes the session is idle for. [oracle@server1 ~]$ sqlplus / as sysdba SQL> set linesize 140 SQL> col username format a15 SQL> col idle format a15 SQL> col program format a30 Now… Continue Reading