Oracle Miscellaneous

Posted on 571 CommentsPosted in Uncategorized

YUM Local Copy Packages folder from OEL Software disk to the local destination e.g to /u01/Packages then copy repodata folder from OEL Software disk to /u01/repodata and copy RPM-GPG-KEY-oracle  from OEL Software disk to /u01/Packages/ inside /etc/yum.repos.d/ create file local.repo and  wirte the following lines and delete all existing .repo files [local] name=local baseurl=file:///u01/ gpgkey=file:///u01/Package/RPM-GPG-KEY-oracle […]

ORACLE Patch (OPatch)

Posted on 32 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 21 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 8 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 11 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 16 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 11 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 8 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 7 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 […]