Oracle Database Backup and Recovery Session 1

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

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

Nicely discussed and explained

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

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

Hi Arun- If the Database is in Mount mode, and the backup is taken. Will it be considered as hot or cold backup ?

great video buddy !!

Hey I think I know that guy!

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

A beautifull presentation and has well represented the concepts about restore and recovery backup

is this how it could be at work. like this is exactly how we will do these things in a working real life environment?

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

Supb briefing

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?

your explanation is awesome. simple and clear explanation.

Great instruction! Could you please include timestamps in the description box for the different topics covered, thanks

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 ?

Great explanation 👌
I want these ppt

Good

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

Thank you so much Arun.... :)

explanation is good but using more time for this small topic he has taken more than 2 hours its only take 30 minutes job

Hi... Are you giving online training ?

Sir, Please share your E-mail Id I need to write something to you.

Good learning for beginners!! Watched it at 1.5x Speed

all the guys in the class must be sleeping haha. No one answers to his questions

ORA-03113 end-of-communication channel is error ka solution bataiye

Keep the Backup offsite

For BCP

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?

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

Sir good morning
Please make video same as 12c

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.

Nice video =))

Can I get some discount am student . ?

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 ?

Nice efforts bro keep it up.

It's really useful Arun
Thanks a lot

Is it same in 10g or different

very good Thanks