********************************************************
* Description: Enable Oracle database archive log mode.
* Compatiablity: RDBMS 11g, 12c
* Date: 02:35 PM EST, 03/24/2017
********************************************************


<1> Setup Archive Log Location:
    |
    |__ o. FRA will be default archive log location if destination parameter was not explictly indicated before activing archiving mode.
    |
    |__	SQL> alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=C:\app\oracle\oradata\archivelog';
	
	
	
	
<2> Database needs to be bounced for enabling archive log mode:
    |
    |__ SQL> shutdown immediate;
        SQL> startup mount;
        SQL> alter database archivelog;
        SQL> alter database noarchivelog;
        SQL> alter database open;

	
	
	
<3> Switching Log File to Verify:
    |
    |__ SQL> alter system switch logfile;
	 
	
	

Your Comments