RMAN Recovery - How to restore Database When All Datafiles Were Lost for ASM Oracle Restart Database

All Datafiles are Lost

Note:
show parameter spfile
select NAME from v$controlfile;
select name from v$datafile;

SQL] startup nomount;
rman target /
alter database mount;
restore database;
recover database;
alter database open;

Read only tablespaces:
--- By default, the restore command skips datafiles associated with read-only tablespaces
restore database check readonly;

Temporary Tablespaces:
You don’t have to restore or re-create missing locally managed temporary tablespace tempfiles.

Restore form some specific backups which you tagged:
restore database from tag Weekly_Backup

How to use until clause with RMAN restore command

Until SCN
restore database until SCN 5634174;

Until sequence
restore database until sequence 17;

Until restore point
restore database until restore point RESTORE_POINT;

Note:
CREATE RESTORE POINT before_upgrade_1; ----------- normal restore point
CREATE RESTORE POINT before_upgrade_2 GUARANTEE FLASHBACK DATABASE; ----------- GUARANTEE restore point
select * from v$restore_point;

Until time
restore database until time ‘sysdate – 5′;
restore database until time “to_date(’08-jan-2014 13:00:00′, dd-mon-rrrr hh24:mi:ss’)”;

#RMAN #AllDataFilesLost #Restore #Recovery #Oracle #RAC #Database #Exadata #ASM #OracleRestart

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