hi ramkumar i am working as a ORACLE DBA i need to do practice more so will you provide lab servers at lease two two node RAC set up? If you dont mind i ll pay rent also.
Hi Kumar, This is Ashok can you please do a video for me on " i taken backup of Source DB on 01.09.2023 and i copied it to Target Database server as nfs - type in mountoint u01. now i lost my controlfiles in that backup which is in Target server. "How to recover lost Controlfiles from backup in Target server. and Restore with that control files on 27.09.2023.
Hi it's good one,, One doubt... During the user error and the time of flashback , there will be at the same time other transactions occur in the same table by other users... So when we flashback table as per one user's request , all transactions made by others are also flashed back!! Hence, how will other user tolerate the flashback ? Is there any method to flashback only a particular statement and not the whole thing? LogMiner is the solution ? please tell. thanks
+Shameem. M. Thats exactly what happens... In case if you know other transactions and their time frames as well, then there is a possibility of rolling back only the transactions which are faulty.
Ya.. But , suppose thousands of transactions can occur in between while we flashback someon'e fault... Hence what about all people's real transactions.. ? Could you answer this doubt?
Hi, Nice point you made. Flashback itself has got an option to do this with "FLashback transaction query" and also "Flashback version query" which can help you get this done.
Logically, it would have 8 rows, since that is what the Flashback function was asked to do. You'll have to get the new (12) records back another way, but not using the IMP/replace function.
Very nice demo, useful, thank you very much.... I have a small query. can you help me on this ? in the last, you shown the log of the whole session, how ? can you please tell me how to take the log of a particular session ?. Many thanks in advance for your prompt response :)
helo sir kindly can you provide me the complete database administration tutorial using oracle tool .i have done the introduction to sql tutorial but i require the complete tutorial.
hlw sir your explanation is really good...i'hv one query that can you explain about ora-12154 through youtube vedio.....if do ...i'll be pleased....thx.!!!
Hello sir, I'm a non technology background student, working in an MNC company, can non technology people also learn Oracle DBA and get job in that field, are there any such instances, please respond, Thanks in advance.
Make a video step by step without any errors , you are showing it easy by complicating the beginnings who is watching by making mistakes and not showing from straight point to point .. I expect you to give a straight clean demo ..
After 9 years i got this video.
Explanation was great 👍
are ya a dba?
i surprised withway of your teaching 1-time i am good at this issue bro....tqq
at 12:05 how did you have copy of putty on notepad? Thanks
sir super explanation ,very need full for beginners.
thanks a lot
Nice Real time scenario,,, useful for future purpose :)
Please you should have to make a playlist of oracle??
Fantastic sir it's working. I checked it
Why after the commit show parameter undo statement gives the error of table or view does not exist?
Thank you for sharing such a valuable information with us
awesome thank u. what if I want to restore a data committed by specific user. in your scenario it will restore the whole scott.dept table
hi incase undo_retention time 900s
i lost the table before 1hr its possible this method?
Hello sir Direct comes to back flash query why use so many lines sir
hi ramkumar
i am working as a ORACLE DBA
i need to do practice more so will you provide lab servers at lease two
two node RAC set up?
If you dont mind i ll pay rent also.
Can i get back of data before 30 days using flahback?
Hi Kumar,
This is Ashok can you please do a video for me on " i taken backup of Source DB on 01.09.2023 and i copied it to Target Database server as nfs - type in mountoint u01. now i lost my controlfiles in that backup which is in Target server. "How to recover lost Controlfiles from backup in Target server. and Restore with that control files on 27.09.2023.
So do we need flashback enable in database to do this flashback activity?
Really awesome demo
Good Tutorial and Teaching method is very good and clear.
Thank you! Very helpful!
It's really helpful, Thank you so much...!
Hi hello in oracle DBA mainly on what concepts should I focus more for fast growth in this domain can you please tell me
good one looking for more.. if time exceeds like one or two hours then same procedure will work.
Very easy to understand for beginners!!
u skipped to create directory ....... i was in great trouble :(
nice one thank you for the demo.. much useful
When say exit it directly close sql plus
Hi it's good one,, One doubt...
During the user error and the time of flashback , there will be at the same time other transactions occur in the same table by other users...
So when we flashback table as per one user's request , all transactions made by others are also flashed back!!
Hence, how will other user tolerate the flashback ?
Is there any method to flashback only a particular statement and not the whole thing?
LogMiner is the solution ? please tell. thanks
+Shameem. M. Thats exactly what happens... In case if you know other transactions and their time frames as well, then there is a possibility of rolling back only the transactions which are faulty.
Ya.. But , suppose thousands of transactions can occur in between while we flashback someon'e fault...
Hence what about all people's real transactions.. ?
Could you answer this doubt?
hi...
Hi, Nice point you made. Flashback itself has got an option to do this with "FLashback transaction query" and also "Flashback version query" which can help you get this done.
OrSkl Academy
Why we use scott.dept. What Scott represents in this query?
Scott is the schema and dept is the table under scott user
what is the other method if flashback is not enabled ? how would i get my table back?
Using rman you can recover the table from 12c this feature is introduced
Can you please make a video on making a database using command prompt in windows as well, using sqlplus.
when the data is overwrote what is the process to undo the error
Any classes will be taken ??
Not at the moment.
Awesome demo man!
ORA-39002,39070,39087 these error's are occurring sir after providing the password before going to next step please help me......!!!!!
Thank you! Very helpful!Sir
bring back table or record? if its table in prod they will fire employee
what if before 15 mins mu table has 8 rows n now i have 20 rows what if i flash back now ... will my table be remain same or will be 8 rows again??
Logically, it would have 8 rows, since that is what the Flashback function was asked to do. You'll have to get the new (12) records back another way, but not using the IMP/replace function.
Its awesome demonstration.
Should I be master in oracle ?? Or freshers can handle this ??
This is very informative.. can you please let me know the fee and points or syllabus of online dba course.
Please whatsapp on +919951696808 for career guidance
thank you sir
Great work.
Need Real time scenarios. How to contact you?
Very nice demo, useful, thank you very much....
I have a small query. can you help me on this ? in the last, you shown the log of the whole session, how ? can you please tell me how to take the log of a particular session ?.
Many thanks in advance for your prompt response :)
How to check Database Health?
Lecture is soft toooo
very good lecture.
Useful demo
Sir is there any Oracle University in Kolkata or Bangalore ? where we can learn Oracle DBA . If yes then please give details of it
The link you provided does not work on facebook..
+Mohan Ramaswamy Hi, it works ... facebook.com/orsklacademy or our website www.orskl.com
I want to be a DBA how can I contact you for more information.
Thank you.
How to Contact you, what are fees, time and duration etc? I am willing to join asap. May be this week.
Hi all,
If i deleted the temporary tablespace, then can i open the Database ¿¿ or while opening its will show missing temporary file
If you drop the temporary tablespace nothing will happen on next startup the temporary tablespace will be created automatically by using controlfile
Hi , i want to join your class
any online training ?
helo sir kindly can you provide me the complete database administration tutorial using oracle tool .i have done the introduction to sql tutorial but i require the complete tutorial.
nice sir..
thank u for giving the rough idea
i want some more realtime activities
i would like to join your class ...offline or online whatever mode...please share your contact details thanks...
hlw sir your explanation is really good...i'hv one query that can you explain about ora-12154 through youtube vedio.....if do ...i'll be pleased....thx.!!!
Hai sir i need oracle apps dba tutorial .
nice video
Hello sir, I'm a non technology background student, working in an MNC company, can non technology people also learn Oracle DBA and get job in that field, are there any such instances,
please respond,
Thanks in advance.
Thank you so much
Nice lecture
how can i learn directly these real time activities in oracle dba
+vamsee0246 You can check our website www.orskl.com for the course on real time activities.
A good demo :)
Thank u sir
Sir how to save script file in oracle:plz help me i really need this
you can use spool c:filename.txt after finishing your work than you will say spool off
Kindly share the text file
nice experience
More videos bro
This is good for us
how i can contact you ?
facebook.com/orsklacademy
Make a video step by step without any errors , you are showing it easy by complicating the beginnings who is watching by making mistakes and not showing from straight point to point .. I expect you to give a straight clean demo ..
Iske bad kya karu
Sir may BSC IT Kar Raha hu
cool , great demo
hello sir sir sir sir sir sir sir
Hey guys, I just created a custom test for the administration 062 exam by myself here www.udemy.com/course/1658424
To learn Oracle DBA Enroll now www.trainingmarathahalli.com/oracle-dba-training-in-marathahalli/
please provide ur contact .....
Thank you so much
nice video
nice video