Archive Log: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (2 intermediate revisions by the same user not shown) | |||
| 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 25: | Line 26: | ||
STARTUP MOUNT | STARTUP MOUNT | ||
ALTER DATABASE ARCHIVELOG; | ALTER DATABASE ARCHIVELOG; | ||
ALTER DATABASE OPEN; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
==Reference File== | ==Reference File== | ||
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