ARCHIVELOG

Установить размер и расположение FRA

ALTER SYSTEM set DB_RECOVERY_FILE_DEST_SIZE = 200G scope = both;
ALTER SYSTEM set DB_RECOVERY_FILE_DEST = ‘D:\flash_recovery_area’ scope = both;

—Как узнать в каком режиме база ARCHIVELOG/NOARCHIVELOG?
select log_mode from v$database;

—включить ARCHIVELOG
shutdown immediate
startup mount
alter database archivelog;
alter database open;

—под sqlplus
archive log list
show parameter recovery_file_dest
show parameter recovery_file_dest_size

SELECT * FROM V$RECOVERY_FILE_DEST;
SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

—проверка
alter system switch logfile;
ALTER SYSTEM ARCHIVE LOG CURRENT;

—Время переключения (30 мин)
alter system set ARCHIVE_LAG_TARGET = 1800 scope=both;

— отключить DB_RECOVERY_FILE_DEST
ALTER SYSTEM RESET DB_RECOVERY_FILE_DEST SCOPE=spfile sid=’*’;

—выключить ARCHIVELOG
shutdown immediate;
startup mount;
alter database noarchivelog;
alter database open;