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,

LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg


Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: [email protected]
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg