Archive Log: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
* Get Archive information | * Get Archive information | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
archive log list | archive log list; | ||
show parameter recovery_file_dest | |||
</syntaxhighlight> | </syntaxhighlight> | ||
| Line 19: | Line 20: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
* | * Activate Archive log | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
SHUTDOWN | SHUTDOWN | ||
| Line 25: | Line 26: | ||
ALTER DATABASE ARCHIVELOG; | ALTER DATABASE ARCHIVELOG; | ||
</syntaxhighlight> | </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 | |||
Revision as of 06:00, 28 May 2017
- 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