Hello Friends,

Here with one more topic on.

DEMO-3: HOT Backup and Recovery || All Data files and Control file were lost - Recovery Scenario:
====================================================================================
Performing Hot Backup:
- DB must be up and running
- No downtime required
- Put the Database in begin backup mode
- alter database begin backup;
- select distinct status from v$backup
- select name from v$controlfile;
- select name from v$datafile;
- Copy all the file at OS level to Hot backup location
- Put the Database in end backup mode
- alter database end backup;
- select district status from v$backup;
- Switch the log file
- alter system switch logfile;
- Take the backup of archive logs

Hot Database Recovery (All Datafiles and Control files were lost):
- Get the location of all the files to be backed up.
- select name from v$controlfile;
- select name from v$datafile;
- Delete all the data files and confilfile from OS level
- shutdown the database (Shut abort or kill the OS level instance process)
- Copy/Restore all the data & Control files from the hot backup location (restoring from backup)
- Startup mount
- recover database using backup controlfile until cancel; (applying archive logs/redo logs)
- AUTO
- recover database using backup controlfile until cancel;
- CANCEL
- Alter database open resetlogs;
(resetlogs will reset the log sequence the start the archive log sequence starting from 1. Database new in-carnation is started)

- login to database check the archive log sequence
- archive log list


#HotBackupandRecovery #RMAN #Backup #Recovery #oracle #database #ColdBackup #Hotbackup #ManualBackup #RMANbackup

Please do follow me and support me on,

Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter:https://twitter.com/mallik034
Instagram:https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA