Archive Log: Difference between revisions
Jump to navigation
Jump to search
(Created page with "* Database mode <syntaxhighlight lang="sql"> SELECT LOG_MODE FROM SYS.V$DATABASE; </syntaxhighlight>") |
|||
| (4 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; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
* Get Archive information | |||
<syntaxhighlight lang="sql"> | |||
archive log list; | |||
show parameter recovery_file_dest | |||
</syntaxhighlight> | |||
* Change Archive file destination | |||
<syntaxhighlight lang="sql"> | |||
alter system set log_archive_dest_1='Location=C:\oracle\E1Local\RDBMS\log'; | |||
</syntaxhighlight> | |||
* Limit the number of archiver running at the same time | |||
<syntaxhighlight lang="sql"> | |||
alter system set log_archive_max_processes=2; | |||
</syntaxhighlight> | |||
* Activate Archive log | |||
<syntaxhighlight lang="sql"> | |||
SHUTDOWN | |||
STARTUP MOUNT | |||
ALTER DATABASE ARCHIVELOG; | |||
ALTER DATABASE OPEN; | |||
</syntaxhighlight> | |||
==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 | |||
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