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>") |
No edit summary |
||
| Line 2: | Line 2: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
SELECT LOG_MODE FROM SYS.V$DATABASE; | SELECT LOG_MODE FROM SYS.V$DATABASE; | ||
</syntaxhighlight> | |||
* Get Archive information | |||
<syntaxhighlight lang="sql"> | |||
archive log list | |||
</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> | |||
* Ativate Archive log | |||
<syntaxhighlight lang="sql"> | |||
SHUTDOWN | |||
STARTUP MOUNT | |||
ALTER DATABASE ARCHIVELOG; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 05:50, 28 May 2017
- Database mode
SELECT LOG_MODE FROM SYS.V$DATABASE;
- Get Archive information
archive log list
- 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;
- Ativate Archive log
SHUTDOWN
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;