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?
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
E.
re-creating the control files, after you lost all the control files in your database
Oracle Database lets redo log files to one or more offline destinations = the archived redo log. The process of archived redo log files is called archiving. This process is only possible if the database is running in ARCHIVELOG mode.
You can use archived redo logs to:
Recover a database
Changing the Database Archiving Mode
To change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause.
1. Shut down the database instance.
2. Back up the database. Before making any major change to a database, always back up the database to protect against any problems. This will be your final backup of the database in NOARCHIVELOG mode and can be used if something goes wrong during the change to ARCHIVELOG mode.
3. Edit the initialization parameter file
4. Start a new instance and mount, but do not open, the database.
STARTUP MOUNT
To enable or disable archiving, the database must be mounted but not open.
MOUNT – ENABLE – DISABLE – LOG