Modes used for transmitting archived logs to their destination - Oracle Redo Log

Q.  Which modes are used for transmitting archived logs to their destination in  the Specifying Mode of Log Transmission?
- Published on 12 Aug 15

a. Normal archiving transmission
b. Standby transmission
c. Both A & B
d. None of the above

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - The two modes of transmitting archived logs to their destination are normal archiving transmission and standby transmission mode.

    1. Normal Transmission Mode
    - In normal transmission mode, the archiving destination is another disk drive of the database server.

    - In this configuration archiving does not contend with other files required by the instance and can complete more quickly.

    - Specify the destination with either the LOG_ARCHIVE_DEST_n or LOG_ARCHIVE_DEST parameters.

    - It is good practice to move archived redo log files and corresponding database backups from the local disk to permanent inexpensive offline storage media such as tape.

    - A primary value of archived logs is database recovery, so you want to ensure that these logs are safe should disaster strike your primary database.

    2. Standby Transmission Mode
    - In standby transmission mode, the archiving destination is either a local or remote standby database.

    - If you are operating your standby database in managed recovery mode, you can keep your standby database synchronized with your source database by automatically applying transmitted archive logs.

    - To transmit files successfully to a standby database, either ARCn or a server process must do the following:
    Recognize a remote location
    Transmit the archived logs in conjunction with a remote file server (RFS) process that resides on the remote server

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.)