DEMO-2: Performing HOT Backup and Recovery || All Data files were lost - Recovery Scenario

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,

Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]

[PGExcellenceClasseswecan]

what happen in background when we hit
Alter database begin backup;
Could you please tell sir

[durgarao]

How to create the backup location starting step