Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Friday, April 15, 2011

Change to Archivelog mode

Follow the steps below to change a database to ArchiveLog mode.


ALTER SYSTEM SET log_archive_dest_1 = 'location=/oradata/ORCL/arch/ mandatory' scope=spfile;

shutdown immediate

startup mount

alter database archivelog;

alter database open;

archive log list;