Create an alert of failed login attempt of users in Oracle database 11gR2 (11.2.0.4) [oracle@testdb ~]$ !sq sqlplus /as sysdba sys@TESTDB> select instance_name,status,version from v$instance; INSTANCE_NAME    STATUS       VERSION ———————————————————— testdb                          … Read more..

How to take the Online Fulldb backup using Backup Script in Oracle 11gR2 Database Status sys@TESTDB> select instance_name,status,version from v$instance; INSTANCE_NAME    STATUS       VERSION —————- ———— —————– testdb           OPEN         11.2.0.4.0 Create  the script… Read more..

Script to Delete Log Files in Oracle Database by using the Crontab Job The given script is tested in our test env The logfiles are deleTrace File i.e (,trc,.trm) , Audit File (.aud), Listener log (.trc,.trm) & .xml files In order to manage space in better way, the best practice is to clear the logs Read More

Script to verify the database for Primary & standby [oracle@Prim-DB ~]$ cd /home/oracle/scripts/ [oracle@Prim-DB scripts]$ vi dblogsummary.sql !df -h !free !uptime !last reboot set linesize 500 col host_name format a40; select INST_ID,instance_name,STARTUP_TIME,status,archiver from gv$instance; select name,log_mode,protection_mode,… Read more..

Script to check the datafile size used in Oracle database [oracle@testdb scripts]$ pwd /home/oracle/scripts [oracle@testdb scripts]$ cat checkdf.sql SET PAUSE ON SET PAUSE ‘Press Return to Continue’ SET PAGESIZE 60 SET LINESIZE 300 COLUMN “Tablespace Name” FORMAT A20 COLUMN “File Name” FORMAT A80 SELECT… Read more..

Script to check the tablespace size used in Oracle database [oracle@testdb scripts]$ pwd /home/oracle/scripts [oracle@testdb scripts]$ cat checktbs.sql set linesize 180 set pagesize 30 select fs.tablespace_name “Tablespace”, (df.totalspace – fs.freespace) “Used MB”, fs.freespace “Free MB”, df.totalspace… Read more..