Backup & Recovery

Explain the different types of backups in Oracle.

What is a cold backup?

Describe a hot backup.

What is RMAN?

How does RMAN work?

Explain the difference between image copy and backup set in RMAN.

What are RMAN channels?

How do you configure RMAN?

What is a control file backup?

How do you perform a control file backup?

Explain the concept of archive log mode.

How do you enable archive log mode?

What is an archived redo log file?

Describe the process of recovering a database.

What are the different types of recovery?

Explain instance recovery.

What is media recovery?

How do you perform a complete recovery?

Describe the steps for incomplete recovery.

What is a point-in-time recovery?

Explain how to recover a dropped table.

What is the Flashback feature in Oracle?

Describe Flashback Database.

How do you enable Flashback Database?

What is Flashback Query?

Explain Flashback Table.

How do you use Flashback Drop?

What is Flashback Transaction?

Describe Flashback Data Archive.

How do you recover from a corrupted block?

What is Data Pump?

Explain how Data Pump works.

What are the benefits of using Data Pump?

Describe the steps for exporting data using Data Pump.

How do you import data using Data Pump?

What is transportable tablespace?

How do you use transportable tablespace?