Тёмный

RMAN Recovery Scenario - system datafile corrupted or lost - What to do? 

Vismo Technologies
Подписаться 22 тыс.
Просмотров 9 тыс.
50% 1

High Level Steps:
==============
RMAN - Database backup:
rman target /
CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN] backup database plus archivelog;
RMAN] backup database format='/u01/backup/backup_%d_%T_%U';
RMAN] backup archivelog all format='/u01/backup/archive_%d_%T_%U';
RMAN] list backup of tablespace system;
SQL] shut immediate
SQL] shut abort;
SQL] startup mount;
RMAN] restore datafile 1;
$ls -ld system*
SQL] select file#,checkpoint_change#, status, recover from v$datafile_header;
RMAN] recover datafile 1;
SQL] select checkpoint_change#, status, recover FROM v$datafile_header;
SQL] alter database open;
Please refer the below blog for more details:
mallik034.blog...
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 12   
@padmajarani9392
@padmajarani9392 Год назад
Thank you sir very useful video with clear explanation
@Mallik034
@Mallik034 Год назад
You are welcome
@sivakrishna5796
@sivakrishna5796 2 года назад
Your way of explanation is very good sir
@sivakrishna5796
@sivakrishna5796 2 года назад
Thank you sir, please make vedios based on real time scenarios
@akashmusale4558
@akashmusale4558 Год назад
Very well explained sir 🙂
@pavanbravo7308
@pavanbravo7308 2 года назад
Critical issue resolution in simple way with clarity👌
@PGExcellenceClasseswecan
@PGExcellenceClasseswecan 2 года назад
In Sysaux Recovery we need to do Datafile offline then doing restore and recover But in System file only restore no need to offline datafile why??
@prabhavpushkar3869
@prabhavpushkar3869 Год назад
system is recovered in mount mode here. so no offline needed.
@commonmanvvr
@commonmanvvr 2 года назад
👏
@meghakaradi
@meghakaradi 2 года назад
❤❤
@nagaraju.5674
@nagaraju.5674 2 года назад
Hello sir
Далее
Oracle RMAN Backup & Restore LAB
1:15:30
Просмотров 8 тыс.
RMAN Backup and Recovery | Oracle Backup
58:42
Просмотров 14 тыс.
RECOVER LOST  DataFile in oracle database
15:33
Просмотров 14 тыс.