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