ORACLE Patch (OPatch)

Posted on Leave a commentPosted in Uncategorized

CPU, PSU, SPU – Oracle Critical Patch Update Terminology Update Oracle Database, Oracle Critical Patch Updates It all started in January 2005 with Critical Patch Updates (CPU).  Then Patch Set Updates (PSU) were added as cumulative patches that included priority fixes as well as security fixes.  As of the October 2012 Critical Patch Update, Oracle […]

My SQL Galera Setup

Posted on Leave a commentPosted in Uncategorized

Reference : https://blog.laimbock.com/2014/07/08/howto-setup-mariadb-galera-cluster-10-on-centos/ root@150.236.10.8 (Login to the Server using Root user) 1.configure the /etc/hosts 150.236.10.8 db1 150.236.10.9 db2 150.236.10.10 db3 now put SELinux into permissive mode on all nodes 2. setenforce 0 3. configure the firewall lokkit –port 3306:tcp lokkit –port 4444:tcp lokkit –port 4567:tcp lokkit –port 4568:tcp 4.download rpm sofware from http://yum.mariadb.org/10.0/rhel6-amd64/ 5.Configure yam […]

SQL Server Manual Failover

Posted on Leave a commentPosted in Uncategorized

This technical document is about Manual failover in SQL Server —————————————————————- To achieve maximum availability we need to configure Mirror Server which requires for Failover in case of Primary server is not available. When Primary server availability is assured then we again failover back to Primary. We need to perform this activity manually. To manually […]

ASM Basic

Posted on Leave a commentPosted in Uncategorized

ASM Login and Check Space: set the environment . oraenv +ASM1 shadb@sha01:~$ asmcmd -p ASMCMD [+] > ls SHAPROD_DATA01/ SHAPROD_RECO/ ASMCMD [+] > lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 4194304 29491200 13181264 614400 6283432 0 Y SHAPROD_DATA01/ MOUNTED NORMAL N 512 4096 […]

RMAN

Posted on Leave a commentPosted in Uncategorized

RMAN: Basic RMAN Commands Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. RMAN  provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems. Below are some of the commonly used RMAN commands which you can […]

FLASHBACK DATABASE

Posted on Leave a commentPosted in Uncategorized

Please keep in mind till the Transactions are in Undo until then the DB can be restored .. To take Restore Point .. SQL> select flashback_on from v$database; FLASHBACK_ON —————— NO SQL> Alter database flashback on; CREATE RESTORE POINT Jan07_2107; conn / as sysdba shutdown immediate; startup mount; flashback database to restore point Jan07_2107; alter database […]

FLASHBACK SESSION

Posted on Leave a commentPosted in Uncategorized

Changing the session time in back –step 1 select * from REGION_ANI; begin dbms_flashback.enable_at_time(to_timestamp(’12-03-14 17:26:06′,’dd-mm-yy hh24:mi:ss’)); end; –step 2 select * from REGION_ANI; –step 3 begin dbms_flashback.disable; end; –run below commands from sys user –grant execute on dbms_flashback to claims; –create synonym claims.dbms_flashback for dbms_flashback; The syntax for enabling flashback query will accept either a […]

FLASHBACK TABLE

Posted on Leave a commentPosted in Uncategorized

select * from REGION_ANI as of timestamp to_timestamp(’12-03-14 17:26:06′,’dd-mm-yy hh24:mi:ss’);– as per old version(before commit) select * from REGION_ANI as of timestamp to_timestamp(’12-03-14 17:26:06′,’dd-mm-yy hh24:mi:ss’) minus select * from REGION_ANI — deleted rows

Oracle DBA day to day activity

Posted on Leave a commentPosted in Uncategorized

Tablespace size and uses set linesize 230 SELECT Total.name “TABLESPACE_NAME”, nvl(Free_space, 0) FREE_SPACE, nvl(total_space-Free_space, 0) USED_SPACE, total_space,round((nvl(free_space,0)/nvl(total_space,0)*100),2) “PCTFREE” ,round((nvl(total_space-free_space,0)/nvl(total_space,0)*100),2) “PCTUSED” FROM (select tablespace_name, sum(bytes/1024/1024) Free_Space from sys.dba_free_space group by tablespace_name ) Free, (select b.name, sum(bytes/1024/1024) TOTAL_SPACE from sys.v_$datafile a, sys.v_$tablespace B where a.ts# = b.ts# group by b.name ) Total WHERE Free.Tablespace_name(+) = Total.name order […]