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 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.
Excellent explanation from end-to-end. But for the hot backup/restore which does require shutdown, the DB was actually shutdown. Please can you explain on this. 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?
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.
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.
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?
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?
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.
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...
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 ?
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
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...
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
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 ?
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/
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.
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??
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!
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!!!
Best User-Managed Backup on UA-cam...Very well explained and good demonstration of recovering from different failure simulations.
Even in 2023 still very usefull. Thank you very much for clear explanation and simple examples.
Thank you!Keep watching
You Indian guys make the best teachers =)
What a brilliant explanation sir🎉🎉
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
thanks so much for preparing such comprehensive backup and reovery materials!, very detail orientated and clear!
A beautifull presentation and has well represented the concepts about restore and recovery backup
Thank you!
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 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.
Hey Arun You explain all the things very properly, Thank u so much .
Keep watching!
can you upload the basics of sga,pga,log files,contolfiles,tablespaces and datafiles.
great video buddy !!
Glad you enjoyed
your explanation is awesome. simple and clear explanation.
Glad you think so!
Nicely discussed and explained
Thank you!Keep Watching!
Excellent explanation from end-to-end. But for the hot backup/restore which does require shutdown, the DB was actually shutdown. Please can you explain on this. Thank you
The best,well explained video on backup and recover on the you tube.
great job. thanks
Glad it helped 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?
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?
Nice efforts bro keep it up.
Thank you!
1 question -
Cold backup is called consistent backup.
And recovery from cold backup is incomplete.
Then, Why it is called Consistent backup ?
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.
1:23:00 You know you can just run rm /path/path/*.dbf ?
Wonderful Really appreciated Sir
Thanks
Thank you so much Arun.... :)
Sir can we perform complete recovery in cold backup? If no why DBA run database in archive mode?
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.
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?
Great explanation, thank you very much.
Keep watching!
hello guys , i suggest giving an overview location of oracle control files, data files, ,fast recovery area locations on disks
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?
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!
Sir if i am not able to connect to database after db crash then how would i get alert log file location
It's really useful Arun
Thanks a lot
Glad it helped you!
Good
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...
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
Very well explained.
Thank you!
Appreciate your awesome explanation.... :)
Thank you so much
when you simulate recovery ...start the DB without restoring file so it will show error msg... it will be good understanding....
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
Please provide the some more details about RMAN backup and recovery in different server.
oraclegenesis.com/p/oracle-advanced-rman-backup-recovery
Hi... Are you giving online training ?
Yup, you can check our trainings here: dbagenesis.com/courses
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?
do u have more videos of oracle well explained sir
Try our website for video courses: oraclegenesis.com/courses
Nice video =))
Thank you!
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
very good Thanks
Thank you!
This video is really Helpful..Thanks a lot...
What command we will fire if Control Files are lost ?
Thank you so much
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
Grate job. Carry on.
Thank you!
Nice explanation ..
Thank you!
Thank you.
Sir good morning
Please make video same as 12c
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...
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
Is it same in 10g or different
Hii arun , awsm explanation can i have logical backup and recovery topic .
sir how many days for linux course ?
oraclegenesis.com/p/linux-administration-for-beginners
For BCP
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, 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/
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.
10:55
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
Hey I think I know that guy!
can u please share that ppt
Keep the Backup offsite
Thank you!
Can I get some discount am student . ?
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
Nice tutorial. And yet another Mr Nay’s accent…
Video starts
@9:25
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