...
| No Format |
|---|
sqlplus / as sysdba SQL> alter system set log_archive_start=TRUE scope=spfile; System altered. |
a) . Shut the database down
| No Format |
|---|
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> |
b) . Bring the database into mount mode and change the archivelog setting and then open the database
| No Format |
|---|
SQL> startup mount ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 456146944 bytes Fixed Size 1344840 bytes Variable Size 348129976 bytes Database Buffers 100663296 bytes Redo Buffers 6008832 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. |
c) . Ensure the database is in archivelog mode
...