Oracle DBA Backup and Recovery Interview Questions - 2

Question: 6

What is the difference between incremental backup and differential backup?

Both, incremental and differential backup files that have been modified or created after the previous backup.

However, attributes are reset after the incremental backup but not after the differential backup.

Question: 7

Can you take online backup of a control file?

Yes, by using the following statement:

Alter database backup controlfile to ‘<location>’ or trace.

Question: 8

Can you backup the online redo log files?

We cannot backup the online redo logs; however online redo logs are protected by multiplexing and optionally by archiving.

Question: 9

What is logical backup?

Logical backup is a process of extracting data in the form of SQL statements, where it is useful to recover in case the objects are lost.

The main drawback of using this backup is that MEAN TIME TO RECOVER is high.

Question: 10

Which tools can you use for full backup?

You can use either the operating system utilities or the RMAN utility for full backup.

However, Oracle recommends the use of RMAN utility.