HI all these are the questions asked in the video. what is instance alert log has been delete backups, what backup strategy you`re following diff bw hard backup and rman main prereq to enable rman backups purpose of fra mandatary tablespaces what is undo retention diff bw pfile and spfile main purpose of spfile and pfile purpose of checkpointer bg process if someone kills smon process what will happen asm and dataguard protection modes in dataguard diff bw physical and logical standby asm powerlimit parameter how to add datafile in any tablespace add disk to diskgroup in gui if standby database archives are not synicing with the primary gap is more than 250 archives how to sync ? cpu patches diff bw multitenant and non multitenant installation versions that you`ve made All the best for all the learners and job seekers Thank you.!
take scn from standby and start take incremental bkp from primary and ship incremental backup from primary to standby and then do start mrp on standby.
Prerequisites: We need to check the MRP process status. If the mrp process starts status &may network issue also main region not applied to standby DB. We need to check SD archives if they are not available then we need to take incremental backup using SCN based on standby database
@@bituchaudharyabhi9002 .. any log switch happens new alert log will create like this : alter system switch logfile; ,else after stop and start the database alert log will create automatically else you can create new alert log manually ...
for examle if log switch happen after 200mb of data filled in redo logs,these changes are not wrriten in alertlog? i think it is not correct ans: alertlog created automatically when a change is happend in database ..
The interview is based on asking the questions for a guy who just completed DBA course. anyone can answer those basic questions. Do you have any other videos who asks real time scenarios in depth.
I have uploaded the few interview question and answers you can go though those videos.. if you’re looking for more realistic or real time interview Q&A send a mail to Racsinfotech@gmail.com we will conduct mock interview for you..
without pfile or spfile we can not mount our database..why is he thinking so much..interviewer is asking basics only..its bit easy as i am having 2.3 years of experience
In the interview sometime we may not recall simple things also it’s human nature.. no worries .. the guy who’s given this mock interview he got the job in mnc with very good package 😀 .. generally interviews are simple only, once got the work that’s tough 😁
We required control file to move database into mount state.. it's not spfile or pfile. Spfile and pfile are required when database starting from shutdown to no mount state
We required control file to move database into mount state.. it's not spfile or pfile. Spfile and pfile are required when database starting from shutdown to no mount state
We required control file to move database into mount state.. it's not spfile or pfile. Spfile and pfile are required when database starting from shutdown to no mount state
It’s depends on current salary,.. we can expect 30% *hike on current CTC.. Generally I will calculate the salary in this format.. with 4 years experience salary should be 4*2+2= 10 lakhs * minimum.. it’s my point of view.. it’s individual choice/ options how much they want few of them will get less pay few of them will get more than which i mentioned.. so take your call***
HI all
these are the questions asked in the video.
what is instance
alert log has been delete
backups, what backup strategy you`re following
diff bw hard backup and rman
main prereq to enable rman backups
purpose of fra
mandatary tablespaces
what is undo retention
diff bw pfile and spfile
main purpose of spfile and pfile
purpose of checkpointer bg process
if someone kills smon process what will happen
asm and dataguard
protection modes in dataguard
diff bw physical and logical standby
asm powerlimit parameter
how to add datafile in any tablespace
add disk to diskgroup in gui
if standby database archives are not synicing with the primary gap is more than 250 archives
how to sync ?
cpu patches
diff bw multitenant and non multitenant
installation versions that you`ve made
All the best for all the learners and job seekers
Thank you.!
take scn from standby and start take incremental bkp from primary and ship incremental backup from primary to standby and then do start mrp on standby.
Prerequisites:
We need to check the MRP process status.
If the mrp process starts status &may network issue also main region not applied to standby DB. We need to check SD archives if they are not available then we need to take incremental backup using SCN based on standby database
Also we can use Service Command 😊
Sir very good information for my knowledge
Thank you for the answers as well... really helpful
Very less interviers do this
Glad it was helpful!
Thanks for sharing
thanks for uploading this video.. very helpful
It's good work and helpfull for newer.
Glad to hear that
When the alert log file is dropped intentionally or unintentionally, Oracle will automatically creates a new alert log file.
Yes , when it will create?
@@RACSINFOTECHWhen any log entry occur it will be created automatically.
I need more justification on above question, @RACINFOTEC could you please help me on this...
@@bituchaudharyabhi9002 .. any log switch happens new alert log will create like this : alter system switch logfile; ,else after stop and start the database alert log will create automatically else you can create new alert log manually ...
for examle if log switch happen after 200mb of data filled in redo logs,these changes are not wrriten in alertlog? i think it is not correct
ans: alertlog created automatically when a change is happend in database ..
That was a great interview process ❤. This makes it much better for me as a DBA person actually I want to be part of the interview,
Awesome
there is another way if your standby database is out of sync you can restore form production service name.
We can do multiple ways..
The interview is based on asking the questions for a guy who just completed DBA course. anyone can answer those basic questions. Do you have any other videos who asks real time scenarios in depth.
I have uploaded the few interview question and answers you can go though those videos.. if you’re looking for more realistic or real time interview Q&A send a mail to Racsinfotech@gmail.com we will conduct mock interview for you..
UIseful for juniors,thank you
Yes, thanks
If the host name & Dataguard server name shows the same name then how will the fix FSFO error on Dataguard server?
Question not clear
Hi, Useful video. What are the main prerequisite to enable RMAN backups on DB.
db should be on archive log mode ..
@@RACSINFOTECH thank you
without pfile or spfile we can not mount our database..why is he thinking so much..interviewer is asking basics only..its bit easy as i am having 2.3 years of experience
In the interview sometime we may not recall simple things also it’s human nature.. no worries .. the guy who’s given this mock interview he got the job in mnc with very good package 😀 .. generally interviews are simple only, once got the work that’s tough 😁
We required control file to move database into mount state.. it's not spfile or pfile.
Spfile and pfile are required when database starting from shutdown to no mount state
We required control file to move database into mount state.. it's not spfile or pfile.
Spfile and pfile are required when database starting from shutdown to no mount state
We required control file to move database into mount state.. it's not spfile or pfile.
Spfile and pfile are required when database starting from shutdown to no mount state
Please share the answers of all the questions asked in this video
Share the question will respond
What is difference between RMAN back and could Backup??
Will share soon
❤
Quite helpful video?
Asm_Power_limit = 1 to 11 only
And default is 1
Starts from 0-11 , default value is 1
in general what is the salary range ??
for 3 -4 years
and for 5 - 6 years
can any one reply
It’s depends on current salary,.. we can expect 30% *hike on current CTC..
Generally I will calculate the salary in this format.. with 4 years experience salary should be 4*2+2= 10 lakhs * minimum.. it’s my point of view.. it’s individual choice/ options how much they want few of them will get less pay few of them will get more than which i mentioned.. so take your call***
@RACSINFOTECH thanks for your reply.
What exactly is FRA.?
Will make separate videos on this fra so that you Will understand..
he got the job? ahah
Yes he’s in one of the mnc , few weeks back