Oracle Rman Backup and Recovery Interview Questions and Answers - 1

Question: 1

What is the difference between hot backup and cold backup?

Hot backup is taken when database is still online while cold backup is taken when database is offline.

Database needs to be in the archive log mode for the hot backup but there is no such requirement for the cold backup.

Question: 2

What is a backup piece?

Backup piece is a physical binary file created by RMAN during a backup. They are written to a backup medium, such as disk or tape.

Backup pieces contain blocks from the target database’s datafiles, archived redo log files, and control files.

The following rules must be kept in mind while constructing a backup piece from datafiles:

A datafile cannot span backup sets

A datafile can span backup pieces as long as it stays within one backup set

Datafiles and control files can coexist in the same backup sets

Archived redo log files are never in the same backup set as datafiles or control files

RMAN is the only tool that can operate on backup pieces; therefore, you must use the RMAN tool if you need to restore a file from an RMAN backup.

Question: 3

What is RMAN?

RMAN is an Oracle supplied tool or utility that can be used to manage backup and recovery activities.

Question: 4

Can you take offline backup with RMAN?

Yes

Question: 5

Which files must be backed up?

The following files must be backed up

Database files

Control files

Archived log files

 Password files

INIT.ORA