Personal tools
You are here: Home → Oracle → How To's → How to change the Archive log mode in Oracle
Navigation
Log in


Forgot your password?
 
Document Actions

How to change the Archive log mode in Oracle

by Mohan Reddy — last modified 2010-08-04 02:15

Change the Oracle Parameters related to Archive log.

select * from v$parameter where name like '%arch%'

see the blow given parameters (and there are other parameters also) :


LOG_ARCHIVE_START = FALSE

LOG_ARCHIVE_DEST

Change the parameter values :

ALTER SYSTEM SET LOG_ARCHIVE_DEST='LOCATION=<path>/arch'

ALTER SYSTEM SET LOG_ARCHIVE_START = TRUE

Change the Database to archive log mode:


sqlplus / as sysdba

sql>shutdown immediate

sql>startup mount

sql>alter database archive log

sql>alter database open

 Now the database in Archive log mode.










Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls