HomeОбразованиеRelated VideosMore From: DBA Genesis

Oracle Database Backup and Recovery Session 1

642 ratings | 150703 views
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. MASTER AND LEARN - Backup and Recovery Overview - Cold Database Backup - Hot Database Backup - Manual Database Recovery
Html code for embedding videos on your blog
Text Comments (60)
Jesus Uzcanga (13 days ago)
1:23:00 You know you can just run rm /path/path/*.dbf ?
Ahmad Karemm (1 month ago)
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 ?
OCP Technology (2 months ago)
Nice efforts bro keep it up.
bala chandar (2 months ago)
It's really useful Arun Thanks a lot
Richardnixon Ochieng (4 months ago)
HI, hello can i get a copy of the slides sent to my email [email protected] the video is very helpful. thank you for it
menaka barathi (5 months ago)
can you upload the basics of sga, pga and tablespaces. http://www.trainingmarathahalli.com/oracle-dba-training-in-marathahalli/
Riyaz Shaikh (5 months ago)
Is it same in 10g or different
suvathi 018 (5 months ago)
https://bit.ly/2jN3g20 Thanks for sharing wonderful and clear-cut information, helped me to gain more knowledge.
MOHAMMED WAHID (6 months ago)
very good Thanks
ziad fawzi (6 months ago)
Thank you.
pratima varshney (8 months ago)
Nice explanation ..
Andrew Yunisov (9 months ago)
https://www.baculasystems.com/products/bacula-enterprise-data-backup-tools/oracle-database-backup-software - RMAN vs. DUMP in Oracle backups, might be helpful
Vinayak Budapanahalli (10 months ago)
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?
Amit Shinde (10 months ago)
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...
Raju Bandaru (1 year ago)
Appreciate your awesome explanation.... :)
The Monty Channel (1 year ago)
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?
jq747 (1 year ago)
You Indian guys make the best teachers =)
Sufal Das (1 year ago)
Grate job. Carry on.
Onkar Kalgutkar (1 year ago)
do u have more videos of oracle well explained sir
DBA Genesis (1 year ago)
Try our website for video courses: https://oraclegenesis.com/courses
Stanley Ismaillar (1 year ago)
Best User-Managed Backup on Youtube...Very well explained and good demonstration of recovering from different failure simulations.
Deepak Juneja (1 year ago)
Wonderful Really appreciated Sir
Ouldteyeb Naji (1 year ago)
Please how can i take cours online
Ouldteyeb Naji (1 year ago)
ok I SEE those training but this training for groupe or one person
DBA Genesis (1 year ago)
You can visit our website for video courses: https://oraclegenesis.com/courses
yogesh negi (1 year ago)
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.
yogesh negi (1 year ago)
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...
DBA Genesis (1 year ago)
Yes, because the archives needed for recovery are on the disk
sam nani (1 year ago)
sir how many days for linux course ?
DBA Genesis (1 year ago)
https://oraclegenesis.com/p/linux-administration-for-beginners
veera reddy (1 year ago)
Please provide the some more details about RMAN backup and recovery in different server.
DBA Genesis (1 year ago)
https://oraclegenesis.com/p/oracle-advanced-rman-backup-recovery
Mahesh Datta (2 years ago)
can u please share that ppt
10:55
NIKUNJ SAKARIA (2 years ago)
This video is really Helpful..Thanks a lot... What command we will fire if Control Files are lost ?
Smart Sriram (2 years ago)
Great explanation, thank you very much.
Gulam Khan (2 years ago)
Hi Arun: Thank you for your great contribution. I have learnt RMAN backup,all types of recovery etc. by watching your tutorials. I need your help to install oracle RAC. Could you please send me your 2 Nodes Rac installation tutorials and text instruction. My Email: [email protected]
life isgood (2 years ago)
hello guys , i suggest giving an overview location of oracle control files, data files, ,fast recovery area locations on disks
ramesh reddy (2 years ago)
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
Simmi Sahay (2 years ago)
Very well explained.
Sheikh Riaz (2 years ago)
The best,well explained video on backup and recover on the you tube. great job. thanks
Ashish Chhabra (3 years ago)
when you simulate recovery ...start the DB without restoring file so it will show error msg... it will be good understanding....
Asif A (3 years ago)
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.
DBA Genesis (3 years ago)
+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: http://oraclegenesis.com/course/oracle-11g-advanced-dba/
Asif A (3 years ago)
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.
DBA Genesis (3 years ago)
+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 [email protected]
Stroke (3 years ago)
http://oraclegenesis.com/course/oracle-11g-dba/ if i take this course. where will i get the certificate. from oracle or from you? how long will this course take...?
DBA Genesis (3 years ago)
+Stroke Any certification from online training or physical training will not help you in your professional career because Oracle has its own professional certification programs. This course will teach you Oracle DBA so that you can learn daily DBA tasks and appear for Oracle Certification exam. For more details, get in touch with us at: [email protected]
Thank You (3 years ago)
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?
Thank You (3 years ago)
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?
DBA Genesis (3 years ago)
+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.
Thank You (3 years ago)
I'm a senior pl/sql developer so you r accomplishment in such a short period of time is unheard of.E-mail is [email protected] I could only imagine you've a busy schedule, but are the follow-up sessions to this such as:RMAN, DB tuning(monitoring, diagnostic, tuning), ASM , setting-RAC, e.t.c
Thank You (3 years ago)
Likewise Arun! I look forward to those future sessions. How about the design and creating website sessions, Can they be located? 
DBA Genesis (3 years ago)
+Aman Tesfaldet Yes Aman, we do have sessions on RMAN, DB Tuning and Oracle High Availability architecture. I am in process of completing my webiste www.oraclegenesis.com where I plan to put all my video courses. Currently its under development and would be available shortly. And! yes, I do have a busy schedule but it feels good to interact with people like you!
Thank You (3 years ago)
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!
Vishwas Gowda (2 years ago)
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.
DBA Genesis (3 years ago)
+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.
SYED AYAZ Ahmed (3 years ago)
Greetings… I have being learning ORACLE SQL, PL/SQL from your videos posted on youtube.com I really appreciate your effort in imparting your knowledge to us. I request your to please send/email the Oracle SQL,PL/SQL  scripts, PPT and notes used in the videos to “ [email protected]“ I Once again appreciate your efforts in sharing the your knowledge Anticipating your response earliest
Vijay Kumar (3 years ago)
can you upload the basics of sga,pga,log files,contolfiles,tablespaces and datafiles.
vinisha mathur (3 years ago)
Hey Arun You explain all the things very properly, Thank u so much .

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.