Author: Animesh Kumar

CPU, PSU, SPU – Oracle Critical Patch Update Terminology Update Oracle Database, Oracle Critical Patch Updates It all started in January 2005 […]

https://oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-6 lab128.com/rac12_installation_using_vb/article_text.html https://docs.oracle.com/database/121/ADMIN/cdb_create.htm#ADMIN14210    

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

This technical document is about Manual failover in SQL Server —————————————————————- To achieve maximum availability we need to configure Mirror Server which […]

ASM Login and Check Space: set the environment . oraenv +ASM1 shadb@sha01:~$ asmcmd -p ASMCMD [+] > ls SHAPROD_DATA01/ SHAPROD_RECO/ ASMCMD [+] […]

RMAN: Basic RMAN Commands Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle […]

Please keep in mind till the Transactions are in Undo until then the DB can be restored .. To take Restore Point […]

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

Only FLASHBACK DATABASE requires flashback to be ‘ON’ since only FLASHBACK DATABASE uses flashback logs in the flash_recovery_area. All other forms of […]

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