alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
Database altered.
SQL> select log_mode from v$database;
LOG_MODE
------------------------
ARCHIVELOG
SQL>
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL>
System altered.
SQL>show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
log_archive_dest_1 string location=/opt/oracle/archive_l
og/archive_log
log_archive_dest_10 string
SQL>
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/oracle/archive_log/archive_log
Oldest online log sequence 4
Next log sequence to archive 6
Current log sequence 6
SQL>
System altered.
SQL>
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
log_archive_format string %t_%s_%r.dbf
SQL> alter system set log_archive_format = "archive_%t_%s_%r.log" scope=spfile;
System altered.
SQL> show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
log_archive_format string %t_%s_%r.log
SQL>