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