Hello Readers,
Sharing knowledge is the ultimate key to gaining knowledge…
The only two things that stay with you for life are you & your knowledge...
Live while you can! Teach & inspire while you could & Smile while you have the teeth.
-
ASM
- Creating ASM Instance and diskgroups manually without DBCA
- 20 ASM Realtime | Interview Questions
- How to make a cold backup for database running on ASM ( using RMAN )
- Moving a Single Datafile from File System to ASM System (METHOD 1)
- Moving a Single Datafile from File System to ASM System (METHOD 2)
- Things to consider while adding new disk/ Rebalancing existing Disk Group
-
Dataguard
- Dataguard Modes
- Dataguard Modes - II
- Oracle DataGuard Setup
- invalid archived log deletion policy
- recover from the Loss of a Datafile on a Standby Database ?
- MRP terminated with ORA-00600: internal error code, arguments
- Recover archive gaps in standby database - using 2 methodss
- Gap Resolution in Dataguard
- Convert Physical Standby to Snapshot Standby and Vice Versa
- Re-create Redo-logs on Standby/ Primary
- Pre-check for DataGuard switchover Process
- ORA-19815: WARNING: db_recovery_file_dest_size
- How do you purge old archivelogs which are applied on Standby DB
- Pre-check For SWITCHOVER using DG Broker
- https://oracle-dba-help.blogspot.com/2016/03/data-guard-modes.html
- ORA-01274 : RENAME THE UNKNOW FILE IN THE STANDBY DATABASE
- Database Creation in Easy 6 Steps
- Oracle Networking
- Tablespace management
- Housekeep : Quick Tips for DBA
- Health check for DB
- ORA-12537 While Connecting To Database Via Listener
- How to identify the applied patche-set of your Oracle Home
- Accessing a schema without knowing the password
- ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
- Session Related Scripts
- How to check ORA Error on DB Server – Beginner Tip
- Working with Redo Logs
- Decommission of Oracle Database
- Roles in Oracle - Managing Users
- Oracle Release Number Format
- Troubleshooting Handy-Guide
- Understanding the Upgradation Process
- Query to find the session creating more redo
- Audit in Oracle
- Troubleshooting Internal Errors and Error-Look-up Tool on MOS
- Troubleshooting Issues with Undo Tablespace
- User Management
- User Management - II
- Data Pump Gets Better
- MEMORY_TARGET Parameter
- Installing PostgreSQL Server on CentOS, RHEL 6 / 7 Systems
- Creating a database in Postgres
- Initialize multiple Postgres instance on the same RHEL server
- How to stop starting of clusters while starting up services
- Setup a streaming replication
- Switchover- master server and warm standby (with streaming replication)
- All About Physical Replication and Log shipping
- PostgreSQL Upgrade and troubleshooting
- Timeline Switch issue
- Query to identify the lag in replication
- Drop table : ERROR: must be owner of relation table_name
- PgBadger
- PgCenter
- PgTune
- Internals of Toast Table
- Influencing Query Execution Plan
- Create Extension ERROR
- Find Uptime in PostgreSQL
- Set DB Timezone
- Clear RAM Cache, Buffer
- Read-Only User in Postgres
- Everything you need to know about Streaming Replication
- Ora2Pg Migrate Oracle to Postgres
- Total Page Cost
- PostgreSQL 13 - Everything you need to know
- Startup Failure - .conf file
- All About Postgres Upgrade
- Basic Guide
- Session Related Scripts
- AWR :: Beginners Guide
- All About ASH - Active Session History
- Wait Events : checkpoint busy waits or archiver busy waits
- Find sessions performing sort operations : TEMP Tablespace occupants
- Generate ADDM task and generate its report for Tuning
- Database Performance Tuning Scripts -Keep Handy
- Buffer Busy Wait
- Simulating the Deadlock
- Latches
- Steps to Schedule any RMAN Jobs In Windows Server
- ORA-01194: file 1 needs more recovery to be consistent
- Loss of Current Online Redo-Log
- RMAN "baby Steps"
- Recovery of ControlFiles
- Loss of Datafile
- Recovery from complete loss of all online redo log files
- Block Change Tracking
- RMAN Questions
- Instance Recovery
- Redundancy and Recovery window in RMAN
- Cold Backup
- Database Cloning
- Contact
- Drop Database using RMAN
- PITR to older Incarnation
Showing posts with label Interview Questions. Show all posts
Showing posts with label Interview Questions. Show all posts
Friday 10 May 2024
Saturday 11 November 2023
Debunking 10 Myths about Database Administrators! 🔥
Database administrators (DBAs) play a critical and often underappreciated role in the world of information technology.
Friday 21 May 2021
Open Oracle Database with Delay Option
Found an interesting event, that helps to open the database with delay option. The event db_open_begin delay (opening database with delay) is undocumented event ( read unsupported )
Monday 25 June 2018
Oracle Datapump Scenarios | Interview Questions
Follow us on Facebook !!
ASM Interview Questions | PDF Download
20 + ASM Interview Questions | Real-time Scenarios
ASM Interview Questions
How to Crack DBA Interviews | Tips
How to prepare for Interview | Points
General Tips for Job Interview | Situations
Frequently Asked Questions for 2+ Years
Interview Questions for 1+ Years Candidates
General DBA Interview Questions | Quicky
30+ Oracle Dataguard Questions | PDF Download
Oracle Performance Tuning Interview Questions - Updating Soon..!!
FREE Sign-Up with Gmail and Receive Pdf's and Updates via Mail -Click Here
DBA Job Updates @ My Facebook Page
Sunday 31 December 2017
Worth Sharing: Things you should NOT do when you are angry
Things you should NOT do when you are angry 😼
*Hit your phone/gadgets on the wall.
*Punch the door/wall multiple times until your
knuckles start to bleed.
*Verbally abuse
people who love you and care for you, online or offline.
(All
these things will only add up to the pain and will hurt you even more later.)
Things you can do when you get angry 😊
*Punch
a pillow/cushion/a pile of blankets. (Find a punching bag if these are too soft
for you).
*Use
this anger to better yourself and do a ton of crunches/pushups/your fav.
exercise at home/gym.
*Go
on a long drive, preferably alone and notice the beauty of nature that
surrounds you. You can also simply walk or run.
*Grab
a pen and write the hell out of your thoughts. It's not childish. It's one of
the smartest things you can do to yourself. Don't hesitate, no one except you
is going to see that.
(Vent
your anger. Don't contain it. Anger is like poison. You need to let it You
need to let it out and make sure you don't hurt yourself in the process.)
Best
of luck. Share to others in need. 💙 😊
Happy
New Year
May this new year bring all your dreams and happiness come true.. Stay Blessed
May this new year bring all your dreams and happiness come true.. Stay Blessed
Wednesday 19 April 2017
20 ASM Realtime | Interview Questions | 3+ years
Download link : https://www.scribd.com/document/461028011/Asm-Interview-Scenarios-Oracle-dba-Help-Blog
Happy Learning ..!
Sunday 18 September 2016
How to start your carrier as a Database Administrator ?
First, Think
First…..
During your
academic finals, get Internships first, even at the small
firm will be OK. Request your employers for any kind of database related work,
or work as a SQL Developer. Don’t restrict yourself with any one kind of
database like MySQL, MSSQL, Oracle, MongoDB. Whatever you get, Just go for it.
Now impress
your bosses to convert your internships to full time job. Even if the company
wants you to be a Windows admin or Network admin first, just take the job.
Don’t ever neglect any opportunity. Now, You can slowly swivel to DBA career.
Conduct
Informational Interviews with people you know or your friends know. Join Communities on Facebook, Quora and OTN. Discover a WhatsApp group
for DBA’s and stay connected with the technology. You will meet new people.
These people could be working for companies that you may be interested in. You
may get opening/vacancies information. Find out what kind of databases they
use. Get specific. Find out the database versions and what their daily tasks
and challenges are. Try to add value to them. Just drop in every now and then
and present your findings.
It may be really small. But once people start seeing that you can add value, you will be hired. Think hard. You will definitely find some people you can talk to.
During learning, always spend more time understanding the fundamentals, Once you gets through the basics, the content or theory, later part would be a piece of cake for you now. So I suggest you to learn the basics and try to revise everything daily, example, Oracle Architecture.
Oracle
Architecture is very vast and even the core components still remain the same,
but the Oracle’s architecture has evolved on every version. When you become an
Oracle DBA, one of your main responsibilities will be monitoring production
databases.
During
Technical Interview, there is
99.99 % probability that Interview panel will ask you to Explain Oracle
Architecture. So, be well prepared for
this and explore every ‘nook and hook’ of Oracle Architecture and make a note
and write the architecture in your own words. Revise it daily.
Because once
you explain the architecture properly, there is 60 % chances you are selected,
because rest is depend on your technical answers.
Do not
explain architecture in rush. Never do this mistake. I saw many candidates,
they just finish explaining the architecture in 5-7 minutes. This is Bad.
You should
explain the Architecture for at least 25-30 minutes. So that the interviewer
get impressed.
Further part
of Interview preparation is written in my next article..
General Tips for DBA Interviews
Wednesday 7 September 2016
What is the biggest lesson you have learned in the corporate world?
Source: QUORA
- Never be the smartest person in the room.
- Always listen to your inner voice. If it "feels wrong" it is.
- Debt makes you and your company a slave to someone.
- It is never wrong to do the right thing. It is never right to do the wrong thing. The ends DO NOT justify the means. The Ten Commandments are also great safety tips no matter who said them.
- Don't hire employees or friends. Hire people who believe in the vision and want to partner because it makes them feel alive to be apart of something bigger than them or us.
- Remember who you wanted to be when you were a kid. You didn't EVER want to be the dream killer, paper pusher or suit. You wanted to change the world. Why aren't you changing the world? Age is a mind set and the older you are mentally, the less dynamic change you will capture and create.
- Love your people. If your end users are viewed
as people who are "clicks" or just customers you will
fail. If you care about them, you will make the product that
will actually make their life better or easier. You both win. Most
companies are upside down. Prioritize:
A) principals
B) people (love and respect your end users/vendors and employees/partners
-- If you have those as your solid foundation and you protect those two things, the next two fall into place naturally.
C) product. If you know the first two the product becomes obvious
D) profit. It is a byproduct. Never forget that. Making profit your goal is the easiest way to become all that you despise. - Make your word you bond. Contracts are important but your word is more so. Let your yes mean yes and no mean no always. The spirit of the deal is just as important as the words of the deal. Never dishonor yourself.
- Plan on being mocked or told it will never work. Sometimes they are right, but the best ideas do seem crazy at first to most or everyone would already be doing it.
- Know not what you do or make. But why. That is the difference between a guy who makes computers and Steve jobs. He knew why. ART.
- With God all things are possible.
- There is no such thing as compartmentalizing ethics. You can not cheat on your wife or taxes but be honest and trustworthy at the office. Fix your character flaws. We all have them. Master them or they will master you.
- Make your weakness your strength SOURCE : https://www.quora.com/What-is-the-biggest-lesson-you-have-learned-in-the-corporate-world
Monday 5 September 2016
How to Crack DBA Interviews
FREE Sign-Up with Gmail and Receive Pdf's and Updates via Mail -Click Here
People
always think that Preparing for Oracle Certification and being an Oracle
Certified can get you a Job. But the real thing is you will knowledge by
Hands-on Experience.
First thing, understand
the real issues one would encounter while ACTUALLY doing the work. For example,
upgrading from Oracle 10g to 11g. Pre-checks for Patching OR pre-requisites for
a Switchover in Data-guard, like these.
People don’t
care much how many certifications you have. They want to know that you’ve had
enough hands on.
Second thing is 80% of
the DBA interviews are performance tuning questions. So at least, be well
prepared of each and every issues a DBA can face in his entire job.
So instead
of spending many days & a lot of money on Oracle certifications, set up
your own Virtual Box and start practicing on the following topics.
You must focus on the few Oracle topics that are really important
for the job.
Important Topic for Oracle Interviews
Obviously
you should know about Oracle Architecture.
That forms the basis for everything else..
·
Dataguard
·
RMAN Backups
·
Oracle Golden Gate
·
Real Application Clusters (RAC)
·
Performance Tuning / SQL Tuning
That's all
folks, just leave a simple comment below about single, the most challenging
thing you face in learning or for becoming an Oracle DBA.
If you
really like this post and thought this is useful so please “Follow us” and be a
part of our blog and help us grow.
See Also :
How to Become a Good DBA
How to prepare for DBA Interview
General Tips for a DBA Interview - Final Preperation
Subscribe to:
Posts (Atom)