RMAN Recovery Scenario -Datafile Lost or Datafile Corrupt - How to restore & Recover the Datafile?

Only one data file is lost or corrupted
SCENARIO-1: DATABASE IS NOT OPEN
SCENARIO-2: DATABASE IS OPEN
CASE 1: Datafile image copy from FRA
CASE 2: Datafile restore from backup
SCENARIO-1: DATABASE IS NOT OPEN
===========
startup mount;
rman taregt /
list backup;
restore datafile 4;
recover datafile 4;
alter database open;
SCENARIO-2: DATABASE IS OPEN
==========
CASE 1: Datafile image copy from FRA
==============================
report schema;
list copy of datafile 4;
--- backup as copy database tag 'FullImageBackup';
sql ‘alter database datafile 4 offline’;
switch datafile 4 to copy;
recover datafile 4;
sql ‘alter database datafile 4 online’;
report schema;
cd /u01/app/oracle/oradata/DEVDB/
mv users01.dbf users01.dbf_backup
backup as copy datafile 4 format ‘/u01/app/oracle/oradata/DEVDB/users01.dbf’;
sql ‘alter database datafile 4 offline’;
switch datafile 4 to copy;
recover datafile 4;
sql ‘alter database datafile 4 online’;
report schema;
CASE 2: Datafile restore from backup
====================================
rman target /
sql “alter database datafile ”/u01/app/oracle/oradata/DEVDB/users01.dbf” offline”;
restore datafile '/u01/app/oracle/oradata/DEVDB/users01.dbf';
recover datafile '/u01/app/oracle/oradata/DEVDB/users01.dbf';
sql “alter database datafile ”/u01/app/oracle/oradata/DEVDB/users01.dbf” online”;
select file_name from dba_data_files;
#RMAN #DataFileLost #DatafileCorrupt #Backup #Restore #Recovery #Oracle #RAC #Database #Exadata #ASM
Please do follow me and support me on,
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Email: [e-mail]
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg

[@nagarjunag9596]

Thanks Mallik for making useful videos

[@Mallik034]

Thanks for liking!!! Keep watching my sessions

[@padmajarani9392]

Very Good Explanation. thank you Bro

[@sampadmukherjee928]

Nice explanation Sir.

[@Nareshreddy-ot3fc]

very good explanation ,awesome :)

[@Mallik034]

Glad you liked it!

[@mohitmaurya4363]

Best channel I must say

[@BHARARHROYAL]

Great efforts sir

[@Mallik034]

Thanks

[@sannapareddyasritha9409]

Hi sir.thanks for your videos nd explanation..May I get the document for rman restore and Recovery..

[@quangphamngoc366]

thank

[@meghakaradi]

❤

[@Mallik034]

Thanks