Oracle RMAN Backup & Restore LAB

[@elizabethrivera-ve2kb]

you are very good at teaching, thank you so much :)

[@DB2_Oracle]

Thank you for nice comment

[@SulisakVANNASING]

very nice explanation

[@ericksonezekiel4104]

Awesome session bro ❤

[@shorifulislam923]

good explanation

[@DB2_Oracle]

Thanks for liking

[@nihadawad7340]

Many thanks from Palestine

[@Sajee2009]

Thank you for the very useful video.
one question. what if auto backup is not enabled and control files are deleted?

[@DB2_Oracle]

You can always create controlfile manually. It is possible but difficult.

[@SulisakVANNASING]

I need to award you 100000 stars

[@DB2_Oracle]

This means a lot. Thank You.

[@morshedulislamriaad6496]

Can you tell me how you setup the environment? I'm new to DBA.

[@DB2_Oracle]

First Install VirtualBox (Free for personal use)
Then Download RedHat or Oracle Enterprise Linux (Free)
Then install OS
Then Download Oracle Database Software
Then Install Oracle Software
Then Create Oracle Database
All of the Videos are available on my channel

[@morshedulislamriaad6496]

@@DB2_Oracle ThankYou very much

[@abrarahmed-ve8kz]

sir while recovering the datafile, that time have backup of the database, how rman restore and recover the datafile? is it from the redo log files or what I didnt get it?

[@henryzhong]

Thank you!

[@gotchihaeyo1825]

Shut Abort
Startup Mount
Rman) restore Datafile 5 ;
Rman) recover Datafile 5 ;
SQL) Alter database open ;
Would this work as well with the Datafile 5 online? Thank you !!

[@DB2_Oracle]

This will work. As you have put the database in MOUNT mode
However if you want to restore datafile while database is online, you need to mark that datafile offline
Use alter tablespace command before restore