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;

No comments:

Post a Comment