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
For the database to be set in Archievelog mode,database needs to be in mounted state.
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.
Enabling Archive log provides high availibilty feature since active logs are used in RMAN backups,dataguard etc.
When you enable this mode redo logs will be archived instead of overwritten.
Steps:
step 1:Check if dB is in archive log mode or not
SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;
LOG_MODE
————
NOARCHIVELOG
Step 2:change the following parameters
log_archive_dest_1=’location=/u02/oradata/cuddle/archive’
log_archive_start=TRUE
Step 3:Shutdown and then Bring database to MOUNT mode
[oracle@vixen pfile]$sqlplus sys/passwd as sysdba;
SQL*Plus: Release 10.1.0.2.0 – Production on Fri Oct 15 16:00:58 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 184549376 bytes
Fixed Size 1300928 bytes
Variable Size 157820480 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
Step 4 :enable archivng mode
SQL> alter database archivelog;
Database altered.
Step 5:open the database
SQL> alter database open;
Database altered.
step 6:check again in which mode the dB is
SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;
LOG_MODE
————
ARCHIVELOG