Explanation: To enable or disable archiving, the database must be mounted but not open.
Note: See step 5 below.
Changing the Database Archiving Mode
To change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause. To change the archiving mode, you must be connected to the database with administrator privileges (AS SYSDBA).
The following steps switch the database archiving mode from NOARCHIVELOG to ARCHIVELOG:
1.Shut down the database instance
2.Back up the database.
3.Edit the initialization parameter file to include the initialization parameters that specify the destinations for the archived redo log files
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.
5.Change the database archiving mode. Then open the database for normal operations.
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
6.Shut down the database.
SHUTDOWN IMMEDIATE
7.Back up the database.
