Hello Friends,

Here with one more topic on.

DEMO-1: Performing Cold Backup and Recovery || Oracle Database Backup and Recovery scenarios:
====================================================================================
Performing Cold Backup and Recovery:
- Get the location of all the files to be backed up.
--- parameter file: $ORACLE_HOME/dbs
--- select name from v$controlfile;
--- select name from v$datafile;
- Shutdown the Database
- Copy all the files to a Cold backup location
- Start the Database and create some dummy tables
- Simulate the failure by removing all files at OS level
- Shutdown the database (Shut abort or kill the OS level instance process)
- Copy the parameter file from the Cold backup location to original location
- Start the instance in no mount state.
- Copy the control files from Cold backup location to original location
--- You can query show parameter controlfile;
- Take the instance to mount state
- Copy all the datafiles from Cold backup location to original location
- Open the Database
- Check for the dummy table which are created?
--- Dummy table will not be exists due to incomplete recovery

#ColdBackupandRecovery #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