Best User-Managed Backup on KZread...Very well explained and good demonstration of recovering from different failure simulations.

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

Жыл бұрын

Thank you so much!

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

@dbagenesis

3 жыл бұрын

Thank you!

Hey Arun You explain all the things very properly, Thank u so much .

@dbagenesis

3 жыл бұрын

Keep watching!

Even in 2023 still very usefull. Thank you very much for clear explanation and simple examples.

@dbagenesis

Жыл бұрын

Thank you!Keep watching

The best,well explained video on backup and recover on the you tube. great job. thanks

@dbagenesis

3 жыл бұрын

Glad it helped you

You Indian guys make the best teachers =)

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.

can you upload the basics of sga,pga,log files,contolfiles,tablespaces and datafiles.

Wonderful Really appreciated Sir

@dbagenesis

3 жыл бұрын

Thanks

Great explanation, thank you very much.

@dbagenesis

3 жыл бұрын

Keep watching!

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?

Appreciate your awesome explanation.... :)

@dbagenesis

3 жыл бұрын

Thank you so much

your explanation is awesome. simple and clear explanation.

@dbagenesis

3 жыл бұрын

Glad you think so!

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

What a brilliant explanation sir🎉🎉

when you simulate recovery ...start the DB without restoring file so it will show error msg... it will be good understanding....

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?

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?

Very well explained.

@dbagenesis

3 жыл бұрын

Thank you!

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 ?

hello guys , i suggest giving an overview location of oracle control files, data files, ,fast recovery area locations on disks

Grate job. Carry on.

@dbagenesis

3 жыл бұрын

Thank you!

It's really useful Arun Thanks a lot

@dbagenesis

3 жыл бұрын

Glad it helped you!

Thank you so much Arun.... :)

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 video buddy !!

@dbagenesis

2 жыл бұрын

Glad you enjoyed

Nicely discussed and explained

@dbagenesis

Жыл бұрын

Thank you!Keep Watching!

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

Please provide the some more details about RMAN backup and recovery in different server.

@dbagenesis

7 жыл бұрын

oraclegenesis.com/p/oracle-advanced-rman-backup-recovery

Is it same in 10g or different

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

8 жыл бұрын

+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

8 жыл бұрын

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?

This video is really Helpful..Thanks a lot... What command we will fire if Control Files are lost ?

@dbagenesis

3 жыл бұрын

Thank you so much

Sir if i am not able to connect to database after db crash then how would i get alert log file location

Nice explanation ..

@dbagenesis

3 жыл бұрын

Thank you!

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...

1:23:00 You know you can just run rm /path/path/*.dbf ?

Nice video =))

@dbagenesis

3 жыл бұрын

Thank you!

very good Thanks

@dbagenesis

3 жыл бұрын

Thank you!

Sir can we perform complete recovery in cold backup? If no why DBA run database in archive mode?

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!

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 👍

Great explanation 👌 I want these ppt

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.

Nice efforts bro keep it up.

@dbagenesis

3 жыл бұрын

Thank you!

Hii arun , awsm explanation can i have logical backup and recovery topic .

can u please share that ppt

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...

do u have more videos of oracle well explained sir

@dbagenesis

7 жыл бұрын

Try our website for video courses: oraclegenesis.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 ?

@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?

sir how many days for linux course ?

@dbagenesis

7 жыл бұрын

oraclegenesis.com/p/linux-administration-for-beginners

Supb briefing

Good

Sir good morning Please make video same as 12c

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

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!

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

For BCP

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

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

8 жыл бұрын

+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.

Sir i am interested to take ORACLE DBA coaching near you online. Waiting for reply sir.

@dbagenesis

2 жыл бұрын

Check our video courses here: dbagenesis.com/p/courses

10:55

Can I get some discount am student . ?

Hi... Are you giving online training ?

@dbagenesis

4 жыл бұрын

Yup, you can check our trainings here: dbagenesis.com/courses

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/

1 question - Cold backup is called consistent backup. And recovery from cold backup is incomplete. Then, Why it is called Consistent backup ?

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

Hey I think I know that guy!

Keep the Backup offsite

@dbagenesis

3 жыл бұрын

Thank you!

Nice tutorial. And yet another Mr Nay’s accent…

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