Topic : Backup and Recovery

What is the use of ALERT log file? Where can you find the ALERT log file?


Answer :

- Alert log file is a log file that records database-wide events which is used for trouble shooting.
- We can find the Log file in BACKGROUND_DUMP_DEST parameter.
- Following events are recorded in ALERT log file:
- Database shutdown and start

Show Answer Discuss

What happens if a failure corrupts the datafiles?


Answer :

When a datafile is lost; the corrupted file can be restored from a backup. After the datafile is restored; the redo log files and archive log files can reapply any changes made before the time of the failure. No data is lost.

Show Answer Discuss

Which type of table relationship associates more than one record in a given table with more than one record in another table?


Answer :

A many?to?many relationship associates more than one record in a table with more than one record in another table.

Show Answer Discuss

What Oracle object is used for recovery operations?


Answer :

The redo log files and the archive log files are used for database recovery.

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