Steps to relocate database files using RMAN in Oracle

Relocate database files using RMAN In this example we will see how to relocate database files using RMAN from one location to another.In this blog we will see , how to relocate the entire database. Existing Location /wysheid/mydb Target location ...
Read More

Script to delete the older files automatically in linux

Script to delete the older files automatically in linux In this post we explain how to schedule a job in linux  to delete older  files automatically in Linux or Unix. Here , we are creating  a script to delete the  ...
Read More

How To Find The Size Of The Database

Steps to find the size of the database in Oracle Connect to the database SQL >  Connect / as sysdba Use the following command to find the size of the database SQL > select sum(bytes)/(1024*1024*1024) from dba_data_files; ...
Read More

Steps For Enabling Audit on SYS Operations

Steps For Enabling Audit on SYS Operations By default detailed Audit on SYS Operations ie activities with 'SYSDBA' and 'SYSOPER' privileges are not enabled . Here is the steps for enable Audit on SYS Operations Please note , by default ...
Read More

How to generate the index creation script from export dump in Oracle

Using Classical import utility  $ imp file=impdata.dmp   indexfile=/tmp/index.sql full=y rows=n log=imp.log Here the assumption is that impdata.dmp if the export dump file created by export utility. This command will create a file index.sql which contains the index information . Then ...
Read More
Loading...
Step by step Guide to Install 11g R2 RAC installation on Virtual Box RPM Requirement 64-bit (x86_64) Installations binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3 (32 bit) elfutils-libelf-0.125 elfutils-libelf-devel-0.125 elfutils-libelf-devel-static-0.125 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-24 glibc-2.5-24 (32 bit) glibc-common-2.5 glibc-devel-2.5 glibc-devel-2.5 (32 bit) glibc-headers-2.5 ksh-20060214 libaio-0.3.106 ...
Read More
Wallet creation in oracle 11g database $ echo $ORACLE_HOME $ echo $ORACLE_BASE $ echo $DB_UNIQUE_NAME make sure all above environment variables are set properly $ mkdir $ORACLE_BASE/admin/DB_UNIQUE_NAME/wallet $ orapki wallet create -wallet $ORACLE_BASE/admin/DB_UNIQUE_NAME/wallet -auto_login -pwd xxxxxx "-autologin: enables autologin by ...
Read More
Credentialstore in GoldengateUsually , while working with goldengate command line or parameter file , the goldengate admin username and password is not protected . This can be a security threat. Goldengate 12c addresses  this issue with the feature "Credentialstore" ...
Read More
Zero downtime database upgrade using Oracle Goldengate This document discuss about the setup of zero downtime database upgrade or migration using Oracle Goldengate. We will be covering the migration from Oracle Database to another oracle database. But the concept will ...
Read More
Instructions to change the hostname in Redhat Linux 7 and Oracle Enterprise Linux (OEL ) 7 ...
Read More
Step-1 : Create tuning task Here you need : 1) AWR snap ids begin snap (1001) 2) AWR end snap (1002) during sql execution time 3) sql id of your sql statement (sqlidxxxxxx) from your AWR report SET SERVEROUTPUT ON ...
Read More
To find transactions which are causing high archive log generation in oracle database  SELECT s.sid, s.serial#, s.username, s.program, i.block_changes FROM v$session s, v$sess_io i WHERE s.sid = i.sid ORDER BY 5 desc, 1, 2, 3, 4; SELECT s.sid, s.serial#, s.username, ...
Read More
How to find long running operations (long ops) in oracle ? set echo off  linesize 200  pages 1000  head on  feedback on col username format a10 col start_time format a15 col curr_time format a15 col osuser format a10 col opname format a35 col target ...
Read More
Script to find  session wait events in oracle database set linesize 1000 col p1 format 9999999 col p2 format 9999999 col program format a15 col event format a20 col event form a25 trunc head "Event| Waiting For" col command format ...
Read More
Loading...
Using below T-SQL select statement we can take table backup into new table Syntax: select * into new_table from old_table Example: use wysheid_db go SELECT * INTO dbo.wysheid_new from dbo.wysheid go ...
Read More
How to verify backups in sql server 1) RESTORE VERIFYONLY 2) RESTORE HEADERONLY 3) RESTORE FILELISTONLY 4) RESTORE LABELONLY --Backup is valid or not RESTORE VERIFYONLY FROM DISK = 'E:\SQLBAKUP\backuptest.bak' -- How many backup sets are there in your backup ...
Read More
This TSQL script returns Server Name, Cluster Node, Default Drive Letter, IP address and Port sqlserver cluster environment  SELECT SERVERPROPERTY('ServerName') as 'Server\Instance',  SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as 'Node',  (select left(af.filename,3)from sys.sysaltfiles af where af.name like '%MSDB%' and af.fileid = 1) as 'Drive',  ec.local_net_address ...
Read More
This T-SQL script will provide all privileges, roles and permission of particular user name in sql server database Replace your user name with  "YOUR_USER_NAME" in the below script  select sys.schemas.name 'Schema' , sys.objects.name Object , sys.database_principals.name username , sys.database_permissions.type permissions_type ...
Read More
A SQL Server database snapshot provides a read-only, static view of a source database as it existed at snapshot creation, minus any uncommitted transactions. Uncommitted transactions are rolled back in a newly created database snapshot because the Database Engine runs ...
Read More
Loading...
No posts found.