******************************************************** * 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