Sha Infotech is a DBA Training Center in Kolkata

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

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

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

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

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

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

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