• 博客访问: 25482
  • 博文数量: 19
  • 用 户 组: 普通用户
  • 注册时间: 2009-06-11 09:46
个人简介

暂无介绍

文章存档

2009年(1)

2008年(18)

我的朋友

分类: Oracle

2008-11-28 17:38:42

Configure for multiple archiver processes

log_archive_max_processes=;

SELECT value
FROM gv$parameter
WHERE name = 'log_archive_max_processes';

ALTER SYSTEM SET log_archive_max_processes=3;

SELECT value
FROM gv$parameter
WHERE name = 'log_archive_max_processes';

Startup The Database In Archivelog Mode


Steps Required To Take A Database Not In Archive Log Mode And Alter It To Archive Log Mode

SELECT log_mode
FROM gv$database;

SHUTDOWN;

STARTUP MOUNT EXCLUSIVE;

ALTER DATABASE
ARCHIVELOG;

ALTER DATABASE OPEN;

SELECT log_mode
FROM gv$database;

Startup The Database In NoArchivelog Mode


Steps Required To Take A Database In Archive Log Mode And Alter It To No Archive Log Mode

SELECT log_mode
FROM gv$database;

SHUTDOWN;

STARTUP MOUNT EXCLUSIVE;

ALTER DATABASE
NOARCHIVELOG;

ALTER DATABASE OPEN;

SELECT log_mode
FROM gv$database;

Restart After Archiving Logging Failure

Archive Logging Restart

SHUTDOWN;

STARTUP;

ARCHIVE
LOG START;

ARCHIVE
LOG ALL;

Archive Log Related Commands

Start Archive Logging

alter system archive log start;

Stop Archive Logging

alter system archive log stop;

Force archiving of all log files

alter system archive log all;

Force archiving of the current log file

alter system archive log current;

[@more@]

阅读(1396) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册