Hello Friends,

Here with one more topic on.

DEMO-4: HOT Backup and Recovery || All Data and Control files were lost with Transactions - 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
- 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

Performing Hot Backup and Recovery (All Datafiles and Control files were lost):
- 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
- Copy all the file at OS level to Hot backup location
- Put the Database in end backup mode
- alter database end backup;
- select distinct status from v$backup;
- Switch the log file
- alter system switch logfile;
- Take the backup of archive logs
- Create a new user and create a dummy table
- Simulate failure of controlefile and datafile loss and recover the Database
- Check if new user and dummy table exists or not

#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