Topic : Backup and Recovery

What are the different modes of mounting a Database with the Parallel Server?


Answer :

Exclusive Mode If the first instance that mounts a database does so in exclusive mode; only that Instance can mount the database.
Parallel Mode if the first instance that mounts a database is started in parallel mode; other instances that are started in parallel mode can also mount the database.

Show Answer Discuss

What is full backup?


Answer :

A full backup is an operating system backup of all data files; on-line redo log files and control file that constitute ORACLE database and the parameter.

Show Answer Discuss

What is Partial Backup?


Answer :

A Partial Backup is any operating system backup short of a full backup; taken while the database is open or shut down.

Show Answer Discuss

Explain the difference between a hot backup and a cold backup and the benefits associated with each.


Answer :

A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is shut down and does not require being in archive log mode. The benefit of taking a hot backup is that the database is still available for use while the backup is occurring and you can recover the database to any point in time. The benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process. In addition; since you are taking cold backups the database does not require being in archive log mode and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

Show Answer Discuss

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.


Answer :

ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. NOARCHIVELOG mode is basically the absence of ARCHIVELOG mode and has the disadvantage of not being able to recover to any point in time. NOARCHIVELOG mode does have the advantage of not having to write transactions to an archive log and thus increases the performance of the database slightly.

Show Answer Discuss