Oracle Database Backup and Recovery Session 1
Vložit
- čas přidán 30. 06. 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
2:57 Agenda
4:32 Introduction to Backup
14:48 Backup and Recovery Rules
24:12 What to Backup?
30:41 Cold Database backup
41:41 Cold Database Recovery
1:43:10 Types of Backup
1:52:27 Recovery Methodology
1:53:29 Hot Database Backup
1:59:08 Hot Database Recovery
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
Best User-Managed Backup on CZcams...Very well explained and good demonstration of recovering from different failure simulations.
thanks so much for preparing such comprehensive backup and reovery materials!, very detail orientated and clear!
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
Thank you so much!
A beautifull presentation and has well represented the concepts about restore and recovery backup
Thank you!
You Indian guys make the best teachers =)
Hey Arun You explain all the things very properly, Thank u so much .
Keep watching!
Even in 2023 still very usefull. Thank you very much for clear explanation and simple examples.
Thank you!Keep watching
The best,well explained video on backup and recover on the you tube.
great job. thanks
Glad it helped you
What a brilliant explanation sir🎉🎉
Wonderful Really appreciated Sir
Thanks
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.
your explanation is awesome. simple and clear explanation.
Glad you think so!
Good learning for beginners!! Watched it at 1.5x Speed
this suggestion is great!!! as the video is close to 3 hours long, but i watched it in 1.25, it is more understandable
Appreciate your awesome explanation.... :)
Thank you so much
great video buddy !!
Glad you enjoyed
Great explanation, thank you very much.
Keep watching!
Very well explained.
Thank you!
Grate job. Carry on.
Thank you!
Thank you so much Arun.... :)
Nicely discussed and explained
Thank you!Keep Watching!
Thank you.
can you upload the basics of sga,pga,log files,contolfiles,tablespaces and datafiles.
It's really useful Arun
Thanks a lot
Glad it helped you!
Nice video =))
Thank you!
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?
very good Thanks
Thank you!
Nice efforts bro keep it up.
Thank you!
Nice explanation ..
Thank you!
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?
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?
Great instruction! Could you please include timestamps in the description box for the different topics covered, thanks
Not soon but for sure, will do it very soon!
Good
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.
Great explanation 👌
I want these ppt
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 ?
Supb briefing
when you simulate recovery ...start the DB without restoring file so it will show error msg... it will be good understanding....
hello guys , i suggest giving an overview location of oracle control files, data files, ,fast recovery area locations on disks
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...
This video is really Helpful..Thanks a lot...
What command we will fire if Control Files are lost ?
Thank you so much
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?
+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.
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?
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?
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 👍
Sir can we perform complete recovery in cold backup? If no why DBA run database in archive mode?
Please provide the some more details about RMAN backup and recovery in different server.
oraclegenesis.com/p/oracle-advanced-rman-backup-recovery
Sir if i am not able to connect to database after db crash then how would i get alert log file location
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
Is it same in 10g or different
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
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.
Hii arun , awsm explanation can i have logical backup and recovery topic .
Hi Arun- If the Database is in Mount mode, and the backup is taken. Will it be considered as hot or cold backup ?
cold, coz db is not open
@@dbagenesis Thanks Arun, another Q: if we fire same SELECT query, will the hash value change for execution?
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!
+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.
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.
is this how it could be at work. like this is exactly how we will do these things in a working real life environment?
Yes
do u have more videos of oracle well explained sir
Try our website for video courses: oraclegenesis.com/courses
1 question -
Cold backup is called consistent backup.
And recovery from cold backup is incomplete.
Then, Why it is called Consistent backup ?
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.
Yes, because the archives needed for recovery are on the disk
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...
1:23:00 You know you can just run rm /path/path/*.dbf ?
Sir good morning
Please make video same as 12c
sir how many days for linux course ?
oraclegenesis.com/p/linux-administration-for-beginners
Hey I think I know that guy!
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 ?
If there is redo log loss and no multiplex copy, then you cannot recover it!
Hi... Are you giving online training ?
Yup, you can check our trainings here: dbagenesis.com/courses
10:55
Sir i am interested to take ORACLE DBA coaching near you online. Waiting for reply sir.
Check our video courses here: dbagenesis.com/p/courses
can u please share that ppt
For BCP
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
ORA-03113 end-of-communication channel is error ka solution bataiye
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
Please how can i take cours online
You can visit our website for video courses: oraclegenesis.com/courses
ok I SEE those training but this training for groupe or one person
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.
+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
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.
+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/
Can I get some discount am student . ?
Nice tutorial. And yet another Mr Nay’s accent…
Keep the Backup offsite
Thank you!
all the guys in the class must be sleeping haha. No one answers to his questions
explanation is good but using more time for this small topic he has taken more than 2 hours its only take 30 minutes job