Archive Log: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
* Database mode | == Activate ARchive Log == | ||
* Validate Database mode | |||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
SELECT LOG_MODE FROM SYS.V$DATABASE; | SELECT LOG_MODE FROM SYS.V$DATABASE; | ||
| Line 26: | Line 27: | ||
ALTER DATABASE ARCHIVELOG; | ALTER DATABASE ARCHIVELOG; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 06:50, 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;
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