Oracle Database Backup and Recovery Session 2
Vložit
- čas přidán 2. 07. 2024
- #Backup and recovery is to protect the #database against data loss and reconstruct the database after data loss. Backup has been splitted into two methods:
-- Physical backup - Physical backup is a backup of the physical files used in storing and recovering your database. Such as datafiles, control files, archived redo log files.
-- Logical backup - Logical backup is exporting the logical data(table, tablespace, schemas) from a database with an #Oracle export utility and stored in a binary file.
0:00 Intro to RMAN
01:00 What do you understand by RMAN?
33:10 Understanding Backup Methodology
01:01:01 Connecting to RMAN utility
01:03:20 Components of RMAN
01:07:05 RMAN Configuration Parameters
01:40:53 RMAN DB Full Backup on Disk
01:47:42 Database Level 0 incremental Backup on Disk
01:59:18 Recovering DB from Incremental Backup
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
Arun I really appreciate the way you teaches and it is very much helpful to those people who have some financial problem but they want to learn DBA. I m personally thankful to you, liked your videos very much. Please do share your knowledge in CZcams as much you can. Specially interview questions and real-time scenarios.👌💞👌
You are very good at what you do. This helps greatly, especially the explanation of the basic theory at the beginning. Your explanation stuck with me. Thanks!
Thank you so much!
Thank you so much. Your way of explaining is amazing . Loved it.
AMAZING THANKS FOR PUTTING IT CLEAR
Arun, you are the best teacher my friend. Well organized and clear. Thanks for what you are doing!
Thank you!
Very through video 🔥 👌🏿 👍🏿
Thank You!
Very good presentation. You explanation is awesome. Thumbs up !!!
Thank you!
Thank you so much for this. I really wish I had come across this a long time ago. Anyways it's all good... polishing up
Glad it was helpful!
Hi Sir,
Thank you so much, you cleared the concepts very easily that removed my fear.. :)
Thank you!
god bless you brother...you are awesome !!!!
Thanks
thanku sir for such a brief description along with examples..
You are welcome!
Hi Arun, Awesome explanation, Your explanation is very clear.
Thank you so much
Nicely explained RMAN concepts
Thanks
very nice... finally my concept got cleared now I m so happy but I would be happy more when u will teach more about any new topic like rac etc.......thanks for this video......
Thank you!
Arun your explaination was really nice. Anybody can understand, Thanks for your video.
Thank you!
U are genius sir
Thanks
really good teaching.Thank you.Really easy.You are a really good teacher:)
Thank you! 😃
Thanks Arun for sharing your great knowledge. It's really boost our confidence.
It's my pleasure
Tip:
I figured this out by fiddling around. the List Backup cmmnd might seem a little overwhelming and confusing. So what you need to do is Compare the filename from the piece name to the filenames of the bkp files that were created in your fast recovery area(if you have that enabled) or your specified directory.
Here you need to note 3 things: the date modified of the bkp file, the Tag as the teacher mentioned and the BS key.
Hi Arun. thanks for the brilliant and clear explaination. It was really helpful. If you can post a video on architecture of database 11g.
hi sir thanks for this one of the best session I have ever seen on video........
Thanks
thank you :)
Welcome!
Thanks alot for the 2 sessions of clear and precise teaching. I am glad i came across you channel. Is there any other sessions you will be teaching anytime soon?
Thank you Keep watching!
it was nice session it help me to learn lot of new thing .I request to you kindly publish some more video on RMAN real time scenario.....................
Keep Watching, Noted
Good pls upload more video in oracle
nice explanation sir
Thank you!
Hello Arun,
Both sessions given by you were very clear and you really made the base on this topic.
It is useful and healthy to read, Can you please mail me the PPT or Notepad you used for this ? Further would like to tell you am interested in understanding the advanced version of this topic.
Let me know your views. Thanks!!
+Himanshu Dear Candidate, As of now we do not share the PPTs used for free webinars. For all other training, you can directly get in touch with us via hello@oraclegenesis.com
May i ask about the course named "Oracle 11g DBA For Beginners" . In this course ? you teach in Linux OS or windows ?
hi,
nice video, i have a doubt.
i have taken fullbackup using rman and i configure that my backup location is u01. after sometime my backup moved to TAPE. as per request storage team placed backup in u02 instead of u01.
now here is the question 'how do you tell this to your rman' without changing in configuration backup location u01.' what is the cmd u use to slove this?
plz answer it.
Thanks&Regards
madhan
i have a confusion in obsolete and expired backup can u plz explain it clear
Hello sir, I just watch your rman backup and recovery video, so helpful, Thanks for the helful information and clearing my concepts of RMAN I have lots of questions, How can I reach you?
You can drop an email to support@dbagenesis.com
Is it possible to recover only one table form the backup file?
what is physical and logical corruption ? how do we or rman identify it?
do we still read books for rman ,performance , asm etc after u r lectures.????
Good question :) You must read books
Is parallelism and channel connect with each other if we set parallelism to 1 and set channel to 4 then what happened? Please tell...
RMAN will trigger 4 channels. If you don't give channels then RMAN will allocate automatic channels based on parallelism parameter!
God bless you sir for this video
Very interesting
But sir I follow the instructions when I backup database plus archivelog only the archivelog backup was successful.
And the datafile backup failed
I need help
Thanks
Please post the RMAN error you encountered
Thank you very much sir.
Sir my curiosity to understand RMAN and data pump destroyed my Oracle Database now it says Lrm could not open parameter file. Please I need assistance I don’t know where I can locate ur school. I based in Taxes
any realtime oriented training in hyd by u?
I have video courses on my website. You can directly enroll into the video courses and start learning.
oraclegenesis.com/courses
How will RMAN repair block corruption?
Check out #dailyDBA episodes, it has been discussed in one of the episodes!
This video should have been edited.
Redundancy explanation is wrong. too lengthy video. otherwise good video.
Hi Sir,
Thank you so much, you cleared the concepts very easily that removed my fear.. :)
Glad it helped you!