Creating Recovery Catalog in RMAN

Step by step instructions to create recovery catalog using RMAN ...
Read More

Tuning SQL statements using SQL Tuning advisory in oracle database

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

RMAN Compressed Backup : Learn to reduce the size of Oracle Database Backups

Step by step instructions on reducing the size of Oracle database using RMAN Compressed backup. This document covers the changes in both 11g & 12c versions ...
Read More

Execute OS Commands From RMAN

Execute OS Commands from RMAN Many a time while working with RMAN , we may want run some OS Commands. This video tutorial explains to how to execute OS Commands from RMANHappy Learning Wysheid Team ...
Read More

Oracle database Patching: difference between PSU, CPU & SPU

Oracle database Patching: difference between PSU, CPU and SPU Database patching and upgrading is one of the most repeated and time consuming activity of an Oracle database administrator. Oracle regularly releases different type of patches, like CPU, PSU, SPU, so ...
Read More
Loading...
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
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
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
How to check all sessions information (active and inactive) in oracle database ? set echo off   linesize 200  pages 1000  head on  feedback on col sid head "Sid" form 9999 trunc col serial# form 99999 trunc head "Ser#" col username form a8 trunc ...
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
Loading...
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
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
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.