Archive Logs

archive log list;

startup mount;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/flash_recovery_area MANDATORY' SCOPE=SPFILE;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_10='LOCATION=/u01/app/oracle/flash_recovery_area_10 MANDATORY' SCOPE=SPFILE;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/u02/oracle/flash_recovery_area/1 MANDATORY' SCOPE=SPFILE;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_10='LOCATION=/u02/oracle/flash_recovery_area/10 MANDATORY' SCOPE=SPFILE;

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

shutdown immediate;

startup;

log file - /u01/app/oracle/diag/rdbms/orcl/orcl/alert