Hello Friends,

Here with one more topic on.

DEMO-2: Performing HOT Backup and Recovery || All Data files 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 were lost):
- Get the location of all the files to be backed up.
- select name from v$datafile;
- Delete all the data file from OS level
- Shutdown the database (Shut abort or kill the OS level instance process)
- Copy/Restore all the data files from the hot backup location (Restoring from backup)
- Startup mount
- Recover database (This part if applying archive logs/redo logs)
- Alter database open;

#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