Archive Log: Difference between revisions
Jump to navigation
Jump to search
| Line 26: | Line 26: | ||
STARTUP MOUNT | STARTUP MOUNT | ||
ALTER DATABASE ARCHIVELOG; | ALTER DATABASE ARCHIVELOG; | ||
ALTER DATABASE OPEN; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Latest revision as of 06:54, 28 May 2017
Activate Archive Log
- Validate Database mode
SELECT LOG_MODE FROM SYS.V$DATABASE;
- Get Archive information
archive log list;
show parameter recovery_file_dest
- 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;
- Activate Archive log
SHUTDOWN
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
Reference File
- V$DATABASE : select log_mode from v$database;
- V$ARCHIVED_LOG
- V$ARCHIVE_DEST : select DEST_NAME,STATUS,DESTINATION from V$ARCHIVE_DEST;
- V$ARCHIVE_PROCESSES
- V$BACKUP_REDOLOG
- V$LOG
- V$LOG_HISTORY