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