Monday , December 18 2017

TimeLine Layout

December, 2017

  • 11 December


    ARCHIVELOG MANAGEMENT: A database has ARCHIVELOG and NOARCHIVELOG modes. We can can query “archive log list” to know your database archive log mode. When the database is in NOARCHIVELOG mode, redo log files will get overwritten each time all the redo groups are switched and we cannot have backups of …

    Read More »

November, 2017

  • 30 November

    MySQL DBA Interview Questions and Answers

    mysql dba interview questions

    MySQL Interview Questions Before you even start asking questions pay attention to how YOU pronounces MySQL. The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”), but we do not mind if you pronounce it as “my sequel” or in some other localized way. The reason …

    Read More »
  • 23 November

    oracle 12c Release Install – PRVF-0002 : could not retrieve local node name

    PRVF-0002 : could not retrieve local node name

    Error:- PRVF-0002 : could not retrieve local node name if you face this type of error while installing Oracle 12c Release 2 , make sure see you hostname if not properly set, change it with a proper name. Here you can find my host name dbacentre save and if your …

    Read More »

October, 2017

September, 2017

August, 2017

  • 5 August

    How To Add New Disk To The Existing Disk Groups in ASM

    Process to check existing Disk Groups:  Step 1: Export oracle SID for ASM instance and connect sqlplus as sysasm user. Step 2: We can use v$asm_diskgroup to query existing disk groups information. NOTE: You can see that there are 2 disk groups are available. Step 3: In order to check …

    Read More »

Your information will never be shared
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.