Sunday, 1 May 2011

How to enable archivelog mode in Oracle 11g database

1. Shutdown the Database

shutdown immediate

2. start the Database in mount mode

startup mount

3. enable the Database in archive log mode

alter database archivelog;

4. open the Database

alter database open;

5. If need to change the log_archive_dest_1 path then

SQL> alter system set log_archive_dest_1='/home/oracle/archivelog' scope=spfile;
alter system set log_archive_dest_1='/home/oracle/archivelog' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFIL

the solution

alter system set log_archive_dest_1='location=/u01/app/oracle/archivelog' scope=spfile;

System altered.

Cheer!!!!!!!!!!

No comments:

Post a Comment