My SQL Galera Setup

Posted on 204 CommentsPosted in Uncategorized

Reference : root@ (Login to the Server using Root user) 1.configure the /etc/hosts db1 db2 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 rpm sofware from 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 202 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 […]


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 […]


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 […]


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 […]


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 204 CommentsPosted in Uncategorized

Tablespace size and uses set linesize 230 SELECT “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, sum(bytes/1024/1024) TOTAL_SPACE from sys.v_$datafile a, sys.v_$tablespace B where a.ts# = b.ts# group by ) Total WHERE Free.Tablespace_name(+) = order […]


Posted on 84 CommentsPosted in Uncategorized

RAC 11g useful commands Check the status of the cluster [oracle@rac1 ~]$ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [oracle@rac1 ~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is […]