Friday, June 25, 2010

Oracle Database Growth Report

›
select sum(space_used_delta) / 1024 / 1024 "Space used (M)", sum(c.bytes) / 1024 / 1024 "Total Schema Size (M)", round(s...

Database Growth Monitoring Script

›
Step : 1 Calculate total Size of tablespace select sum(bytes)/1024/1024 "TOTAL SIZE (MB)" from dba_Data_files Step : 2 Calculate F...
Thursday, June 24, 2010

Oracle User Login Lock Wrong Attempt details

›
select username,osuser,machine,blocking_session from v$session where username='LDBO'; select username,os_username,to_char(timestamp,...
Wednesday, June 9, 2010

Oracle Password Policy

›
-- This script sets the default password resource parameters -- This script needs to be run to enable the password features. -- However th...
Tuesday, June 8, 2010

Restore Database when source database(E:) and destination database location(D:) is different

›
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\archive1011\sns1011\%F'; CONFIGURE CHANNEL DEVICE TYPE DISK FORM...

Oracle 10g 32 bit at Window 7 (64 bit)

›
go to this folder “E:\Installers\Oracle_10g_1023\Disk1\stage\prereq\db” locate the file “refhost.xml”, open it with notepad now add the foll...

meta tags format

›
=============================== no...

Oracle Standby Database / Diaster recovery Solution

›
-----------------I. Before you get started:------------------- 1. Make sure the operating system and platform architecture on the primary an...

Oracle RMAN Duplicate Database / Clone Database

›
Configure The Network We need to configure the network so that there is connectivity to the target (source) database and to the database we ...
Thursday, May 20, 2010

Oracle Export Backup Job Email Notification

›
---------------------------------------------Export.bat--------------------------- @ECHO off SETLOCAL IF [%1]==[] goto s_start ECH...

Oracler RMAN Job Email Notification

›
------------------------------------------------RMAN.bat-------------------- @ECHO off SETLOCAL IF [%1]==[] goto s_start ECHO GETDA...
Tuesday, April 20, 2010

Reuse statements, cursor_sharing=force

›
Reuse statements select * from emp where ename = :EMPNAME select * from v$parameter where name like '%cursor_sharing%'; cursor_shari...

Oracle Flushing-Pinning PL/SQL packages, FLUSH SHARED POOL

›
Oracle Flushing-Pinning PL/SQL packages, FLUSH SHARED POOL http://www.remote-dba.cc/oracle_tips_flushing_secrets.htm 1. Pinning all com...
Tuesday, April 13, 2010

RMAN Block Corruption Detection & Recovery

›
Block Media Recovery with RMAN sql>select file# block# from v$database_block_corruption; --corrupted block Rman>> block recover da...

RMAN recover & open database if archive log missing

›
RMAN recover and open the database if the archive log required for recovery is missing 1) Set _ALLOW_RESETLOGS_CORRUPTION=TRUE in init.ora f...

RMAN recovery from loss of all online redo log files

›
RMAN recovery from loss of all online redo log files SQL> select thread#,sequence#,status from v$Log; set oracle_sid=sns6 rman Target SYS...
Monday, April 12, 2010

Uninstall Oracle from Server Completely

›
Uninstall Oracle # Stop any Oracle services that have been left running. Start->Settings->Control Panel->Services Look for any serv...

Create a Oracle Database Server Using RMAN backup from another Server

›
Create a Oracle Database Server Using RMAN backup from another Server 1) install Oracle server 10.2.0.3 without create startup database ----...

RECOVER THE DATABASE IN DIFFERENT SERVER ON DIFFERENT DIRECTORY FROM ACTUAL BACKUP LOCATION DIRECTORY

›
SCENIRIO IS I HAVE TAKEN RMAN BACKUP ON A SERVER IN D:\ARCHIVE0910\SNS1011\ LOCATION AND COPY THE BACKUP SET TO B SERVER IN DIFF. DIRECTORY ...
Friday, March 26, 2010

Linux lock unlock user account

›
----------------------------script.sh--------------- #! /bin/sh ### BEGIN Script INFO # # Befor Usering it please check the user name # file...