How can you enable ARCHIVELOG mode for an Oracle database and define the FRA area settings?

To enable the ARCHIVELOG mode:

  • run the SQL command interpreter, eg. sqlplus.exe:

issue the command -> Start Menu -> Run ->  „sqlplus.exe /nolog”

  • using the „connect SYS/hasło as SYSDBA” command, connect the interpreter to the default instance of the Oracle database (in the Express Edition it is “XE”) as a full SYS user.
  • create a target directory for the FRA area and issue the command string:

SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ‚nazwa_partycji:katalog’;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 15G;
ALTER DATABASE OPEN;
Exit

The database will be stopped and then started with the new settings.