Backup & Recovery (COLD)

Scenario 1: How to take cold backup and Restore the database.

Scenario 2. Apply archive logs to a cold backup to roll forward the database

Scenario 3: All my Datafiles in a User tablespace are accidentally lost, Can I perform DML operations on objects associated with that Tablespace

Scenario 4: Will there be data loss if all the redo log files are lost after the database was gracefully shutdown

Scenario 5: Loss of Control File

Scenario 6: Loss of datafiles associated with System Tablespace

Scenario 7: Loss of datafiles associated with UNDO Tablespace

Scenario 8: Loss of datafiles associated with Users Tablespace

Scenario 9: Loss of redo log files

Scenario 10: An Unbacked up datafile/tablespace is lost

Scenario 11: Object Point in Time Recovery