Archive Log
Jump to navigation
Jump to search
- Database mode
SELECT LOG_MODE FROM SYS.V$DATABASE;
- Get Archive information
archive log list
- Change Archive file destination
alter system set log_archive_dest_1='Location=C:\oracle\E1Local\RDBMS\log';
- Limit the number of archiver running at the same time
alter system set log_archive_max_processes=2;
- Ativate Archive log
SHUTDOWN
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;