Skip to main content

Activate the archive log mode in Oracle XStream mode

Last updated: 5/18/2026

Connect to the Oracle database as an administrative user and run the following statement to display its archiving information:

archive log list;

If the database is not operating in the archive log mode, run the following statements to activate the archive log mode:

shutdown immediate;
startup mount;
alter database archivelog;
alter database open;

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!