Archived redo logs use - Oracle Redo Log

Q.  What are the Archived redo logs used for?
- Published on 12 Aug 15

a. Recover a database
b. Update a standby database
c. Get information about the history of a database using the LogMiner utility
d. All mentioned above

ANSWER: All mentioned above
 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - Oracle Database lets you save filled groups of redo log files to one or more offline destinations, known collectively as the archived redo log.

    - The process of turning redo log files into archived redo log files is called archiving.

    - This process is only possible if the database is running in ARCHIVELOG mode.

    - You can choose automatic or manual archiving.

    - You can use archived redo logs to:
    1. Recover a database
    2. Update a standby database
    3. Get information about the history of a database using the LogMiner utility

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)