HOW TO ENABLE DISABLE ARCHIVE LOG MODE IN ORACLE 11G DATABASE

preview_player
Показать описание
HOW TO ENABLE DISABLE ARCHIVE LOG MODE IN ORACLE 11G
====================================================

archive log list;
show parameter log_archive_dest_1;
show parameter recovery;

Enable archive log mode:
========================
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;

Disable archive log mode:
=========================
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;
Рекомендации по теме