ARCHIVED REDO LOGFILE MANAGEMENT

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 »

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 »

How to install Oracle 11g Grid Infrastructure software and step by step process for ASM configuration

Tools and Software’s used for this Demonstration: VMware Workstation 10.0 Oracle Enterprise Linux 6.0 (64-Bit) Oracle Grid Infrastructure software 11.2.0.1 (64-Bit) Oracle Database software 11.2.0.1 (64-Bit) Step 1:  Install prerequisites packages for Oracle Database. You can get them from link  as per your operation system version. Step 2: Setup ASM …

Read More »

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. In order to configure ASM storage and move existing database from normal File System to ASM, follow below steps: Step 1: Check locations for data files, control files, redo log files and temp files on …

Read More »

INS-41814 The installer has detected that some of the services of Oracle Grid Infrastructure are not running on this system.

ERROR DESCRIPTION ================= INS-41814 The installer has detected that some of the services of Oracle Grid Infrastructure are not running on this system. ERROR DETAILS ============= CRS-4124: Oracle High Availability Services startup failed. CRS-4000: Command Start failed, or completed with errors. ohasd failed to start: Inappropriate ioctl for device Read …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe