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
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..
@@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 ..
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
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 😊
Thank you for the answers as well... really helpful
Very less interviers do this
Glad it was helpful!
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,
It's good work and helpfull for newer.
Glad to hear that
Awesome
Sir very good information for my knowledge
thanks for uploading this video.. very helpful
Thanks for sharing
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..
Hi, Useful video. What are the main prerequisite to enable RMAN backups on DB.
db should be on archive log mode ..
@@RACSINFOTECH thank you
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 ..
Quite helpful video?
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
What is difference between RMAN back and could Backup??
Will share soon
Please share the answers of all the questions asked in this video
Share the question will respond
If the host name & Dataguard server name shows the same name then how will the fix FSFO error on Dataguard server?
Question not clear
Asm_Power_limit = 1 to 11 only
And default is 1
Starts from 0-11 , default value is 1
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