ORACLE Patch (OPatch)

Posted on 184 CommentsPosted 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 205 CommentsPosted 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 80 CommentsPosted 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 203 CommentsPosted 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 194 CommentsPosted 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 77 CommentsPosted 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 173 CommentsPosted 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 69 CommentsPosted in Uncategorized

Only FLASHBACK DATABASE requires flashback to be ‘ON’ since only FLASHBACK DATABASE uses flashback logs in the flash_recovery_area. All other forms of FLASHBACK use the recycle bin and undo_tablespace. Important info: You cannot ‘flashback table to before drop’ a table which has been created in the SYSTEM tablespace. The table is sent to the recyclebin […]

Oracle DBA day to day activity

Posted on 205 CommentsPosted 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 […]