You want to enable archiving on your database. Presently, the database is running in
NOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:
1. Shut down the instance.
2. Execute the ALTER DATABASE ARCHIVELOG command.
3. Start up the instance and mount the database.
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task?
A.
4, 1, 3, 2, 5
B.
1, 3, 4, 5, 2
C.
1, 3, 2, 5; 4 not required
D.
4, 1, 5, 2; 3 not required
E.
1, 3, 4, 5; 2 not required
You set the initial archiving mode as part of database creation in the CREATE DATABASE statement. Usually, you can use the default of NOARCHIVELOG mode at database creation because there is no need to archive the redo information generated by that process. After creating the database, decide whether to change the initial archiving mode.
If ARCHIVELOG mode, must have initialization parameters set
Shut down the database instance.
Back up the database.
Edit the initialization parameter file
Start a new instance and mount, but do not open, the database.
===============================================================
So to bring dB in mounted state ,
first shutdown the database
Start it with nomount mode(reads pfile)and then mount mode(reads controlfile)
Bring the database to ARCHIVELOG mode from NOARCHIEVE log mode.
and lastly,open the database.
why not A? You can ‘Set the DB_RECOVERY_FILE_DEST’ before shutdown the database.