Doctor, I'm from BRAZIL, and honestly your explanation and way of handling the topic are exceptional! THANK YOU SO MUCH FOR SHARING YOUR KNOWLEDGE!!!
@honeyjain4694
2 жыл бұрын
Sir, aapne jaane anjaane mein un logoo ki help kari hai jo afford ni karskate ...... no words to say thanks to you.....Bhagvaan aapko lambi umar de
@dbagenesis
2 жыл бұрын
Thank you so much!
@vasilijzajcev7579
Жыл бұрын
Even in 2023 still very usefull. Thank you very much for clear explanation and simple examples.
@dbagenesis
Жыл бұрын
Thank you!Keep watching
@stanleyismaillar8112
7 жыл бұрын
Best User-Managed Backup on KZitem...Very well explained and good demonstration of recovering from different failure simulations.
@jq747
6 жыл бұрын
You Indian guys make the best teachers =)
@AbhishekMishra-gr5zk
7 ай бұрын
What a brilliant explanation sir🎉🎉
@paikmanoj
4 жыл бұрын
Good learning for beginners!! Watched it at 1.5x Speed
@shivanshu2202
2 жыл бұрын
this suggestion is great!!! as the video is close to 3 hours long, but i watched it in 1.25, it is more understandable
@robertmugerwa6492
3 жыл бұрын
A beautifull presentation and has well represented the concepts about restore and recovery backup
@dbagenesis
3 жыл бұрын
Thank you!
@deezeela
8 ай бұрын
thanks so much for preparing such comprehensive backup and reovery materials!, very detail orientated and clear!
@vinishamathur7639
9 жыл бұрын
Hey Arun You explain all the things very properly, Thank u so much .
@dbagenesis
3 жыл бұрын
Keep watching!
@abdulgani-iq9bg
3 жыл бұрын
your explanation is awesome. simple and clear explanation.
@dbagenesis
3 жыл бұрын
Glad you think so!
@tapankumarhome6711
2 жыл бұрын
Nicely discussed and explained
@dbagenesis
2 жыл бұрын
Thank you!Keep Watching!
@sraz9952
8 жыл бұрын
The best,well explained video on backup and recover on the you tube. great job. thanks
@dbagenesis
3 жыл бұрын
Glad it helped you
@shivanshu2202
2 жыл бұрын
great video buddy !!
@dbagenesis
2 жыл бұрын
Glad you enjoyed
@Kidzeeplanet
5 жыл бұрын
Thanks, Arun for this beautifully and easily understand video for backup and recovery hope you will come with other topic related to Oracle database and guide all of us in the same way as you did it in this video, Thanks once again it helps me a lot for clearing my doubts.
@deepakjuneja7836
7 жыл бұрын
Wonderful Really appreciated Sir
@dbagenesis
3 жыл бұрын
Thanks
@VijayKumar-ie1ed
9 жыл бұрын
can you upload the basics of sga,pga,log files,contolfiles,tablespaces and datafiles.
@saveUyghurs
3 жыл бұрын
Great instruction! Could you please include timestamps in the description box for the different topics covered, thanks
@dbagenesis
3 жыл бұрын
Not soon but for sure, will do it very soon!
@smartsriram6234
7 жыл бұрын
Great explanation, thank you very much.
@dbagenesis
3 жыл бұрын
Keep watching!
@ocptechnology
5 жыл бұрын
Nice efforts bro keep it up.
@dbagenesis
3 жыл бұрын
Thank you!
@themontychannel4981
6 жыл бұрын
In hot backup with the first scenario of data file loss, - You did first begin backup - Copy data and control file - Copy archive - Then end backup - Then switch achive and copied single file. In Hot backup with second scenario of data and control file loss, - You have begin backup - copied data and control files - NO Archive copied - End backup mode - Then switch achive. - Copied all archive logs. i got confused. Secondly, question? if i take backup of data control file once and then every time only archive logs, Will it be ok?
@user-vu1tn1jc3b
9 жыл бұрын
what are the hourly, daily, weekly routine tasks/activities pertaining DB from your practical experience? what questions would you pose a potential DBA in the hiring process?
@dbagenesis
9 жыл бұрын
+Aman Tesfaldet There are two prospective for a DBA job. One is support project and one is development. If you are going for an established project, it is most likely that you will join a support project. HOURLY TASKS: There is nothing called as hourly tasks. Mostly you react to alerts (if any) in a database. DAILY TASKS: - DB Health checks - DB Monitoring - Performance tuning - Daily backups (can be incremental backups) - Any scheduled jobs form application team - User management (lock, unlock users) - Tablespace management (add space) - DR Sync issues (if any) or at least make sure DR is in full sync with prod - DB Lock resolution or deadlock reporting to application team WEEKLY TASKS: - DB Cloning - DB Refreshes - Applying patches (if needed) - DB Upgrades (if needed) - Index rebuilding - DB Bounce (for any parameter changes or other activities which needs DB bounce) - Mock DR Trial (performing manual switch over to test your DR can act as PROD in case of disaster) The list goes on and depends from project to project.
@user-vu1tn1jc3b
9 жыл бұрын
Thanks for the info. This is valuable information, so that one understands what to expect. But when you refer to "DR", is that disaster recovery DB that should always be in parallel with Prod? Am I correct?
@rajivshivaraman6476
4 жыл бұрын
Thank you so much Arun.... :)
@balachandar7101
5 жыл бұрын
It's really useful Arun Thanks a lot
@dbagenesis
3 жыл бұрын
Glad it helped you!
@syedarshad6055
4 жыл бұрын
Good
@simmisahay2518
8 жыл бұрын
Very well explained.
@dbagenesis
3 жыл бұрын
Thank you!
@nabrcnatureaquaculturebiof4172
3 жыл бұрын
Supb briefing
@wahidansari4897
4 жыл бұрын
Great explanation 👌 I want these ppt
@abdulqudoos7501
8 ай бұрын
Sir can we perform complete recovery in cold backup? If no why DBA run database in archive mode?
@gotchihaeyo1825
Жыл бұрын
Hi, are you still here? 😁 All files were removed, but @1:32:23, how are you able to query and see the locations of spfile and control files?? Aren't those supposed to be gone too? Thanks 👍
@SantoshSingh-qb9qz
Жыл бұрын
1 question - Cold backup is called consistent backup. And recovery from cold backup is incomplete. Then, Why it is called Consistent backup ?
@MrSanyabandaru
6 жыл бұрын
Appreciate your awesome explanation.... :)
@dbagenesis
3 жыл бұрын
Thank you so much
@ashish210881
8 жыл бұрын
when you simulate recovery ...start the DB without restoring file so it will show error msg... it will be good understanding....
@pratimavarshney239
6 жыл бұрын
Nice explanation ..
@dbagenesis
3 жыл бұрын
Thank you!
@vinayakbudapanahalli192
6 жыл бұрын
I have a query Scenario - your DB is running on archive log enabled status. - You have taken the back up of all files(data, spfile, control, and archive) on Mar-1 at 00:00 am to the backup location. then on March 4-5, you DB gets crashed along with recent archive logs(which are generated after Mar-1st). Can we still be able to recover the data using the archive log files which are generated after March-1 00:00 am? I mean to the most recent state of the DB along with the transaction happened on Mar-2-3-4-5 till the DB got crashed?
@veransobrian8697
3 жыл бұрын
is this how it could be at work. like this is exactly how we will do these things in a working real life environment?
@dbagenesis
3 жыл бұрын
Yes
@krashandoify
8 жыл бұрын
hello guys , i suggest giving an overview location of oracle control files, data files, ,fast recovery area locations on disks
@blessiousphiri3109
5 жыл бұрын
Hello am a DBA I would like to ask if you guys offer Oracle DBA Certifications and at what price and what is the duration?
@mohammedwahid2316
6 жыл бұрын
very good Thanks
@dbagenesis
3 жыл бұрын
Thank you!
@syedarshad6055
4 жыл бұрын
Sir at 1:49:00 if the database crash we lost all the files then how come archive log file will retain why archive log files are not loss during database crash
@dbagenesis
4 жыл бұрын
This is just simulation of a scenario on local system. In real time, you will never loose a single file (data file, Control file, archives, redo) even when there is server crash.
@amitshinde9724
6 жыл бұрын
sir,you created user but you are not connected to that user while in creating tables ,you use sys user... otherwise this video is very helpful for us thank you so much and add mode video with different scenario and concept...
@ziadfawzi
6 жыл бұрын
Thank you.
@rajeevverma6234
3 жыл бұрын
Awesome tutorial sir, learned lots of things. I've recovered the db but there is no user and table which was created after taking the hot backup.. is there anything missing?
@nabrcnatureaquaculturebiof4172
5 жыл бұрын
Sir good morning Please make video same as 12c
@sufaldas8045
7 жыл бұрын
Grate job. Carry on.
@dbagenesis
3 жыл бұрын
Thank you!
@yogeshnegi7014
7 жыл бұрын
we have take both datafile as well as archivelog backup and in first scenario when datafile are deleted so we only restore datafile why not archivelog file??? without recovering archive log you perform recover database.
@dbagenesis
7 жыл бұрын
Yes, because the archives needed for recovery are on the disk
@yogeshnegi7014
7 жыл бұрын
ORACLEGENESIS Thank you so.. much for replying... and if we want to make a copy of archivelog file on a different place or on remote so how we will do it... it's very confusing...
@onkarkalgutkar7948
7 жыл бұрын
do u have more videos of oracle well explained sir
@dbagenesis
7 жыл бұрын
Try our website for video courses: oraclegenesis.com/courses
@abhishekgaikar4966
3 жыл бұрын
Sir if i am not able to connect to database after db crash then how would i get alert log file location
@ahmadkaremm3921
5 жыл бұрын
hi dear please i want to ask u the rman take the backup of database autmaticly daily or we must create batch file from rman commands and put it in the crontab to make this back every day or every week etc ?
@dungnguyenmanh1540
5 жыл бұрын
Nice video =))
@dbagenesis
3 жыл бұрын
Thank you!
@shayansarkar7570
2 жыл бұрын
Hi Arun- If the Database is in Mount mode, and the backup is taken. Will it be considered as hot or cold backup ?
@dbagenesis
2 жыл бұрын
cold, coz db is not open
@shayansarkar7570
2 жыл бұрын
@@dbagenesis Thanks Arun, another Q: if we fire same SELECT query, will the hash value change for execution?
@nikunjsakaria5834
7 жыл бұрын
This video is really Helpful..Thanks a lot... What command we will fire if Control Files are lost ?
@dbagenesis
3 жыл бұрын
Thank you so much
@veerareddy6723
7 жыл бұрын
Please provide the some more details about RMAN backup and recovery in different server.
Hii arun , awsm explanation can i have logical backup and recovery topic .
@blessiousphiri3109
5 жыл бұрын
For BCP
@uzcanga
5 жыл бұрын
1:23:00 You know you can just run rm /path/path/*.dbf ?
@sribalaje
4 жыл бұрын
Hi , Articulated beautifully.One Query.. If control file is lost i.e, I have only two days before backup control file..In tat case, when we recover the database, will we b able to recover only two days before data since control file backup v have right now is 2 days before one. Please clarify.
@tpitts
3 жыл бұрын
Hey I think I know that guy!
@nikhiljadhav2700
5 жыл бұрын
ORA-03113 end-of-communication channel is error ka solution bataiye
@ramanandmyra2138
4 жыл бұрын
Manily network issue.also sometimes if u kill session of db-link thn also this issue occurs. Still there are 3 other reasons .refer to burleson docs u will find it
@riyazshaikh2591
6 жыл бұрын
Is it same in 10g or different
@user-vu1tn1jc3b
9 жыл бұрын
Hi Arun! Your teaching technic is excellent and very motivating. You're very detailed, in the way you put yourself in the students shoes first, which other teachers lack. I'll be interested to attend your website design classes. Is there one we can attend, pls let me know. Many Tnx!
@dbagenesis
9 жыл бұрын
+Aman Tesfaldet Thanks Aman, yes I can take up sessions on website design. If you could provide me with your email address, I will contact you personally.
@vishwasgowda8589
8 жыл бұрын
Your knowledge as a DBA is awesome, I bet even a layman can understand what you are teaching as you are giving excellent real time scenarios.
@rossxie9809
4 жыл бұрын
In the demo of recovery from hot backup, the new user was created after the archive logs were backup. When you did a recovery, was the new user recovered from online redo log ? How do we recover from a loss of online redo log ?
@dbagenesis
3 жыл бұрын
If there is redo log loss and no multiplex copy, then you cannot recover it!
@thehappybee4564
4 жыл бұрын
Hi... Are you giving online training ?
@dbagenesis
4 жыл бұрын
Yup, you can check our trainings here: dbagenesis.com/courses
@parameshreddy95
3 жыл бұрын
Sir i am interested to take ORACLE DBA coaching near you online. Waiting for reply sir.
@dbagenesis
3 жыл бұрын
Check our video courses here: dbagenesis.com/p/courses
@rameshreddy1844
8 жыл бұрын
hi iam try learn in oracle database backup and recovery iam done in session 1 & 2 but not there in session 3.please send or upload in the oracle database backup and recovry session 3. please .and advance thanku
thanks for the video. i followed all the steps on cold backup and recovery in this video. everything was successful but when I altered database open i got an error SQL> startup mount ORACLE instance started. Total System Global Area 354914304 bytes Fixed Size 2213336 bytes Variable Size 226495016 bytes Database Buffers 121634816 bytes Redo Buffers 4571136 bytes Database mounted. SQL> alter database open; alter database open * ERROR at line 1: ORA-01172: recovery of thread 1 stuck at block 57976 of file 2 ORA-01151: use media recovery to recover block, restore backup if needed finally i have to recover a datafile with the below statement SQL> recover datafile 2; Media recovery complete. SQL> alter database open; Database altered. SQL> select status from v$instance; STATUS ------------ OPEN you made a comment that we do not need to recover when we use cold backup. please can you explain what happened?? thanks
@blessiousphiri3109
5 жыл бұрын
Keep the Backup offsite
@dbagenesis
3 жыл бұрын
Thank you!
@maheshdatta1276
7 жыл бұрын
can u please share that ppt
@najiteyeb6838
7 жыл бұрын
Please how can i take cours online
@dbagenesis
7 жыл бұрын
You can visit our website for video courses: oraclegenesis.com/courses
@najiteyeb6838
7 жыл бұрын
ok I SEE those training but this training for groupe or one person
@javidbhat1086
5 жыл бұрын
Can I get some discount am student . ?
@7002asif
8 жыл бұрын
hi, can i work as a Professional oracle DBA from this course ? r u covering everything in this training & in ur (oraclegenesis.com) website? please let me know. it would be very helpful if i we can get real life professional experience from here.
@dbagenesis
8 жыл бұрын
+asif mahmood Dear Candidate, The professional DBA takes a long dedication and real time experience. With the video courses that we have, you can crack DBA interviews and handle different daily tasks. For a professional experience, you could contact us for an customized internship program. Write to us at hello@oraclegenesis.com
@7002asif
8 жыл бұрын
Ok, so if i understood u correctly, this course is all about everyday task & job interviews. But in order to be a DBA, i need a full course where i can learn complete Oracle DBA. i already have pre oracle dba & pl/sql experience. so i just need a good teacher to guide me how to complete the full course.
@dbagenesis
8 жыл бұрын
+asif mahmood As you already have Oracle DBA & PL / SQL experience, It will be very easy for you to learn Oracle DBA. You need to learn the administration part. Most importantly! you need to focus on Oracle advanced topics Like Backup and recovery, High availability and performance tuning. As per the description above, you can check our Advanced DBA course content which would suit your need: oraclegenesis.com/course/oracle-11g-advanced-dba/
@shivanshu2202
19 күн бұрын
Video starts @9:25
@davidchang5862
2 жыл бұрын
Nice tutorial. And yet another Mr Nay’s accent…
@satishhhhable
4 жыл бұрын
all the guys in the class must be sleeping haha. No one answers to his questions
@rafikahmmed1083
4 жыл бұрын
explanation is good but using more time for this small topic he has taken more than 2 hours its only take 30 minutes job
Пікірлер: 136