vishwanath-dbahelp.blogspot.com
Oracle help at your desk....:-): 02/01/2012 - 03/01/2012
http://vishwanath-dbahelp.blogspot.com/2012_02_01_archive.html
Oracle help at your desk.:-). My blog is all about sharing and learning oracle.Please test before you apply anything on production.You may reach to me at vishwanathsh82@gmail.com. Friday, February 3, 2012. RMAN BACKUP VALIDATION AND RECOVERY FROM BLOCK CORRUPTION:. The main purpose of RMAN validation is to check for corrupt blocks and missing files. Physical(media corrupt) and Logical(software corrupt) Block Corruption:. In a physical corruption. In a logical corruption. BACKUP VALIDATE CHECK LOGICAL DAT...
vishwanath-dbahelp.blogspot.com
Oracle help at your desk....:-): 05/01/2011 - 06/01/2011
http://vishwanath-dbahelp.blogspot.com/2011_05_01_archive.html
Oracle help at your desk.:-). My blog is all about sharing and learning oracle.Please test before you apply anything on production.You may reach to me at vishwanathsh82@gmail.com. Tuesday, May 31, 2011. Difference between Cloning and Refreshing of a database. Well let’s have a look on the above activities that helps in finding the differences between them. What is a Database Clone? Though, it is possible to clone a database on the same server, Oracle doesn’t suggest to clone a database on the same ...
vishwanath-dbahelp.blogspot.com
Oracle help at your desk....:-): 01/01/2012 - 02/01/2012
http://vishwanath-dbahelp.blogspot.com/2012_01_01_archive.html
Oracle help at your desk.:-). My blog is all about sharing and learning oracle.Please test before you apply anything on production.You may reach to me at vishwanathsh82@gmail.com. Wednesday, January 25, 2012. Difference between WITH GRANT and WITH ADMIN. Sometimes people are puzzled to find out the difference between WITH GRANT and WITH ADMIN. Here is the simple explanation:. We can grant object privileges only with grant option like (select,update,insert). A- - - - - B- - - - - C. A- - - B- - - - C.
raheeldba.wordpress.com
Raheel Syed | Raheel's Blog
https://raheeldba.wordpress.com/author/raheeldba
Things I have learnt as Oracle DBA. Author Archives: Raheel Syed. ICACLS – A magic command. July 10, 2015. One of our colleague was configuring Auditing on MSSQL Server using Arcsight (more info about the tool can be found here ) and one of the steps is to create SQLTRACE folder and SHARE the folder and provided the necessary … Continue reading →. ORA-01791: not a SELECTed expresssion. January 8, 2015. Not a SELECTed expression. Patching through OEM 12c in Offline mode. February 5, 2014. February 4, 2014.
raheeldba.wordpress.com
Scripts | Raheel's Blog
https://raheeldba.wordpress.com/scripts
Things I have learnt as Oracle DBA. 1) Find out whether Oracle software installed and database created 32Bit or 64Bit? 2) Extract the DDL using DBMS METADATA.GET DDL Function To extract the DDL from dbms metadata. Ps -eo pcpu,pid,user,args sort -k 1 -r head -30. List processes by mem (KB) usage:. Ps -e -orss=,pid,user,args= sort -b -k1,1n pr -TW$COLUMNS. List processes by % cpu usage:. Ps -e -o pcpu,cpu,nice,state,pid,user,cputime,args –sort pcpu sed ‘/ 0.0 /d’. List all threads for a particular process:.
vishwanath-dbahelp.blogspot.com
Oracle help at your desk....:-): 06/01/2011 - 07/01/2011
http://vishwanath-dbahelp.blogspot.com/2011_06_01_archive.html
Oracle help at your desk.:-). My blog is all about sharing and learning oracle.Please test before you apply anything on production.You may reach to me at vishwanathsh82@gmail.com. Tuesday, June 28, 2011. Cloning of database through OEM. It is a very simple and fastest way to clone a database through OEM(Oracle Enterprise Manager). First of all set DB CREATE FILE DEST as follows on target database. SQL Alter system set DB CREATE FILE DEST= 'D: app Bishwanath product 11.2.0 dbhome 1 oradata';. Since we hav...
vishwanath-dbahelp.blogspot.com
Oracle help at your desk....:-): 04/01/2012 - 05/01/2012
http://vishwanath-dbahelp.blogspot.com/2012_04_01_archive.html
Oracle help at your desk.:-). My blog is all about sharing and learning oracle.Please test before you apply anything on production.You may reach to me at vishwanathsh82@gmail.com. Friday, April 27, 2012. Why should we perform consistent export? It makes all of the queries run by exp be "as of the same point in time- consistent with. Imagine if you started an export at 9am of the EMP and DEPT tables. EMP started exporting at 9am and DEPT at 9:15am. You import that data now - will it work? Oracle 12c: Inde...
vishwanath-dbahelp.blogspot.com
Oracle help at your desk....:-): 09/01/2011 - 10/01/2011
http://vishwanath-dbahelp.blogspot.com/2011_09_01_archive.html
Oracle help at your desk.:-). My blog is all about sharing and learning oracle.Please test before you apply anything on production.You may reach to me at vishwanathsh82@gmail.com. Friday, September 30, 2011. How To Check Whether Physical Standby is in Sync with the Primary or Not? The following tips will help you in monitoring sync between primary and standby databases. 1 Check for GAP on standby. 2 Check redo received on standby. 3 Check redo applied on standby. ORDER BY 1;. B On Physical Standby. If qu...
pravinsingh.wordpress.com
Objection, Me Lord! – Pravin Singh
https://pravinsingh.wordpress.com/2011/08/18/objectionmelord
Worthless thoughts of a creative idiot. Objection, Me Lord! So I am trying here to respond to some of such allegations. While doing so, I will put my leaning towards civil society behind, and use only argumentative logic and verifiable facts (lawyers seem to be in-charge of our government, so I am using a language they understand):. Only parliament can make the laws, no one else. Civil society is adamant on getting only their version passed. We do not have a magic wand to end all corruption. Nor do we ha...
SOCIAL ENGAGEMENT