RMAN Recovery Scenario - How to restore Database When All Datafiles Were Lost for Standalone DB
HTML-код
- Опубликовано: 19 окт 2024
- 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
Please do follow me and support me on,
LinkedIn: / mallik034
RUclips: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
RUclips: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg