Enabling or disabling redo log archiving Operation start database in MOUNT state

Q.  You executed the STARTUP MOUNT command to start your database, for which database Operation do you need to start the database in the MOUNT state?
- Published on 04 Aug 15

a. Renaming the control files
b. Dropping a user in your database
c. Enabling or disabling redo log archiving
d. Dropping a tablespace in your database

ANSWER: Enabling or disabling redo log archiving
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - You can start an instance and mount a database without opening it, which you can do when you want to perform specific maintenance operations.

    - For example, the database must be mounted but not open during the following tasks:
    1. renaming datafiles
    2. adding, dropping, or renaming redo log files
    3. enabling and disabling redo log archiving options
    4. performing full database recovery

    - Start an instance and mount the database, but leave it closed by using the STARTUP command with the MOUNT option:
    STARTUP MOUNT;

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