Friday, June 18, 2010

Archive Log Setting

ALTER SYSTEM SET log_archive_dest_1='location=PATH' SCOPE=spfile;

ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

Shutdown

startup mount;

alter database archivelog;

alter database open;

No comments: