RMAN Recovery - How to restore Database When All Datafiles Were Lost for ASM Oracle Restart Database
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: malluramadurg@gmail.com
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
Видео RMAN Recovery - How to restore Database When All Datafiles Were Lost for ASM Oracle Restart Database канала Mallik034
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: malluramadurg@gmail.com
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
Видео RMAN Recovery - How to restore Database When All Datafiles Were Lost for ASM Oracle Restart Database канала Mallik034
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
TAF | RAC ArchitectureWhat is RPO & RTO? RMAN Backup & Recovery #training #oracle #oracledba #oracleworldOracle Restart Maintenance | GI #oracle #database #onlinetraining #oracledbaRAC Database Vs RACOneNode Database #oracle #oraclerac #database #liveclassesAdvantages of RAC | RAC Architecture #oracle #oracledba #oracleworld #rac #oracleracHow to connect to Oracle database? #oracle #oracledba #oracleworldFind database alert log?Startup Sequence | Startup Modes #oracledba #oracle #database #dbav$instance Vs v$databaseHow to create user in Oracle? #oracledba #oracleWhen Oracle Patches will be Released? #oracledba #patches #oracleWhen Multitenant Architecture Introduced in Oracle?Definition of DR Database?Unable to connect to PDB - Same PDB Name on 2 CDBsRAC Course Announcement || 01-Jul-2023PDB save state?RMAN Insights || Standby Build Vs RMAN DuplciateDBA Automation with .bash_profileStandalone File System (FS) Database to RAC Database Cloning || RMAN Duplicate DatabaseConfused with RAC Networking?DBA Training || New DBA Batch || 13-Apr-2023 || Oracle 19c Training