RMAN Recovery Scenario - Tablespace Restore and Recovery - All the Datafiles of TS lost or Corrupt

ALL DATAFILES OF A TABLESPACE GOT CORUPTED / LOST
===============================================

Scenario 1: Database NOT Open
Scenario 2: Database is Open

Scenario 1: Database NOT Open
===========

set lines 1000
col FILE_NAME for a50;
select FILE_NAME, TABLESPACE_NAME from dba_data_files order by 2 desc;

startup mount

rman target /

restore tablespace users;

recover tablespace users;

alter database open;

Scenario 2: Database is Open
===========
ALTER TABLESPACE USERS OFFLINE IMMEDIATE;

rman target /

RESTORE TABLESPACE USERS;

RECOVER TABLESPACE USERS;

alter tablespace users online;

#RMAN #Tablespace #TablespaceRestore #TablespaceRecovery #AllDatafilesOfTSLost #TS #Backup #Restore #Recovery #Oracle #RAC #Database #Exadata #ASM

Please do follow me and support me on,

Skype: malluramadurg

Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Skype: malluramadurg

[nagarjunag]

Thanks Mallik for uploading helpful videos

[amrsiam]

Thank you very much, gazak ALLAH khair @mallik

[Eira.]

Hi Mallik thanx for your video ... Just had I confusion ..if any datafile is dropped then db willbe up and running ?? And were there be any alert throwing for the datafile dropped ??

[satheeshkumarrangasamy]

Hi Mallik,

Great thanks for the useful videos.

I could see the whatsapp group got filled up.

Can u help me to get the documents through any other ways

[shaikshoukath]

Thanks mallik, very clear explanation. Can you please share the doc in pdf

[vigneshs]

sir what is ur new whats app link, old link not working

[Eira.]

Hi malik can you pls give me link for joining your group

[thanhnamus]

Hello, please give me your scenario .pdf