Enabling archivelog
The following steps check whether archivelog is enabled and, if not, enable it.
Log in to SQL*Plus as the sys user.
Enter the following command:
select log_mode from v$database;
If the command returns
ARCHIVELOG
, it is enabled. Skip ahead to Enabling supplemental log data.If the command returns
NOARCHIVELOG
, enter:shutdown immediate
Wait for the message
ORACLE instance shut down
, then enter:startup mount
Wait for the message
Database mounted
, then enter:alter database archivelog; alter database open;
To verify that archivelog has been enabled, enter
select log_mode from v$database;
again. This time it should returnARCHIVELOG
.